Question 1

A star schema resembles a star,with a dimension table at the center and fact tables radiating out from the center.

Accepted Answer

A) True 
 B)False  False

Question 2

What is a conformed dimension?

Accepted Answer

A conformed dimension is a dimension table in a data warehouse that is used in more than one star schema.Since the same table is reused,we can be sure that the data is consistent within each star schema.

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

Operational databases store historical data.

Accepted Answer

A) True 
 B)False

Question 5

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

Question 6

Dimensional databases are used to track historical data,and therefore must have a(n)________.

Accepted Answer

A) time dimension 
B) customer dimension 
C) sales dimension 
D) order dimension 
A) time dimension 
B) customer dimension 
C) sales dimension 
D) order dimension

Question 7

Data warehouses also store the data warehouse metadata.

Accepted Answer

A) True 
 B)False

Question 8

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 9

What are Business Intelligence (BI)systems?

Accepted Answer

Business Intelligence (BI)systems are in

Question 10

Business Intelligence (BI)systems support operational activities.

Accepted Answer

A) True 
 B)False

Question 11

One of the goals of an object-relational database is to allow ________ to persist in the database.

Accepted Answer

A) data structures 
B) objects 
C) methods 
D) Java variables 
A) data structures 
B) objects 
C) methods 
D) Java variables

Question 12

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

Accepted Answer

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

Question 13

Structured storage column families are indistinguishable from relational database tables.

Accepted Answer

A) True 
 B)False

Question 14

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

Question 15

Metadata about the data's source,format,assumptions,and constraints are kept in a data warehouse metadata database.

Accepted Answer

A) True 
 B)False

Question 16

What is a distributed database?

Accepted Answer

A distributed database is a database tha

Question 17

A Business Intelligence (BI)reporting system ________.

Accepted Answer

A) creates meaningful information from disparate data sources 
B) delivers information to users at the DBA's convenience 
C) uses statistical procedures to predict future events 
D) uses operational data 
A) creates meaningful information from disparate data sources 
B) delivers information to users at the DBA's convenience 
C) uses statistical procedures to predict future events 
D) uses operational data

Question 18

RFM analysis analyzes and ranks customers based on ________.

Accepted Answer

A) their purchasing patterns 
B) their income status 
C) their residential location 
D) Both A and B are correct 
A) their purchasing patterns 
B) their income status 
C) their residential location 
D) Both A and B are correct

Question 19

Google's Bigtable was an early example of structured storage.

Accepted Answer

A) True 
 B)False

Question 20

Data mining is the application of mathematical and statistical techniques to find patterns and relationships that can be used to classify and predict future outcomes.

Accepted Answer

A) True 
 B)False

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

A star schema resembles a star,with a dimension table at the center and fact tables radiating out from the center.

What is a conformed dimension?

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

Operational databases store historical data.

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

Dimensional databases are used to track historical data,and therefore must have a(n)________.

Data warehouses also store the data warehouse metadata.

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.

What are Business Intelligence (BI)systems?

Business Intelligence (BI)systems support operational activities.

One of the goals of an object-relational database is to allow ________ to persist in the database.

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

Structured storage column families are indistinguishable from relational database tables.

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

Metadata about the data's source,format,assumptions,and constraints are kept in a data warehouse metadata database.

What is a distributed database?

A Business Intelligence (BI)reporting system ________.

RFM analysis analyzes and ranks customers based on ________.

Google's Bigtable was an early example of structured storage.

Data mining is the application of mathematical and statistical techniques to find patterns and relationships that can be used to classify and predict future outcomes.

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