Question 1

Problematic data include so-called "dirty data."

Accepted Answer

A) True 
 B)False  True

Question 2

What is a data warehouse?

Accepted Answer

A data warehouse is a non-operational database intended for use by Business Intelligence applications.A data warehouse is a database system that has data,programs and personnel who specialize in the preparation of data for Business intelligence processing.Databases in data warehouses are frequently denormalized to speed up BI processes.The components of a data warehouse include programs for data extraction/cleaning/preparation,data warehouse DBMSs,data warehouse metadata and data warehouse data.The data warehouse metadata database records the date warehouse data's source,format assumptions,constraints and other relevant facts.

Question 3

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  True

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

dimensiona

Question 6

Data warehouses are populated with data prepared by ________ programs.

Accepted Answer

Extract,Tr

Question 7

Distributed databases can be distributed by partitioning and ________.

Accepted Answer

The answer of Distributed databases can be distributed by partitioning...

Question 8

A dimensional database uses a(n)________.

Accepted Answer

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

Question 9

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 10

Excel 2013 allows us to connect directly to an Access 2013 database when building a PivotTable.

Accepted Answer

A) True 
 B)False

Question 11

NoSQL really stands for "Not only SQL."

Accepted Answer

A) True 
 B)False

Question 12

What is a Microsoft Excel PivotTable?

Accepted Answer

A PivotTable is the reporting mechanism

Question 13

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

Accepted Answer

PivotTable

Question 14

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 15

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

Accepted Answer

A) Key-Value 
B) Document 
C) Column Family 
D) Graph 
E) Object-Oriented 
A) Key-Value 
B) Document 
C) Column Family 
D) Graph 
E) Object-Oriented

Question 16

Hadoop is a(n)________.

Accepted Answer

distribute

Question 17

We have obtained access to the company's operational data.In one record,we find that a customer's age has been recorded as "337." This is an example of:

Accepted Answer

A) dirty data. 
B) inconsistent data. 
C) non-integrated data. 
D) a "wrong format" problem. 
E) a "too much data" problem. 
A) dirty data. 
B) inconsistent data. 
C) non-integrated data. 
D) a "wrong format" problem. 
E) a "too much data" problem.

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

What is a conformed dimension?

Accepted Answer

A conformed dimension is a dimension tab

Question 20

To deal with data values that change over time,dimensional databases use a(n)________.

Accepted Answer

slowly cha

Problematic data include so-called "dirty data."

What is a data warehouse?

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

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

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

Data warehouses are populated with data prepared by ________ programs.

Distributed databases can be distributed by partitioning and ________.

A dimensional database uses a(n)________.

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

Excel 2013 allows us to connect directly to an Access 2013 database when building a PivotTable.

NoSQL really stands for "Not only SQL."

What is a Microsoft Excel PivotTable?

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

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

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

Hadoop is a(n)________.

We have obtained access to the company's operational data.In one record,we find that a customer's age has been recorded as "337." This is an example of:

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

What is a conformed dimension?

To deal with data values that change over time,dimensional databases use a(n)________.

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

Problematic data include so-called "dirty data."

What is a data warehouse?

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

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

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

Data warehouses are populated with data prepared by ________ programs.

Distributed databases can be distributed by partitioning and ________.

A dimensional database uses a(n)________.

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

Excel 2013 allows us to connect directly to an Access 2013 database when building a PivotTable.

NoSQL really stands for "Not only SQL."

What is a Microsoft Excel PivotTable?

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

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

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

Hadoop is a(n)________.

We have obtained access to the company's operational data.In one record,we find that a customer's age has been recorded as "337." This is an example of:

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

What is a conformed dimension?

To deal with data values that change over time,dimensional databases use a(n)________.

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