Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Which of the following is true about data mining applications?

Accepted Answer

A)   They use sophisticated mathematical techniques.
B)   They use sophisticated statistical techniques.
C)   Their report delivery is more difficult than report delivery for reporting systems.
D)   Both A and B
E)   All of the above

Question 3

A variant of the star schema is the ________.

Accepted Answer

The answer of A variant of the star schema is...

Question 4

A Business Intelligence (BI) reporting system that uses extensions to SQL is:

Accepted Answer

A)   cluster analysis.
B)   OLAP.
C)   regression analysis.
D)   RFM analysis.
E)   All of the above

Question 5

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 6

Data warehouses are populated with data prepared by Extract,Transform,and Load (ETL)systems.

Accepted Answer

A) True 
 B)False

Question 7

Problematic data include so-called "dirty data."

Accepted Answer

A) True 
 B)False

Question 8

Apache Cassandra is an example of a(n)________ non-relational DBMS.

Accepted Answer

The answer of Apache Cassandra is an example of a(n)________...

Question 9

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.

Question 10

A(n)________ is an information system that helps users analyze and use data.

Accepted Answer

Business I...

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

Objects have ________,which are computer programs that perform some task.

Accepted Answer

The answer of Objects have ________,which are computer programs that...

Question 13

Business Intelligence (BI)systems support operational activities.

Accepted Answer

A) True 
 B)False

Question 14

Hadoop is a(n) :

Accepted Answer

A)   RDMBS.
B)   OODBMS.
C)   distributed file system (DFS) .
D)   print system.
E)   Web server.

Question 15

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 stored in a dimensional database.
D)   Both B and C
E)   All of the above

Question 16

To control the placement of columns and rows in an Excel 2013 PivotTable,we use the ________.

Accepted Answer

PivotTable...

Question 17

Data warehouse data is often stored in a(n)________.

Accepted Answer

dimensiona...

Question 18

NoSQL really stands for "Not only SQL."

Accepted Answer

A) True 
 B)False

Question 19

The term drill down means the user wants to:

Accepted Answer

A)   summarize data.
B)   get older data.
C)   sort data.
D)   get more details.
E)   aggregate data.

Question 20

To format an Excel 2013 PivotTable report,we use the ________ command tab.

Accepted Answer

The answer of To format an Excel 2013 PivotTable report,we...

Exam 8: Big Data, data Warehouses, and Business Intelligence Systems

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

Correct AnswerverifiedShow Answer

Apache Cassandra is an example of a(n)________ non-relational DBMS.

Correct AnswerverifiedShow Answer

OLAP stands for:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A Business Intelligence (BI) reporting system that uses extensions to SQL is:

Correct AnswerverifiedShow Answer

A variant of the star schema is the ________.

Correct AnswerverifiedShow Answer

Business Intelligence (BI)systems support operational activities.

Correct AnswerverifiedShow Answer

The term drill down means the user wants to:

Correct AnswerverifiedShow Answer

Which of the following is true about data mining applications?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A data warehouse database differs from an operational database because:

Correct AnswerverifiedShow Answer

A(n)________ is an information system that helps users analyze and use data.

Correct AnswerverifiedBusiness I...View AnswerShow Answer

NoSQL really stands for "Not only SQL."

Correct AnswerverifiedShow Answer

Problematic data include so-called "dirty data."

Correct AnswerverifiedShow Answer

Data warehouses are populated with data prepared by Extract,Transform,and Load (ETL)systems.

Correct AnswerverifiedShow Answer

Objects have ________,which are computer programs that perform some task.

Correct AnswerverifiedShow Answer

To format an Excel 2013 PivotTable report,we use the ________ command tab.

Correct AnswerverifiedShow Answer

Data warehouse data is often stored in a(n)________.

Correct Answerverifieddimensiona...View AnswerShow Answer

Hadoop is a(n) :

Correct AnswerverifiedShow Answer

To control the placement of columns and rows in an Excel 2013 PivotTable,we use the ________.

Correct AnswerverifiedPivotTable...View AnswerShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Business I...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
dimensiona...
View Answer

Correct Answer
verified

Correct Answer
verified
PivotTable...
View Answer