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

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

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

To arrange the PivotTable columns and rows in Excel 2013,we use the:

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

In the snowflake schema,the ________ tables are normalized.

Slowly changing dimensions are handled by a(n):

What is a slowly changing dimension?

Compare the characteristics of an operational database and a dimensional database.

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

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

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

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:

Why is operational data sometimes unusable for Business Intelligence use?

Dimensional databases use the star schema.

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

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

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:

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

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

What are Business Intelligence (BI)systems?