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

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

Which of the following is true about data mining applications?

Hadoop is a(n)________.

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

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

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

Data Mining uses sophisticated statistical and mathematical techniques to perform what-if analyses,to make predictions,and to facilitate decision making.

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

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

Apache Cassandra is an example of a column family database.

A variant of the star schema is the ________.

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

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

A dimensional database uses a(n)________.

Business Intelligence (BI)systems are information systems that help users analyze and use data.

To format a PivotTable in Excel 2016,we use the ________.

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

In a snowflake schema,each dimension table is normalized.

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

A star schema resembles a star,with a dimension table at the center and fact tables radiating out from the center.