Question 1

Most data mining techniques are simple and easy to use.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) Dirty data 
B) Missing values 
C) Nonintegrated data 
D) A and B 
E) A,B,and C 
A) Dirty data 
B) Missing values 
C) Nonintegrated data 
D) A and B 
E) A,B,and C

Question 3

Data mining is the application of mathematical and statistical techniques to find patterns and relationships that can be used to classify and predict future outcomes.

Accepted Answer

A) True 
 B)False

Question 4

A star schema resembles a star,with a dimension table at the center and fact tables radiating out from the center.

Accepted Answer

A) True 
 B)False

Question 5

A data warehouse is a database system that has data,programs and personnel specialized in Business Intelligence (BI)processing.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) Filter data 
B) Group data 
C) Modify data 
D) A and B 
E) A,B,and C 
A) Filter data 
B) Group data 
C) Modify data 
D) A and B 
E) A,B,and C

Question 9

We have obtained access to the company's operational data.In one record,we find that a customer's age has been recorded as "337." This is an example of ________.

Accepted Answer

A) dirty data 
B) inconsistent data 
C) nonintegrated data 
D) a "wrong format" problem 
E) a "too much data" problem 
A) dirty data 
B) inconsistent data 
C) nonintegrated data 
D) a "wrong format" problem 
E) a "too much data" problem

Question 10

A Business Intelligence (BI)reporting system:

Accepted Answer

A) creates meaningful information from disparate data sources. 
B) delivers information to users on a timely basis. 
C) uses statistical procedures to predict future events. 
D) A and B 
E) A,B,and C 
A) creates meaningful information from disparate data sources. 
B) delivers information to users on a timely basis. 
C) uses statistical procedures to predict future events. 
D) A and B 
E) A,B,and C

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

Data warehouses are populated with data prepared by data extraction,transformation and load (ETL)programs.

Accepted Answer

A) True 
 B)False

Question 13

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. 
E) None of the above is correct. 
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. 
E) None of the above is correct.

Question 14

Dimensional databases are used for analytical data processing.

Accepted Answer

A) True 
 B)False

Question 15

Big Data is the name given to the enormous datasets generated by Web 2.0 applications.

Accepted Answer

A) True 
 B)False

Question 16

Business Intelligence (BI)reporting systems are used to filter data,sort data,group data and make simple calculations based on the data.

Accepted Answer

A) True 
 B)False

Question 17

In a common form of RFM analysis,an RFM score of {5 1 1} means that the customer orders frequently and orders items of high monetary value but has not ordered anything for some time.

Accepted Answer

A) True 
 B)False

Question 18

The "M" in RFM analysis stands for ________.

Accepted Answer

A) money 
B) mostly 
C) modest 
D) modern 
E) modem 
A) money 
B) mostly 
C) modest 
D) modern 
E) modem

Question 19

Data mining applications are used to accomplish which of the following tasks?

Accepted Answer

A) Perform what-if analysis 
B) Make predications 
C) Facilitate decision making 
D) A and B 
E) A,B,and C 
A) Perform what-if analysis 
B) Make predications 
C) Facilitate decision making 
D) A and B 
E) A,B,and C

Question 20

To create an OLAP report for an SQL Server 2012 database,we can build a PivotTable in:

Accepted Answer

A) Microsoft Access 2013. 
B) Microsoft Word 2013. 
C) Microsoft Visio 2013. 
D) Microsoft Excel 2013. 
E) Microsoft PowerPoint 2013. 
A) Microsoft Access 2013. 
B) Microsoft Word 2013. 
C) Microsoft Visio 2013. 
D) Microsoft Excel 2013. 
E) Microsoft PowerPoint 2013.

Exam 12: Big Data datawarehouse and Business Intelligence Systems

Most data mining techniques are simple and easy to use.

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

Data mining is the application of mathematical and statistical techniques to find patterns and relationships that can be used to classify and predict future outcomes.

A star schema resembles a star,with a dimension table at the center and fact tables radiating out from the center.

A data warehouse is a database system that has data,programs and personnel specialized in Business Intelligence (BI)processing.

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

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

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

We have obtained access to the company's operational data.In one record,we find that a customer's age has been recorded as "337." This is an example of ________.

A Business Intelligence (BI)reporting system:

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

Data warehouses are populated with data prepared by data extraction,transformation and load (ETL)programs.

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

Dimensional databases are used for analytical data processing.

Big Data is the name given to the enormous datasets generated by Web 2.0 applications.

Business Intelligence (BI)reporting systems are used to filter data,sort data,group data and make simple calculations based on the data.

In a common form of RFM analysis,an RFM score of {5 1 1} means that the customer orders frequently and orders items of high monetary value but has not ordered anything for some time.

The "M" in RFM analysis stands for ________.

Data mining applications are used to accomplish which of the following tasks?

To create an OLAP report for an SQL Server 2012 database,we can build a PivotTable in:

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