Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Most of NoSQL nonrelational database methodologies are known as structured storage.

Accepted Answer

A) True 
 B)False

Question 3

Data warehouses also store the data warehouse metadata.

Accepted Answer

A) True 
 B)False

Question 4

RFM scores commonly range from ________,with ________ being the "high" or "most desirable" (from the vendor's point of view)score.

Accepted Answer

A) 0 to 5;0 
B) 0 to 5;5 
C) 1 to 5;1 
D) 1 to 5,5 
E) 1 to 10,10 
A) 0 to 5;0 
B) 0 to 5;5 
C) 1 to 5;1 
D) 1 to 5,5 
E) 1 to 10,10

Question 5

Which of the following are components of a data warehouse?

Accepted Answer

A) Data extract,transform,and load (ETL)preparation programs 
B) Data warehouse data 
C) Data warehouse metadata 
D) B and C 
E) A,B,and C 
A) Data extract,transform,and load (ETL)preparation programs 
B) Data warehouse data 
C) Data warehouse metadata 
D) B and C 
E) A,B,and C

Question 6

Dimensional databases are used to track historical data,and therefore must have a ________.

Accepted Answer

A) time dimension 
B) customer dimension 
C) sales dimension 
D) A or B 
E) A and B 
A) time dimension 
B) customer dimension 
C) sales dimension 
D) A or B 
E) A and B

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

What is a reporting system?

Accepted Answer

A reporting system is one of the main ca

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Google's Bigtable was an early example of structured storage.

Accepted Answer

A) True 
 B)False

Question 11

Business Intelligence (BI)systems support operational activities.

Accepted Answer

A) True 
 B)False

Question 12

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. 
E) Report Tools 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. 
E) Report Tools command tab.

Question 13

Structured storage column families are indistinguishable for relational database tables.

Accepted Answer

A) True 
 B)False

Question 14

What is a data warehouse?

Accepted Answer

A data warehouse is a nonoperational dat

Question 15

Star schemas have a ________ at the center of the star.

Accepted Answer

A) fact table 
B) dimension table 
C) map table 
D) reduce table 
E) None of the above 
A) fact table 
B) dimension table 
C) map table 
D) reduce table 
E) None of the above

Question 16

What is a Microsoft Excel PivotTable?

Accepted Answer

A PivotTable is the reporting mechanism

Question 17

In OLAP,the characteristic of a measure is called a ________.

Accepted Answer

A) level 
B) dimension 
C) measure 
D) member 
E) slice 
A) level 
B) dimension 
C) measure 
D) member 
E) slice

Question 18

Problematic data are called "dirty data."

Accepted Answer

A) True 
 B)False

Question 19

OLAP stands for ________.

Accepted Answer

A) OnLine Analytical Processing 
B) OffLine Analytical Processing 
C) OnLine Analysis Process 
D) OffLine Analysis Process 
E) Old,Lazy And Particular 
A) OnLine Analytical Processing 
B) OffLine Analytical Processing 
C) OnLine Analysis Process 
D) OffLine Analysis Process 
E) Old,Lazy And Particular

Question 20

In a common form of RFM analysis,a score of 1 is "high" or "good" while a score of 5 is "low" of "bad."

Accepted Answer

A) True 
 B)False

Exam 12: Big Data datawarehouse and Business Intelligence Systems

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

Most of NoSQL nonrelational database methodologies are known as structured storage.

Data warehouses also store the data warehouse metadata.

RFM scores commonly range from ________,with ________ being the "high" or "most desirable" (from the vendor's point of view)score.

Which of the following are components of a data warehouse?

Dimensional databases are used to track historical data,and therefore must have a ________.

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

What is a reporting system?

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

Google's Bigtable was an early example of structured storage.

Business Intelligence (BI)systems support operational activities.

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

Structured storage column families are indistinguishable for relational database tables.

What is a data warehouse?

Star schemas have a ________ at the center of the star.

What is a Microsoft Excel PivotTable?

In OLAP,the characteristic of a measure is called a ________.

Problematic data are called "dirty data."

OLAP stands for ________.

In a common form of RFM analysis,a score of 1 is "high" or "good" while a score of 5 is "low" of "bad."

Introduction

Introduction to Structured Query Language SQL

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

A: Managing Databases With SQL Server 20012

B: Managing Databases With Oracle Database 11g Release 2

C: Managing Databases With MySQL

The Web Server Environment

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 Eclipse PDT

Business Intelligence Systems

Filters

RFM scores commonly range from ,with being the "high" or "most desirable" (from the vendor's point of view)score.