Question 1

To create an OLAP report for an Access 2013 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.

Question 2

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

Accepted Answer

A) fact table 
B) dimension table 
C) map table 
D) reduce table 
E) None of the above 
A) fact table 
B) dimension table 
C) map table 
D) reduce table 
E) None of the above

Question 3

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

Accepted Answer

The answer of The term ________ refers to the capability...

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) Filter data 
B) Group data 
C) Modify data 
D) Both A and B 
E) All of the above 
A) Filter data 
B) Group data 
C) Modify data 
D) Both A and B 
E) All of the above

Question 6

Data warehouses use a(n):

Accepted Answer

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

________ provides the ability to sum,count,average and perform other simple arithmetic operations on groups of data.

Accepted Answer

The answer of ________ provides the ability to sum,count,average and...

Question 9

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 10

When distributed databases break the database into sections and store the sections on different servers,this is known as:

Accepted Answer

A) replication. 
B) partitioning. 
C) disbursing. 
D) distributed two-phase locking. 
E) None of the above 
A) replication. 
B) partitioning. 
C) disbursing. 
D) distributed two-phase locking. 
E) None of the above

Question 11

What are Business Intelligence (BI)systems?

Accepted Answer

Business Intelligence (BI)systems are in

Question 12

Although Excel 2013 will create a PivotTable report using Access 2013 data,it does not have formatting tools that can be used with the report.

Accepted Answer

A) True 
 B)False

Question 13

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. 
E) None of the above 
A) replication. 
B) partitioning. 
C) disbursing. 
D) distributed two-phase locking. 
E) None of the above

Question 14

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) Both A and B 
E) All of the above 
A) Analyze current and past activities 
B) Predict future events 
C) Record and process transactions 
D) Both A and B 
E) All of the above

Question 15

Business Intelligence (BI)systems fall into two broad categories: ________ and ________.

Accepted Answer

reporting;

Question 16

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 17

Apache Cassandra is an example of a column family database.

Accepted Answer

A) True 
 B)False

Question 18

To create an OLAP report for an Access 2013 database,use the PivotTable tool in Access 2013.

Accepted Answer

A) True 
 B)False

Question 19

To use the Access 2013 database in an Excel 2013 PivotTable,it is generally useful to:

Accepted Answer

A) create a view-equivalent query in Access 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-equivalent query in Access 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 20

When creating an OLAP report based on Access 2013 data,it is often a good idea to create a(n)________ query to organize the data needed for the OLAP report.

Accepted Answer

The answer of When creating an OLAP report based on...

To create an OLAP report for an Access 2013 database,we can build a PivotTable in:

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

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

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

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

Data warehouses use a(n):

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

________ provides the ability to sum,count,average and perform other simple arithmetic operations on groups of data.

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

When distributed databases break the database into sections and store the sections on different servers,this is known as:

What are Business Intelligence (BI)systems?

Although Excel 2013 will create a PivotTable report using Access 2013 data,it does not have formatting tools that can be used with the report.

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

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

Business Intelligence (BI)systems fall into two broad categories: and .

The term drill down means the user wants to:

Apache Cassandra is an example of a column family database.

To create an OLAP report for an Access 2013 database,use the PivotTable tool in Access 2013.

To use the Access 2013 database in an Excel 2013 PivotTable,it is generally useful to:

When creating an OLAP report based on Access 2013 data,it is often a good idea to create a(n)________ query to organize the data needed for the OLAP report.

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 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters

Exam 8: Big Data Data Warehouses and Business Intelligence Systems

To create an OLAP report for an Access 2013 database,we can build a PivotTable in:

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

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

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

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

Data warehouses use a(n):

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

________ provides the ability to sum,count,average and perform other simple arithmetic operations on groups of data.

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

When distributed databases break the database into sections and store the sections on different servers,this is known as:

What are Business Intelligence (BI)systems?

Although Excel 2013 will create a PivotTable report using Access 2013 data,it does not have formatting tools that can be used with the report.

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

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

Business Intelligence (BI)systems fall into two broad categories: ________ and ________.

The term drill down means the user wants to:

Apache Cassandra is an example of a column family database.

To create an OLAP report for an Access 2013 database,use the PivotTable tool in Access 2013.

To use the Access 2013 database in an Excel 2013 PivotTable,it is generally useful to:

When creating an OLAP report based on Access 2013 data,it is often a good idea to create a(n)________ query to organize the data needed for the OLAP report.

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 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters

Business Intelligence (BI)systems fall into two broad categories: and .