Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 
A) 0 to 5;0 
B) 0 to 5;5 
C) 1 to 5;1 
D) 1 to 5,5

Question 4

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 5

When distributed databases create copies of the database 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

Question 6

We have done an RFM analysis on our customer data.John Smith has a score of {5 1 1}.This means that John ________.

Accepted Answer

A) has ordered recently,and orders a lot when he orders 
B) hasn't ordered recently,but orders a lot when he orders 
C) has ordered recently,but doesn't order a lot when he orders 
D) hasn't ordered recently,and doesn't order a lot when he orders 
A) has ordered recently,and orders a lot when he orders 
B) hasn't ordered recently,but orders a lot when he orders 
C) has ordered recently,but doesn't order a lot when he orders 
D) hasn't ordered recently,and doesn't order a lot when he orders

Question 7

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

Accepted Answer

A) fact table 
B) dimension table 
C) map table 
D) reduce table 
A) fact table 
B) dimension table 
C) map table 
D) reduce table

Question 8

In a snowflake table,each dimension table is normalized.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is not a reason that operational data are difficult to read?

Accepted Answer

A) Dirty data 
B) Current data 
C) Nonintegrated data 
D) Missing values 
A) Dirty data 
B) Current data 
C) Nonintegrated data 
D) Missing values

Question 10

Problematic data are called dirty data.

Accepted Answer

A) True 
 B)False

Question 11

Each of the following is an example of a cloud computing platform except ________.

Accepted Answer

A) SQL Server 2014 Express 
B) Amazon Web Services 
C) Google Business Solutions 
D) Windows Azure 
A) SQL Server 2014 Express 
B) Amazon Web Services 
C) Google Business Solutions 
D) Windows Azure

Question 12

What is a data warehouse?

Accepted Answer

A data warehouse is a nonoperational dat

Question 13

OLAP stands for ________.

Accepted Answer

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

Question 14

Microsoft Excel 2013 allows us to connect directly to an SQL Server 2014 database when building a PivotTable.

Accepted Answer

A) True 
 B)False

Question 15

The "R" in RFM analysis stands for ________.

Accepted Answer

A) rank 
B) recent 
C) relationship 
D) readiness 
A) rank 
B) recent 
C) relationship 
D) readiness

Question 16

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

Accepted Answer

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

Question 17

The movement that uses different database methods than the relational model and/or SQL is called the NoSQL movement.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

In RFM analysis,M stands for "how much money."

Accepted Answer

A) True 
 B)False

Question 20

Data warehouses often include data purchased from outside vendors.

Accepted Answer

A) True 
 B)False

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

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

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

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

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

When distributed databases create copies of the database on different servers,this is known as ________.

We have done an RFM analysis on our customer data.John Smith has a score of {5 1 1}.This means that John ________.

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

In a snowflake table,each dimension table is normalized.

Which of the following is not a reason that operational data are difficult to read?

Problematic data are called dirty data.

Each of the following is an example of a cloud computing platform except ________.

What is a data warehouse?

OLAP stands for ________.

Microsoft Excel 2013 allows us to connect directly to an SQL Server 2014 database when building a PivotTable.

The "R" in RFM analysis stands for ________.

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

The movement that uses different database methods than the relational model and/or SQL is called the NoSQL movement.

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

In RFM analysis,M stands for "how much money."

Data warehouses often include data purchased from outside vendors.

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

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