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

What is a Microsoft Excel PivotTable?

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

Operational databases contain a fact table.

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

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

Why is operational data sometimes unusable for Business Intelligence use?

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

What is a distributed database?

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

In the snowflake schema,the ________ tables are normalized.

Business Intelligence (BI)systems support operational activities.

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

OLAP stands for ________.

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

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.

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.

Dimensional databases are used for analytical data processing.

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

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

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