Question 1

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...

Question 2

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

Accepted Answer

PivotTable

Question 3

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 
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 4

A variant of the star schema is the ________.

Accepted Answer

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

Question 5

Problematic data include so-called "dirty data."

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

NoSQL really stands for "Not only SQL."

Accepted Answer

A) True 
 B)False

Question 8

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 
A)  cluster analysis. 
B)  OLAP. 
C)  regression analysis. 
D)  RFM analysis. 
E)  All of the above

Question 9

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

Accepted Answer

Business I

Question 10

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. 
A)  summarize data. 
B)  get older data. 
C)  sort data. 
D)  get more details. 
E)  aggregate data.

Question 11

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

Accepted Answer

dimensiona

Question 12

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 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Hadoop is a(n):

Accepted Answer

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

Question 16

Business Intelligence (BI)systems support operational activities.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 19

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 
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 20

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.

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

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

Which of the following is true about data mining applications?

A variant of the star schema is the ________.

Problematic data include so-called "dirty data."

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

NoSQL really stands for "Not only SQL."

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

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

The term drill down means the user wants to:

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

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

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

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

Hadoop is a(n):

Business Intelligence (BI)systems support operational activities.

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

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

A data warehouse database differs from an operational database because:

OLAP stands for:

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity-Relationship Model

Database Design

Database Administration

Database Processing Applications

Getting Started With Microsoft Sql Server 2012

Getting Started With Oracle Database 11g Release 2

Getting Started With Mysql 56 Community Server

James River Jewelry Project Questions

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Getting Started With Web Servers, php, and the Netbeans IDE

Business Intelligence Systems

Filters

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

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

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

Which of the following is true about data mining applications?

A variant of the star schema is the ________.

Problematic data include so-called "dirty data."

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

NoSQL really stands for "Not only SQL."

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

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

The term drill down means the user wants to:

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

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

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

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

Hadoop is a(n):

Business Intelligence (BI)systems support operational activities.

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

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

A data warehouse database differs from an operational database because:

OLAP stands for:

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity-Relationship Model

Database Design

Database Administration

Database Processing Applications

Getting Started With Microsoft Sql Server 2012

Getting Started With Oracle Database 11g Release 2

Getting Started With Mysql 56 Community Server

James River Jewelry Project Questions

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Getting Started With Web Servers, php, and the Netbeans IDE

Business Intelligence Systems

Filters