Question 1

Slowly changing dimensions are handled by a(n)________.

Accepted Answer

A) operational database 
B) dimensional database 
C) structured storage 
D) A or B 
E) All of the above 
A) operational database 
B) dimensional database 
C) structured storage 
D) A or B 
E) All of the above

Question 2

An OLAP cube is called that because some products show OLAP displays on ________ axes.

Accepted Answer

A) one 
B) two 
C) three 
D) four 
E) a number that varies depending upon the analysis being done 
A) one 
B) two 
C) three 
D) four 
E) a number that varies depending upon the analysis being done

Question 3

What are Business Intelligence (BI)systems?

Accepted Answer

Business Intelligence (BI)systems are in

Question 4

In RFM analysis,F stands for "how frequently."

Accepted Answer

A) True 
 B)False

Question 5

A data warehouse database differs from an operational database because:

Accepted Answer

A) data warehouse data are not stored in tables. 
B) data warehouse databases do not have metadata. 
C) data warehouse data are often denormalized. 
D) B and C 
E) A,B,and C 
A) data warehouse data are not stored in tables. 
B) data warehouse databases do not have metadata. 
C) data warehouse data are often denormalized. 
D) B and C 
E) A,B,and C

Question 6

Compare the characteristics of an operational database and a dimensional database.

Accepted Answer

An operational database is used for stru

Question 7

Operational databases contain a fact table.

Accepted Answer

A) True 
 B)False

Question 8

To use an SQL Server 2012 database in an Microsoft Excel 2013 PivotTable,it is generally useful to:

Accepted Answer

A) create a view in SQL Server 2012 to organize the data. 
B) store the needed data in an Excel worksheet. 
C) store the needed data in a Word document. 
D) store the needed data in a PowerPoint slide show. 
E) store the needed data in a Visio diagram. 
A) create a view in SQL Server 2012 to organize the data. 
B) store the needed data in an Excel worksheet. 
C) store the needed data in a Word document. 
D) store the needed data in a PowerPoint slide show. 
E) store the needed data in a Visio diagram.

Question 9

The structured storage equivalent of an RDBMS table is a ________.

Accepted Answer

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

Question 10

Operational databases store historical data.

Accepted Answer

A) True 
 B)False

Question 11

RFM analysis analyzes and ranks customers based on:

Accepted Answer

A) their purchasing patterns. 
B) their income status. 
C) their residential location. 
D) A and B 
E) A,B,and C 
A) their purchasing patterns. 
B) their income status. 
C) their residential location. 
D) A and B 
E) A,B,and C

Question 12

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

Accepted Answer

A) Analyze current and past activities 
B) Predict future events 
C) Record and process transactions 
D) A and B 
E) A,B,and C 
A) Analyze current and past activities 
B) Predict future events 
C) Record and process transactions 
D) A and B 
E) A,B,and C

Question 13

What is a slowly changing dimension?

Accepted Answer

A slowly changing dimension is an attrib

Question 14

In a common form of RFM analysis,customers with an R score of 5 are in the 20% of customers who have the most recent orders.

Accepted Answer

A) True 
 B)False

Question 15

Business Intelligence (BI)systems obtain their data by which of the following means?

Accepted Answer

A) Read and process data from an operational database 
B) Process extracts from operational databases 
C) Process data purchased from data vendors 
D) A and B 
E) A,B,and C 
A) Read and process data from an operational database 
B) Process extracts from operational databases 
C) Process data purchased from data vendors 
D) A and B 
E) A,B,and C

Question 16

Metadata about the data's source,format,assumptions and constraints are kept in a data warehouse metadata database.

Accepted Answer

A) True 
 B)False

Question 17

What is the NoSQL movement?

Accepted Answer

The NoSQL movement is a school of though

Question 18

Business Intelligence (BI)reporting systems can analyze data using standard SQL.

Accepted Answer

A) True 
 B)False

Question 19

Microsoft Excel 2013 cannot import SQL Server 2013 data directly into a PivotTable report,but must first place the data into a worksheet.

Accepted Answer

A) True 
 B)False

Question 20

In a common form of RFM analysis,customers are sorted into five groups and given an associated score depending on their group.

Accepted Answer

A) True 
 B)False

Exam 12: Big Data datawarehouse and Business Intelligence Systems

Slowly changing dimensions are handled by a(n)________.

An OLAP cube is called that because some products show OLAP displays on ________ axes.

What are Business Intelligence (BI)systems?

In RFM analysis,F stands for "how frequently."

A data warehouse database differs from an operational database because:

Compare the characteristics of an operational database and a dimensional database.

Operational databases contain a fact table.

To use an SQL Server 2012 database in an Microsoft Excel 2013 PivotTable,it is generally useful to:

The structured storage equivalent of an RDBMS table is a ________.

Operational databases store historical data.

RFM analysis analyzes and ranks customers based on:

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

What is a slowly changing dimension?

In a common form of RFM analysis,customers with an R score of 5 are in the 20% of customers who have the most recent orders.

Business Intelligence (BI)systems obtain their data by which of the following means?

Metadata about the data's source,format,assumptions and constraints are kept in a data warehouse metadata database.

What is the NoSQL movement?

Business Intelligence (BI)reporting systems can analyze data using standard SQL.

Microsoft Excel 2013 cannot import SQL Server 2013 data directly into a PivotTable report,but must first place the data into a worksheet.

In a common form of RFM analysis,customers are sorted into five groups and given an associated score depending on their group.

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