Question 1

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

Accepted Answer

A) column 
B) reduce 
C) column family 
D) map 
A) column 
B) reduce 
C) column family 
D) map

Question 2

Operational databases contain a fact table.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) Design command tab in the PivotTable Tools contextual command tab 
B) Format command tab in the PivotTable Tools contextual command tab 
C) Design command tab in the Report Tools contextual command tab 
D) Format command tab in the Report Tools contextual command tab 
A) Design command tab in the PivotTable Tools contextual command tab 
B) Format command tab in the PivotTable Tools contextual command tab 
C) Design command tab in the Report Tools contextual command tab 
D) Format command tab in the Report Tools contextual command tab

Question 4

What is a Microsoft Excel PivotTable?

Accepted Answer

A PivotTable is the reporting mechanism

Question 5

________ is a DBMS that provides a full set of object-relational features.

Accepted Answer

A) Oracle Database 
B) Microsoft Access 
C) Microsoft SQL Server 2014 
D) MySQL 
A) Oracle Database 
B) Microsoft Access 
C) Microsoft SQL Server 2014 
D) MySQL

Question 6

Why is operational data sometimes unusable for Business Intelligence (BI)use? Include at least two examples.

Accepted Answer

Data in operational databases can suffer

Question 7

A data mart differs from a data warehouse in that ________.

Accepted Answer

A) it has a larger database 
B) it deals with a particular component or functional area of the business 
C) data mart users must have more data management expertise than data warehouse employees 
D) it is updated more frequently by the data mart users 
A) it has a larger database 
B) it deals with a particular component or functional area of the business 
C) data mart users must have more data management expertise than data warehouse employees 
D) it is updated more frequently by the data mart users

Question 8

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

Accepted Answer

A) replication 
B) partitioning 
C) disbursing 
D) distributed two-phase locking 
A) replication 
B) partitioning 
C) disbursing 
D) distributed two-phase locking

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

Operational databases contain a fact table.

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

What is a Microsoft Excel PivotTable?

________ is a DBMS that provides a full set of object-relational features.

Why is operational data sometimes unusable for Business Intelligence (BI)use? Include at least two examples.

A data mart differs from a data warehouse in that ________.

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

Introduction

Introduction to Structured Query Language

The Relational Model and Normalization

Database Design Using Normalization

Data Modeling With the Entity-Relationship Model

Transforming Data Models Into Database Designs

SQL for Database Construction and Application Processing

Database Redesign

Managing Multiuser Databases

Managing Databases With SQL Server 2014

Managing Databases With Oracle Database

Managing Databases With Mysql 5.6

The Web Server Environment

Getting Started With Microsoft Access 2013

Getting Started With Systems Analysis and Design

E-R Diagrams and the IDEF1X Standard

E-R Diagrams and the UML Standard

Getting Started With Mysql Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2013

Data Structures for Database Processing

the Semantic Object Model

Getting Started With Web Servers, PHP, and the Netbeans IDE

Business Intelligence Systems

Big Data

Filters

Exam 14: Big Data, Data-Warehouses, and Business Intelligence Systems

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

Operational databases contain a fact table.

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

What is a Microsoft Excel PivotTable?

________ is a DBMS that provides a full set of object-relational features.

Why is operational data sometimes unusable for Business Intelligence (BI)use? Include at least two examples.

A data mart differs from a data warehouse in that ________.

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

Introduction

Introduction to Structured Query Language

The Relational Model and Normalization

Database Design Using Normalization

Data Modeling With the Entity-Relationship Model

Transforming Data Models Into Database Designs

SQL for Database Construction and Application Processing

Database Redesign

Managing Multiuser Databases

Managing Databases With SQL Server 2014

Managing Databases With Oracle Database

Managing Databases With Mysql 5.6

The Web Server Environment

Getting Started With Microsoft Access 2013

Getting Started With Systems Analysis and Design

E-R Diagrams and the IDEF1X Standard

E-R Diagrams and the UML Standard

Getting Started With Mysql Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2013

Data Structures for Database Processing

the Semantic Object Model

Getting Started With Web Servers, PHP, and the Netbeans IDE

Business Intelligence Systems

Big Data

Filters