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

To use the Access 2013 database in an Excel 2013 PivotTable,it is generally useful to:

OLAP reports can be created using the Excel 2013 ________ tool.

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

Data warehouses use a(n):

Operational databases contain a fact table.

When creating an OLAP report based on Access 2013 data,it is often a good idea to create a view equivalent query to organize the data needed for the OLAP report.

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

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

BI reporting systems summarize the current status of business activities and compare that status with past events but not with predicted future activities.

Although Excel 2013 will create a PivotTable report using Access 2013 data,it does not have formatting tools that can be used with the report.

Distributed databases can be distributed by partitioning and ________.

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

What is a distributed database?

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

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

Non-relational DBMSs associated with the NoSQL movement include:

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

What is a reporting system?

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

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