Question 1

DBMSs associated with the NoSQL movement are often known as ________.

Accepted Answer

A) RDBMSs 
B) OODBMSs 
C) SSDBMSs 
D) HADBMs 
E) structured storage 
A) RDBMSs 
B) OODBMSs 
C) SSDBMSs 
D) HADBMs 
E) structured storage E

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

What is a conformed dimension?

Accepted Answer

A conformed dimension is a dimension tab

Question 5

Data warehouse data are frequently denormalized.

Accepted Answer

A) True 
 B)False

Question 6

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

Question 7

In OLAP,the data item of interest is called a ________.

Accepted Answer

A) level 
B) dimension 
C) measure 
D) member 
E) slice 
A) level 
B) dimension 
C) measure 
D) member 
E) slice

Question 8

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

Accepted Answer

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

Question 9

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 
E) a "too much data" problem 
A) dirty data 
B) inconsistent data 
C) nonintegrated data 
D) a "wrong format" problem 
E) a "too much data" problem

Question 10

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 11

What is a star schema?

Accepted Answer

The star schema describes the arrangemen

Question 12

An OLAP cube is limited to three axes.

Accepted Answer

A) True 
 B)False

Question 13

What is a distributed database?

Accepted Answer

A distributed database is a database tha

Question 14

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) A and B 
E) A,B,and C 
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) A and B 
E) A,B,and C

Question 15

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) A and B 
E) A,B,and C 
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) A and B 
E) A,B,and C

Question 16

The movement that uses different database methods than the relational model and/or SQL is called the NoSQL movement.

Accepted Answer

A) True 
 B)False

Question 17

Dimensional databases use the star schema.

Accepted Answer

A) True 
 B)False

Question 18

When distributed databases create copies of the database 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 19

Data warehouses use a(n)________.

Accepted Answer

A) operational database 
B) dimensional database 
C) structured storage 
D) A or B 
E) All of the above 
A) operational database 
B) dimensional database 
C) structured storage 
D) A or B 
E) All of the above

Question 20

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

Exam 12: Big Data datawarehouse and Business Intelligence Systems

DBMSs associated with the NoSQL movement are often known as ________.

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

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

What is a conformed dimension?

Data warehouse data are frequently denormalized.

The term drill down means the user wants to ________.

In OLAP,the data item of interest is called a ________.

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

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

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

What is a star schema?

An OLAP cube is limited to three axes.

What is a distributed database?

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

A data mart differs from a data warehouse in that:

The movement that uses different database methods than the relational model and/or SQL is called the NoSQL movement.

Dimensional databases use the star schema.

When distributed databases create copies of the database on different servers,this is known as:

Data warehouses use a(n)________.

Snowflake schemas have normalized ________.

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