Question 1

To use an SQL Server 2014 database in an Microsoft Excel 2013 PivotTable,it is generally useful to ________.

Accepted Answer

A) create a view in SQL Server 2014 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 Visio diagram 
A) create a view in SQL Server 2014 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 Visio diagram

Question 2

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 are correct 
A) Filter data 
B) Group data 
C) Modify data 
D) Both A and B are correct

Question 3

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 denormalized 
D) Both B and C are correct 
A) data warehouse data are not stored in tables 
B) data warehouse databases do not have metadata 
C) data warehouse data are often denormalized 
D) Both B and C are correct

Question 4

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 
A) summarize data 
B) get older data 
C) sort data 
D) get more details

Question 5

Business Intelligence (BI)reporting systems summarize the current status of business activities and compare that status with past events,but not with predicted future activities.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is (are)true about data mining applications?

Accepted Answer

A) They use sophisticated mathematical techniques. 
B) They use sophisticated statistical techniques. 
C) Their report delivery is more important than report delivery for reporting systems. 
D) Both A and B are correct 
A) They use sophisticated mathematical techniques. 
B) They use sophisticated statistical techniques. 
C) Their report delivery is more important than report delivery for reporting systems. 
D) Both A and B are correct

Question 7

We have obtained access to the company's operational data.We have been asked to produce a report with an item by item analysis of sales,but the only sales figure available is the total sale value for each order.This is an example of ________.

Accepted Answer

A) dirty data 
B) inconsistent data 
C) nonintegrated data 
D) a "wrong format" problem 
A) dirty data 
B) inconsistent data 
C) nonintegrated data 
D) a "wrong format" problem

Question 8

Which of the following is not a component of a data warehouse?

Accepted Answer

A) Data extract,transform,and load (ETL)preparation programs 
B) Data warehouse data 
C) Operational database updates 
D) Data warehouse metadata 
A) Data extract,transform,and load (ETL)preparation programs 
B) Data warehouse data 
C) Operational database updates 
D) Data warehouse metadata

Question 9

To create an OLAP report for an SQL Server 2014 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 
A) Microsoft Access 2013 
B) Microsoft Word 2013 
C) Microsoft Visio 2013 
D) Microsoft Excel 2013

Question 10

An OLAP cube is limited to three axes.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

An OLAP cube is called that because some products show OLAP displays on ________ axes.

Accepted Answer

A) one 
B) two 
C) three 
D) four 
A) one 
B) two 
C) three 
D) four

Question 14

In RFM analysis,R stands for "how recently."

Accepted Answer

A) True 
 B)False

Question 15

The program that manages the various virtual machines (which can of course be running their own DBMS installation)running on a physical machine is called a ________.

Accepted Answer

A) supervisor 
B) hypervisor 
C) virtual operating system 
D) virtual DBMS 
A) supervisor 
B) hypervisor 
C) virtual operating system 
D) virtual DBMS

Question 16

We have obtained access to the company's operational data.We examine 50 records for customers with phone numbers that should use the current area code of 345.Of these 50 records,we find 10 that still use an older area code of 567.This is an example of ________.

Accepted Answer

A) dirty data 
B) inconsistent data 
C) nonintegrated data 
D) a "too much data" problem 
A) dirty data 
B) inconsistent data 
C) nonintegrated data 
D) a "too much data" problem

Question 17

The "M" in RFM analysis stands for ________.

Accepted Answer

A) money 
B) mostly 
C) modest 
D) modern 
A) money 
B) mostly 
C) modest 
D) modern

Question 18

Most data mining techniques are simple and easy to use.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

Virtualization is an attempt to do a better job of using which hardware resources in a computer?

Accepted Answer

A) Memory and monitors 
B) CPU and memory 
C) Operating system 
D) Database tables 
A) Memory and monitors 
B) CPU and memory 
C) Operating system 
D) Database tables

Exam 14: Big Data, Data-Warehouses, and Business Intelligence Systems

To use an SQL Server 2014 database in an Microsoft Excel 2013 PivotTable,it is generally useful to ________.

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

A data warehouse database differs from an operational database because ________.

The term drill down means the user wants to ________.

Business Intelligence (BI)reporting systems summarize the current status of business activities and compare that status with past events,but not with predicted future activities.

Which of the following is (are)true about data mining applications?

We have obtained access to the company's operational data.We have been asked to produce a report with an item by item analysis of sales,but the only sales figure available is the total sale value for each order.This is an example of ________.

Which of the following is not a component of a data warehouse?

To create an OLAP report for an SQL Server 2014 database,we can build a PivotTable in ________.

An OLAP cube is limited to three axes.

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

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

An OLAP cube is called that because some products show OLAP displays on ________ axes.

In RFM analysis,R stands for "how recently."

The program that manages the various virtual machines (which can of course be running their own DBMS installation)running on a physical machine is called a ________.

We have obtained access to the company's operational data.We examine 50 records for customers with phone numbers that should use the current area code of 345.Of these 50 records,we find 10 that still use an older area code of 567.This is an example of ________.

The "M" in RFM analysis stands for ________.

Most data mining techniques are simple and easy to use.

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

Virtualization is an attempt to do a better job of using which hardware resources in a computer?

Introduction

Introduction to Structured Query Language

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

Managing Databases With SQL Server 2014

Managing Databases With Oracle Database

Managing Databases With Mysql 5.6

The Web Server Environment

Getting Started With 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 Netbeans IDE

Business Intelligence Systems

Big Data

Filters