Question 1

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 2

Facebook uses the Apache Software Foundation's Cassandra NoSQL database.

Accepted Answer

A) True 
 B)False

Question 3

In a snowflake table,each dimension table is normalized.

Accepted Answer

A) True 
 B)False

Question 4

Data warehouses often include data purchased from outside vendors.

Accepted Answer

A) True 
 B)False

Question 5

The "R" in RFM analysis stands for ________.

Accepted Answer

A) rank 
B) recent 
C) relationship 
D) readiness 
E) random 
A) rank 
B) recent 
C) relationship 
D) readiness 
E) random

Question 6

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

Accepted Answer

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

Question 7

Business Intelligence (BI)reporting systems are intended to create meaningful information from disparate data sources and to deliver that information to the proper users on a timely basis.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

Amazon.com's Dynamo was an early example of structured storage.

Accepted Answer

A) True 
 B)False

Question 10

To create an OLAP report for an SQL Server 2012 database,use the PivotTable tool in SQL Server 2012.

Accepted Answer

A) True 
 B)False

Question 11

In RFM analysis,M stands for "how much money."

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

NoSQL really stands of "Not only SQL."

Accepted Answer

A) True 
 B)False

Question 14

RFM analysis is a way of analyzing and ranking customers based on online survey data.

Accepted Answer

A) True 
 B)False

Question 15

When creating an OLAP report based on SQL Server 2012 data,it is often a good idea to create a view to organize the data needed for the OLAP report.

Accepted Answer

A) True 
 B)False

Question 16

Microsoft Excel 2013 allows us to connect directly to an SQL Server 2012 database when building a PivotTable.

Accepted Answer

A) True 
 B)False

Question 17

In the MapReduce process,the first step is the ________ step.

Accepted Answer

A) column 
B) super column 
C) column family 
D) map 
E) reduce 
A) column 
B) super column 
C) column family 
D) map 
E) reduce

Question 18

Why is operational data sometimes unusable for Business Intelligence (BI)use?

Accepted Answer

Data in operational databases can suffer

Question 19

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 20

One 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) A,B,and C 
A) cluster analysis. 
B) OLAP. 
C) regression analysis. 
D) RFM analysis. 
E) A,B,and C

Exam 12: Big Data datawarehouse and Business Intelligence Systems

Hadoop is a(n)________.

Facebook uses the Apache Software Foundation's Cassandra NoSQL database.

In a snowflake table,each dimension table is normalized.

Data warehouses often include data purchased from outside vendors.

The "R" in RFM analysis stands for ________.

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

Business Intelligence (BI)reporting systems are intended to create meaningful information from disparate data sources and to deliver that information to the proper users on a timely basis.

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

Amazon.com's Dynamo was an early example of structured storage.

To create an OLAP report for an SQL Server 2012 database,use the PivotTable tool in SQL Server 2012.

In RFM analysis,M stands for "how much money."

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

NoSQL really stands of "Not only SQL."

RFM analysis is a way of analyzing and ranking customers based on online survey data.

When creating an OLAP report based on SQL Server 2012 data,it is often a good idea to create a view to organize the data needed for the OLAP report.

Microsoft Excel 2013 allows us to connect directly to an SQL Server 2012 database when building a PivotTable.

In the MapReduce process,the first step is the ________ step.

Why is operational data sometimes unusable for Business Intelligence (BI)use?

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

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

Introduction

Introduction to Structured Query Language SQL

The Relational Model and Normalization

Database Design Using Normalization

Data Modeling With the Entity-Relationship Model

Transforming Data Models Into Database Designs

Sql for Database Construction and Application Processing

Database Redesign

Managing Multiuser Databases

A: Managing Databases With SQL Server 20012

B: Managing Databases With Oracle Database 11g Release 2

C: Managing Databases With MySQL

The Web Server Environment

Microsoft Access 2013

Getting Started With Systems Analysis and Design

E-R Diagrams and the Idef1x Standard

E-R Diagrams and the UML Standard

Getting Started With MySQL Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2013

Data Structures for Database Processing

the Semantic Object Model

Getting Started With Web Servers php and the Eclipse PDT

Business Intelligence Systems

Filters