Question 1

The grain of a data warehouse indicates the size and depth of the records.

Accepted Answer

A) True 
 B)False

Question 2

Scalable technology is often critical to a data mart.

Accepted Answer

A) True 
 B)False

Question 3

A class of database technology used to store textual and other unstructured data is called:

Accepted Answer

A)  mySQL. 
B)  NoSQL. 
C)  KnowSQL. 
D)  PHP. 
A)  mySQL. 
B)  NoSQL. 
C)  KnowSQL. 
D)  PHP.

Question 4

What are the characteristics of data after ETL?

Accepted Answer

The goal of ETL is to provide a single,

Question 5

Which of the following data-mining applications identifies customers for promotional activity?

Accepted Answer

A)  Population profiling 
B)  Target marketing 
C)  Usage analysis 
D)  Product affinity 
A)  Population profiling 
B)  Target marketing 
C)  Usage analysis 
D)  Product affinity

Question 6

All of the following are tasks of data cleansing EXCEPT:

Accepted Answer

A)  decoding data to make them understandable for data warehousing applications. 
B)  adding time stamps to distinguish values for the same attribute over time. 
C)  generating primary keys for each row of a table. 
D)  creating foreign keys. 
A)  decoding data to make them understandable for data warehousing applications. 
B)  adding time stamps to distinguish values for the same attribute over time. 
C)  generating primary keys for each row of a table. 
D)  creating foreign keys.

Question 7

The need for data warehousing in an organization is driven by its need for an integrated view of high-quality data.

Accepted Answer

A) True 
 B)False

Question 8

NoSQL is a great technology for storing well-structured data.

Accepted Answer

A) True 
 B)False

Question 9

A separate data warehouse causes more contention for resources in an organization.

Accepted Answer

A) True 
 B)False

Question 10

Grain and duration have a direct impact on the size of ________ tables.

Accepted Answer

A)  selection 
B)  grain 
C)  fact 
D)  figure 
A)  selection 
B)  grain 
C)  fact 
D)  figure

Question 11

Discuss the three-layer data architecture.

Accepted Answer

The three-layer data architecture descri

Question 12

All of the following are ways to consolidate data EXCEPT:

Accepted Answer

A)  application integration. 
B)  data rollup and integration. 
C)  business process integration. 
D)  user interaction integration. 
A)  application integration. 
B)  data rollup and integration. 
C)  business process integration. 
D)  user interaction integration.

Question 13

The process of partitioning data according to predefined criteria is called aggregation.

Accepted Answer

A) True 
 B)False

Question 14

Informational systems are designed to support decision making based on historical point-in-time and prediction data.

Accepted Answer

A) True 
 B)False

Question 15

A characteristic of reconciled data that means the data reflect an enterprise-wide view is:

Accepted Answer

A)  detailed. 
B)  historical. 
C)  normalized. 
D)  comprehensive. 
A)  detailed. 
B)  historical. 
C)  normalized. 
D)  comprehensive.

Question 16

Data are moved to the staging area before extraction takes place.

Accepted Answer

A) True 
 B)False

Question 17

A method of capturing data in a snapshot at a point in time is called static extract.

Accepted Answer

A) True 
 B)False

Question 18

The process of combining data from various sources into a single table or view is called:

Accepted Answer

A)  extracting. 
B)  updating. 
C)  selecting. 
D)  joining. 
A)  extracting. 
B)  updating. 
C)  selecting. 
D)  joining.

Question 19

Which of the following is a basic method for single-field transformation?

Accepted Answer

A)  Table lookup 
B)  Cross-linking entities 
C)  Cross-linking attributes 
D)  Field-to-field communication 
A)  Table lookup 
B)  Cross-linking entities 
C)  Cross-linking attributes 
D)  Field-to-field communication

Question 20

The process of transforming data from a detailed to a summary level is called:

Accepted Answer

A)  extracting. 
B)  updating. 
C)  joining. 
D)  aggregating. 
A)  extracting. 
B)  updating. 
C)  joining. 
D)  aggregating.

The grain of a data warehouse indicates the size and depth of the records.

Scalable technology is often critical to a data mart.

A class of database technology used to store textual and other unstructured data is called:

What are the characteristics of data after ETL?

Which of the following data-mining applications identifies customers for promotional activity?

All of the following are tasks of data cleansing EXCEPT:

The need for data warehousing in an organization is driven by its need for an integrated view of high-quality data.

NoSQL is a great technology for storing well-structured data.

A separate data warehouse causes more contention for resources in an organization.

Grain and duration have a direct impact on the size of ________ tables.

Discuss the three-layer data architecture.

All of the following are ways to consolidate data EXCEPT:

The process of partitioning data according to predefined criteria is called aggregation.

Informational systems are designed to support decision making based on historical point-in-time and prediction data.

A characteristic of reconciled data that means the data reflect an enterprise-wide view is:

Data are moved to the staging area before extraction takes place.

A method of capturing data in a snapshot at a point in time is called static extract.

The process of combining data from various sources into a single table or view is called:

Which of the following is a basic method for single-field transformation?

The process of transforming data from a detailed to a summary level is called:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 9: Data Warehousing and Data Integration

The grain of a data warehouse indicates the size and depth of the records.

Scalable technology is often critical to a data mart.

A class of database technology used to store textual and other unstructured data is called:

What are the characteristics of data after ETL?

Which of the following data-mining applications identifies customers for promotional activity?

All of the following are tasks of data cleansing EXCEPT:

The need for data warehousing in an organization is driven by its need for an integrated view of high-quality data.

NoSQL is a great technology for storing well-structured data.

A separate data warehouse causes more contention for resources in an organization.

Grain and duration have a direct impact on the size of ________ tables.

Discuss the three-layer data architecture.

All of the following are ways to consolidate data EXCEPT:

The process of partitioning data according to predefined criteria is called aggregation.

Informational systems are designed to support decision making based on historical point-in-time and prediction data.

A characteristic of reconciled data that means the data reflect an enterprise-wide view is:

Data are moved to the staging area before extraction takes place.

A method of capturing data in a snapshot at a point in time is called static extract.

The process of combining data from various sources into a single table or view is called:

Which of the following is a basic method for single-field transformation?

The process of transforming data from a detailed to a summary level is called:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters