Exam 8: Big Data Data Warehouses and Business Intelligence Systems

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

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

What is a slowly changing dimension?

Data mining applications are used to accomplish which of the following tasks?

Data warehouses are populated with data prepared by Extract,Transform,and Load (ETL)systems.

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:

In a snowflake table,each dimension table is normalized.

To format a PivotTable in Excel 2013,we use the:

Problematic data are called ________.

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

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

In the snowflake schema,the ________ tables are normalized.

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

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

OLAP reports can be created using the Excel 2013 ________ tool.

What is a reporting system?

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

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

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

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