Question 1

A data warehouse is a database system that has data and programs for,as well as personnel specialized in,BI processing.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

The answer of Business Intelligence (BI)________ are used to filter...

Question 3

What are objects,and how are they related to the object-oriented DBMS (OODBMS)?

Accepted Answer

An object-oriented DBMS is designed to s

Question 4

Column family databases are indistinguishable from relational database tables.

Accepted Answer

A) True 
 B)False

Question 5

Operational databases contain a fact table.

Accepted Answer

A) True 
 B)False

Question 6

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 7

Operational databases store historical data.

Accepted Answer

A) True 
 B)False

Question 8

Dimensional databases use the star schema.

Accepted Answer

A) True 
 B)False

Question 9

Business Intelligence (BI)systems fall into which of the following categories?

Accepted Answer

A) Processing 
B) Reporting 
C) Data mining 
D) Both A and B 
E) Both B and C 
A) Processing 
B) Reporting 
C) Data mining 
D) Both A and B 
E) Both B and C

Question 10

A data mart is a collection of data that addresses a particular component or functional area of a business.

Accepted Answer

A) True 
 B)False

Question 11

A data mart differs from a data warehouse in that:

Accepted Answer

A) it has a smaller database. 
B) it deals with a particular component or functional area of the business. 
C) data mart users do not have the data management expertise of data warehouse employees. 
D) Both A and B 
E) All of the above 
A) it has a smaller database. 
B) it deals with a particular component or functional area of the business. 
C) data mart users do not have the data management expertise of data warehouse employees. 
D) Both A and B 
E) All of the above

Question 12

Business Intelligence (BI)systems support operational activities.

Accepted Answer

A) True 
 B)False

Question 13

To arrange the PivotTable columns and rows in Excel 2013,we use the:

Accepted Answer

A) PivotTable Control. 
B) PivotTable dialog box. 
C) PivotTable Field List. 
D) PivotTable Wizard. 
E) PivotTable command tab. 
A) PivotTable Control. 
B) PivotTable dialog box. 
C) PivotTable Field List. 
D) PivotTable Wizard. 
E) PivotTable command tab.

Question 14

Report delivery is more difficult for data mining than it is for reporting systems.

Accepted Answer

A) True 
 B)False

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

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 17

What is a star schema?

Accepted Answer

The star schema describes the arrangemen

Question 18

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.

Question 19

Non-relational DBMSs associated with the NoSQL movement include:

Accepted Answer

A) Key-Value. 
B) Document. 
C) Column Family. 
D) Graph. 
E) All of the above 
A) Key-Value. 
B) Document. 
C) Column Family. 
D) Graph. 
E) All of the above

A data warehouse is a database system that has data and programs for,as well as personnel specialized in,BI processing.

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

What are objects,and how are they related to the object-oriented DBMS (OODBMS)?

Column family databases are indistinguishable from relational database tables.

Operational databases contain a fact table.

Hadoop is a(n):

Operational databases store historical data.

Dimensional databases use the star schema.

Business Intelligence (BI)systems fall into which of the following categories?

A data mart is a collection of data that addresses a particular component or functional area of a business.

A data mart differs from a data warehouse in that:

Business Intelligence (BI)systems support operational activities.

To arrange the PivotTable columns and rows in Excel 2013,we use the:

Report delivery is more difficult for data mining than it is for reporting systems.

A data warehouse database differs from an operational database because:

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

What is a star schema?

OLAP stands for:

Non-relational DBMSs associated with the NoSQL movement include:

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

A data warehouse is a database system that has data and programs for,as well as personnel specialized in,BI processing.

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

What are objects,and how are they related to the object-oriented DBMS (OODBMS)?

Column family databases are indistinguishable from relational database tables.

Operational databases contain a fact table.

Hadoop is a(n):

Operational databases store historical data.

Dimensional databases use the star schema.

Business Intelligence (BI)systems fall into which of the following categories?

A data mart is a collection of data that addresses a particular component or functional area of a business.

A data mart differs from a data warehouse in that:

Business Intelligence (BI)systems support operational activities.

To arrange the PivotTable columns and rows in Excel 2013,we use the:

Report delivery is more difficult for data mining than it is for reporting systems.

A data warehouse database differs from an operational database because:

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

What is a star schema?

OLAP stands for:

Non-relational DBMSs associated with the NoSQL movement include:

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