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

Business Intelligence (BI)systems obtain data from three possible sources.

To deal with data values that change over time,dimensional databases use a(n)________.

Data warehouses are populated with data prepared by ________ programs.

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

Operational databases store historical data.

To create an OLAP report for an Access 2016 database,we can build a PivotTable in ________.

Virtualization is using hardware and software to simulate another software application.

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.

In the MapReduce process,the Reduce step is followed by the Map step.

A data mart differs from a data warehouse in these ways except ________.

The term drill down means the user wants to ________.

Apache Cassandra is an example of a(n)________ non-relational DBMS.

What are objects,and how are they related to the object-oriented DBMS (OODBMS)?

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

When distributed databases break the database into sections and store the sections on different servers,this is known as ________.

Problematic data are called ________.

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

What is a conformed dimension?