Exam 8: Big Data Data Warehouses and Business Intelligence Systems

The term for the enormous datasets generated by Web 2.0 applications is ________.

Snowflake schemas have normalized:

Why is operational data sometimes unusable for Business Intelligence use?

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

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

To format an Excel 2013 PivotTable report,we use the ________ command tab.

A variant of the star schema is the ________.

Slowly changing dimensions are handled by a(n):

A(n)________ is an information system that helps users analyze and use data.

In the MapReduce process,the first step is the ________ step.

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

Business Intelligence (BI)reporting systems can analyze data using standard SQL.

Which of the following is a reason that operational data are difficult to read?

Describe how to create an OLAP report for a Microsoft Access 2013 database in Microsoft Excel 2013.

What is a distributed database?

The term drill down refers to the capability of seeing the data in smaller and smaller units.

Which of the following is true about data mining applications?

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

Dimensional databases are used for analytical data processing.

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