Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Joining is often complicated by problems such as errors in source data.

Accepted Answer

A) True 
 B)False

Question 3

Bitmapped indexing is often used in a data warehouse environment.

Accepted Answer

A) True 
 B)False

Question 4

An expanded version of a star schema in which all of the tables are fully normalized is called a(n):

Accepted Answer

A)  snowflake schema. 
B)  operational schema. 
C)  DSS schema. 
D)  complete schema. 
A)  snowflake schema. 
B)  operational schema. 
C)  DSS schema. 
D)  complete schema.

Question 5

A dependent data mart:

Accepted Answer

A)  is filled with data extracted directly from the operational system. 
B)  is filled exclusively from the enterprise data warehouse with reconciled data. 
C)  is dependent upon an operational system. 
D)  participates in a relationship with an entity. 
A)  is filled with data extracted directly from the operational system. 
B)  is filled exclusively from the enterprise data warehouse with reconciled data. 
C)  is dependent upon an operational system. 
D)  participates in a relationship with an entity.

Question 6

A technique using artificial intelligence to upgrade the quality of raw data is called:

Accepted Answer

A)  dumping. 
B)  data reconciliation. 
C)  completion backwards updates. 
D)  data scrubbing. 
A)  dumping. 
B)  data reconciliation. 
C)  completion backwards updates. 
D)  data scrubbing.

Question 7

Application integration is achieved by coordinating the flow of event information between business applications.

Accepted Answer

A) True 
 B)False

Question 8

When we consider data in the data warehouse to be time variant, we mean:

Accepted Answer

A)  that the time of storage varies. 
B)  data in the warehouse contain a time dimension so that they may be used to study trends and changes. 
C)  that there is a time delay between when data are posted and when we report on the data. 
D)  that time is relative. 
A)  that the time of storage varies. 
B)  data in the warehouse contain a time dimension so that they may be used to study trends and changes. 
C)  that there is a time delay between when data are posted and when we report on the data. 
D)  that time is relative.

Question 9

Data nationalization provides a virtual view of integrated data without actually bringing the data into one physical database.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following factors drive the need for data warehousing?

Accepted Answer

A)  Businesses need an integrated view of company information. 
B)  Informational data must be kept together with operational data. 
C)  Data warehouses generally have better security. 
D)  Reduce virus and Trojan horse threats. 
A)  Businesses need an integrated view of company information. 
B)  Informational data must be kept together with operational data. 
C)  Data warehouses generally have better security. 
D)  Reduce virus and Trojan horse threats.

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

Joining is often complicated by problems such as errors in source data.

Bitmapped indexing is often used in a data warehouse environment.

An expanded version of a star schema in which all of the tables are fully normalized is called a(n):

A dependent data mart:

A technique using artificial intelligence to upgrade the quality of raw data is called:

Application integration is achieved by coordinating the flow of event information between business applications.

When we consider data in the data warehouse to be time variant, we mean:

Data nationalization provides a virtual view of integrated data without actually bringing the data into one physical database.

Which of the following factors drive the need for data warehousing?

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

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

Joining is often complicated by problems such as errors in source data.

Bitmapped indexing is often used in a data warehouse environment.

An expanded version of a star schema in which all of the tables are fully normalized is called a(n):

A dependent data mart:

A technique using artificial intelligence to upgrade the quality of raw data is called:

Application integration is achieved by coordinating the flow of event information between business applications.

When we consider data in the data warehouse to be time variant, we mean:

Data nationalization provides a virtual view of integrated data without actually bringing the data into one physical database.

Which of the following factors drive the need for data warehousing?

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