Exam 8: Big Data, data Warehouses, and Business Intelligence Systems

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

To use Access 2013 data in an Excel 2013 PivotTable,we use the:

In a snowflake table,each dimension table is normalized.

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

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

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

A(n)________ is a collection of data that addresses a particular component or functional area of a business.

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

Business Intelligence (BI)systems fall into which of the following categories?

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

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

Operational databases store historical data.

Hadoop is a(n)________.

Dimensional databases are used for analytical data processing.

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

What is a data warehouse?

What is a Microsoft Excel PivotTable?

Business Intelligence (BI)systems obtain their data by which of the following means?

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