Chapter 8

To use Access 2016 data in an Excel 2016 PivotTable, we use the ________.

"From Access" command on the Excel Data command tab

Business Intelligence (BI) systems do which of the following?

1. Analyze current and past activities 2. Predict future events

Business Intelligence (BI) reporting systems can do which of the following operations?

1. Filter data 2. Group data

Business Intelligence (BI) systems fall into which categories?

1. Reporting 2. Data mining

Which is true about data mining applications?

1. They use sophisticated mathematical techniques. 2. They use sophisticated statistical techniques.

Dimensional databases are used to track historical data and therefore must have a ________.

1. time dimension 2. customer dimension

Distributed database

A database that has been partitioned, replicated or both. Partitioning means breaking up the database into sections, and then storing those sections on separate computers. Replicating means making copies of the database, and then storing those copies on separate computers.

Conformed dimension

A dimension table in a data warehouse that is used in more than one star schema. Since the same table is reused, we can be sure that the data is consistent within each start schema.

The term for the enormous datasets generated by Web 2.0 applications is ________.

Big Data

A(n) ________ is an information system that helps users analyze and use data.

Business Intelligence (BI) system

Apache Cassandra is an example of a(n) ________ non-relational DBMS.

Column family

To format an Excel 2016 PivotTable report, we use the ________ command tab.

Design

To format a PivotTable in Excel 2016, we use the ________.

Design command tab in the PivotTable Tools contextual command tab

Data warehouses are populated with data prepared by ________ programs.

Extract, Transform and Load (ETL)

) Business Intelligence (BI) systems support operational activities.

FALSE

A star schema resembles a star, with a dimension table at the center and fact tables radiating out from the center.

FALSE

Although Excel 2016 will create a PivotTable report using Access 2016 data, it does not have formatting tools that can be used with the report.

FALSE

BI reporting systems summarize the current status of business activities and compare that status with past events but not with predicted future activities.

FALSE

Column family databases are indistinguishable from relational database tables.

FALSE

Excel 2016 cannot import Access 2016 data directly into a PivotTable report, but must first place the data into a worksheet.

FALSE

In the MapReduce process, the Reduce step is followed by the Map step.

FALSE

Operational databases contain a fact table.

FALSE

Operational databases store historical data.

FALSE

Report delivery is more important for data mining than it is for reporting systems.

FALSE

To create an OLAP report for an Access 2016 database, use the PivotTable tool in Access 2016.

FALSE

Virtualization is using hardware and software to simulate another software application.

FALSE

Non-relational DBMSs associated with the NoSQL movement include all of the following except ________.

Hierarchical

To create an OLAP report for an Access 2016 database, we can build a PivotTable in ________.

Microsoft Excel 2016

A Business Intelligence (BI) reporting system that uses extensions to SQL is ________.

OLAP

________ provides the ability to sum, count, average and perform other simple arithmetic operations on groups of data.

OLAP

OLAP stands for ________.

Online Analytical Processing

To create an OLAP report for an Access 2016 database, use the ________ tool in Excel 2016.

PivotTable

To arrange the PivotTable columns and rows in Excel 2016, we use the ________.

PivotTable Field List

To control the placement of columns and rows in an Excel 2016 PivotTable, we use the ________.

PivotTable Field List

A data mart is a collection of data that addresses a particular component or functional area of a business.

TRUE

A data warehouse is a database system that has data and programs for, as well as personnel specialized in, BI processing.

TRUE

Apache Cassandra is an example of a column family database.

TRUE

Big Data is the name given to the enormous datasets generated by Web 2.0 applications.

TRUE

Business Intelligence (BI) reporting systems are used to filter data, sort data, group data and make simple calculations based on the data.

TRUE

Business Intelligence (BI) reporting systems can analyze data using standard SQL.

TRUE

Business Intelligence (BI) systems are information systems that help users analyze and use data.

TRUE

Business Intelligence (BI) systems obtain data from three possible sources.

TRUE

Data Mining uses sophisticated statistical and mathematical techniques to perform what-if analyses, to make predictions, and to facilitate decision making.

TRUE

Data warehouses are populated with data prepared by extract, transform, and load (ETL) systems.

TRUE

Dimensional databases are used for analytical data processing.

TRUE

Dimensional databases use the star schema.

TRUE

Excel 2016 allows us to connect directly to an Access 2016 database when building a PivotTable.

TRUE

In a snowflake schema, each dimension table is normalized.

TRUE

NoSQL really stands for "Not only SQL."

TRUE

OLAP provides the ability to sum, count, average and perform other simple arithmetic operations on groups of data.

TRUE

Problematic data include so-called "dirty data."

TRUE

The simplest way to lease cloud services is SaaS.

TRUE

The term drill down refers to the capability of seeing the data in smaller and smaller units.

TRUE

When creating an OLAP report based on Access 2016 data, it is often a good idea to create a view equivalent query to organize the data needed for the OLAP report.

TRUE

Microsoft Excel PivotTable

The reporting mechanism Microsoft Excel uses to display OLAP reports. Both measures (a dimensional database "fact") and dimensions are displayed and can be rearranged. Drill-down is also available.

Which is a reason that operational data are difficult to read?

Time-critical data

Data mining applications are used to accomplish all of the following tasks except ________.

classify entities

To use the Access 2016 database in an Excel 2016 PivotTable, it is generally useful to ________.

create a view-equivalent query in Access to organize the data

Business Intelligence (BI) ________ uses sophisticated statistical and mathematical techniques to perform what-if analyses, to make predictions, and to facilitate decision making.

data mining

A data warehouse database differs from an operational database because ________.

data warehouse data are often stored in a dimensional database

A data mart differs from a data warehouse in these ways except ________.

data warehouses receive their data from the data marts

In the snowflake schema, the ________ tables are normalized.

dimension

Snowflake schemas have normalized ________.

dimension tables

Data warehouse data is often stored in a(n) ________.

dimensional database

Data warehouses use a(n) ________.

dimensional database

Slowly changing dimensions are handled by a(n) ________.

dimensional database

We have obtained access to the company's operational data. In one record, we find that a customer's age has been recorded as "337." This is an example of ________.

dirty data

Hadoop is a(n) ________.

distributed file system (DFS)

The term ________ refers to the capability of seeing the data in smaller and smaller units.

drill down

Star schemas have a ________ at the center of the star.

fact table

The term drill down means the user wants to ________.

get more details

We have obtained access to the company's operational data. We examine 50 records for customers with phone numbers that should use the current area code of 345. Of these 50 records, we find 10 that still use an older area code of 567. This is an example of ________.

inconsistent data

Excel 2016 allows us to ________ to an Access 2016 database when building a PivotTable.

link directly

In the MapReduce process, the first step is the ________ step.

map

Objects have ________, which are computer programs that perform some task.

methods

When distributed databases break the database into sections and store the sections on different servers, this is known as ________.

partitioning

When distributed databases create copies of the database on different servers, this is known as ________.

replication

Business Intelligence (BI) ________ are used to filter data, sort data, group data and make simple calculations based on the data.

reporting systems

Business Intelligence (BI) systems fall into two broad categories: ________ and ________.

reporting; data mining

To deal with data values that change over time, dimensional databases use a(n) ________.

slowly changing dimension

A variant of the star schema is the ________.

snowflake schema

A dimensional database uses a(n) ________.

star schema

Business Intelligence (BI) systems obtain data in ________ different ways.

three

To deal with historical data values, dimensional databases use a(n) ________.

time dimension; date dimension

When creating an OLAP report based on Access 2016 data, it is often a good idea to create a(n) ________ query to organize the data needed for the OLAP report.

view equivalent