Question 1

Apache Cassandra is an example of a column family database.

Accepted Answer

A) True 
 B)False

Question 2

The term for the enormous datasets generated by Web 2.0 applications is ________.

Accepted Answer

The answer of The term for the enormous datasets generated...

Question 3

Business Intelligence (BI)systems are information systems that help users analyze and use data.

Accepted Answer

A) True 
 B)False

Question 4

To deal with historical data values,dimensional databases use a(n)________.

Accepted Answer

The answer of To deal with historical data values,dimensional databases...

Question 5

Problematic data are called ________.

Accepted Answer

The answer of Problematic data are called ________....

Question 6

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 7

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 8

Business Intelligence (BI)systems obtain data in ________ different ways.

Accepted Answer

The answer of Business Intelligence (BI)systems obtain data in ________...

Question 9

Snowflake schemas have normalized:

Accepted Answer

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

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

What is a star schema?

Accepted Answer

The star schema describes the arrangemen

Question 12

What is a conformed dimension?

Accepted Answer

A conformed dimension is a dimension tab

Question 13

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 14

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

Accepted Answer

A)  Dirty data 
B)  Missing values 
C)  Non-integrated data 
D)  Both A and B 
E)  All of the above 
A)  Dirty data 
B)  Missing values 
C)  Non-integrated data 
D)  Both A and B 
E)  All of the above

Question 15

Data warehouses are populated with data prepared by ________ programs.

Accepted Answer

Extract,Tr

Question 16

Column family databases are indistinguishable from relational database tables.

Accepted Answer

A) True 
 B)False

Question 17

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 18

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

Accepted Answer

A) True 
 B)False

Question 19

A dimensional database uses a(n)________.

Accepted Answer

The answer of A dimensional database uses a(n)________....

Question 20

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.

Apache Cassandra is an example of a column family database.

The term for the enormous datasets generated by Web 2.0 applications is ________.

Business Intelligence (BI)systems are information systems that help users analyze and use data.

To deal with historical data values,dimensional databases use a(n)________.

Problematic data are called ________.

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

A data mart differs from a data warehouse in that:

Business Intelligence (BI)systems obtain data in ________ different ways.

Snowflake schemas have normalized:

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

What is a star schema?

What is a conformed dimension?

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

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

Data warehouses are populated with data prepared by ________ programs.

Column family databases are indistinguishable from relational database tables.

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

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

A dimensional database uses a(n)________.

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

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

Apache Cassandra is an example of a column family database.

The term for the enormous datasets generated by Web 2.0 applications is ________.

Business Intelligence (BI)systems are information systems that help users analyze and use data.

To deal with historical data values,dimensional databases use a(n)________.

Problematic data are called ________.

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

A data mart differs from a data warehouse in that:

Business Intelligence (BI)systems obtain data in ________ different ways.

Snowflake schemas have normalized:

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

What is a star schema?

What is a conformed dimension?

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

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

Data warehouses are populated with data prepared by ________ programs.

Column family databases are indistinguishable from relational database tables.

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

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

A dimensional database uses a(n)________.

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

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