BCOR 330: Chapter 4

When working in Tableau, users can assume which three roles?

Explorers creators viewers

RAM storage and ________ processing are two main in-memory computing components.

parallel

Which three of the following are examples of data transformation?

copying or replicating data standardizing names and variables across data sets the deletion of database fields or records to ensure data integrity

The 3-step data visualization process consists of exploring the data sets for pattern, then planning for visuals, and finally

creating your visuals.

Trends in data analytics include which three of the following?

data analytics as a core business function composable data virtual analytics scalable AI

________ is software with processing capabilities outside of what the operating system of the consumer provides.

middlewear

Database administrators ________ and troubleshoot the database (if needed) to ensure it is stable and usable when needed.

monitor

In order to make understanding and interpretation of SQL queries easier, users have the ability to add comments. The symbol(s) that will tell SQL that an entry is a comment and should not be used in the query is(are)

two dashes: "- -."

When multiple lists and data integrity. sources are maintained, information can become ________, leading to decreased data

Inconsistent

The main objectives of data governance include high-quality data and which other goals?

risk mitigation rules for data use compliance to requirements cost reduction high-quality data.

For data to be considered open data, it must have what three characteristics?

Datasets must be universally available so that anyone can use the data Datasets must have access rights that allow them to be reused and redistributed, The public must have access and datasets must be available for use.

Online Analytical Processing (OLAP) is included in many Business Intelligence (BI) software applications. We use this OLAP for a range of ________ discovery activities, including report creation and analysis, analytical calculations, forecasting, budgeting, planning, and what-if predicative analysis.

data

The main tools used by data analysts include which three of the following?

data visualization tools databases and query languages spreadsheets

Reports offer a way to view, format, and summarize the information in a ________.

databases

Databases are designed to maintain data and information about various types of data objects, including ________.

events places people

Data redundancy can lead to which three of the following?

increased storage fees increased inefficient access times inconsistent data

Qualitative data that is not categorized is called nominal data. Qualitative data that is categorized (ranked, for example) is considered _____ data.

ordinal

A major trend in data analytics is the use of artificial intelligence to focus on small data which is more precise, using small datasets that are capable of impacting decisions in the present. This is known as ______ AI.

scalable

An independent data mart is a(n) ________ system created separate from a data warehouse and focused on specific organizational functions.

stand-alone

SQL allows users to isolate specific information contained in a database, as well as to aid in the selection, creation, addition, and extraction of data from a database. SQL stands for ______ query language.

structured