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

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

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

What is a reporting system?

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

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

What are Business Intelligence (BI)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 ________.

What is a data warehouse?

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 ________.

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

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

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

Column family databases are indistinguishable from relational database tables.

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

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

Problematic data include so-called "dirty data."

Hadoop is a(n)________.

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

What is a star schema?

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