Question 1

Operational queries typically process:

Accepted Answer

A) Larger amounts of data than analytical queries 
B) Smaller amounts of data than analytical queries 
C) Equal amounts of data as analytical queries 
D) Infinite amounts of data,incomparable to analytical queries 
A) Larger amounts of data than analytical queries 
B) Smaller amounts of data than analytical queries 
C) Equal amounts of data as analytical queries 
D) Infinite amounts of data,incomparable to analytical queries B

Question 2

List the three major components of every data warehousing system.

Accepted Answer

Source systems,extraction-transformation-load (ETL)infrastructure,and the data warehouse.

Question 3

It is always possible to structure a database that can be used in a straightforward manner for both operational and analytical purposes.

Accepted Answer

A) True 
 B)False  False

Question 4

Show a diagram that illustrates the principal activities in the process of the development of the data warehouse.

Accepted Answer

The development of a data warehouse invo

Question 5

Which of the following is NOT a part of the data warehouse requirements step?

Accepted Answer

A) Requirements collection 
B) Requirements definition 
C) Conceptual modeling 
D) Logical modeling 
A) Requirements collection 
B) Requirements definition 
C) Conceptual modeling 
D) Logical modeling

Question 6

Explain the term historical in the following data warehouse definition:
The data warehouse is a structured repository of integrated,subject-oriented,enterprise-wide,historical,and time-variant data.The purpose of the data warehouse is the retrieval of analytical information.A data warehouse can store detailed and/or summarized data.

Accepted Answer

When compared to operational information

Question 7

Explain the term time-variant in the following data warehouse definition:
The data warehouse is a structured repository of integrated,subject-oriented,enterprise-wide,historical,and time-variant data.The purpose of the data warehouse is the retrieval of analytical information.A data warehouse can store detailed and/or summarized data.

Accepted Answer

The term time-variant refers to the fact

Question 8

Data time-horizon is:

Accepted Answer

A) Typically longer in operational systems than in analytical systems 
B) Typically equal in operational systems and in analytical systems 
C) Typically shorter in operational systems than in analytical systems 
D) Typically nonexistent in operational systems and in analytical systems 
A) Typically longer in operational systems than in analytical systems 
B) Typically equal in operational systems and in analytical systems 
C) Typically shorter in operational systems than in analytical systems 
D) Typically nonexistent in operational systems and in analytical systems

Question 9

Operational queries are typically issued:

Accepted Answer

A) More often than analytical queries 
B) Less often than analytical queries 
C) Equally as often as analytical queries 
D) Never in a corporation that has users issuing analytical queries 
A) More often than analytical queries 
B) Less often than analytical queries 
C) Equally as often as analytical queries 
D) Never in a corporation that has users issuing analytical queries

Question 10

Explain the term enterprise-wide in the following data warehouse definition:
The data warehouse is a structured repository of integrated,subject-oriented,enterprise-wide,historical,and time-variant data.The purpose of the data warehouse is the retrieval of analytical information.A data warehouse can store detailed and/or summarized data.

Accepted Answer

The data warehouse is a repository of an

Question 11

What is the difference between developing the initial and subsequent versions of the data warehouse?

Accepted Answer

Unlike the initial version,in subsequent

Question 12

Explain the term subject-oriented in the following data warehouse definition:
The data warehouse is a structured repository of integrated,subject-oriented,enterprise-wide,historical,and time-variant data.The purpose of the data warehouse is the retrieval of analytical information.A data warehouse can store detailed and/or summarized data.

Accepted Answer

The term subject-oriented refers to the

Question 13

Describe the data redundancy difference between operational and analytical database systems.

Accepted Answer

Reducing the redundancy of information i

Question 14

Explain the term detailed and/or summarized data in the following data warehouse definition,and elaborate on the reasons for storing detailed and aggregated data in the data warehouse:
The data warehouse is a structured repository of integrated,subject-oriented,enterprise-wide,historical,and time-variant data.The purpose of the data warehouse is the retrieval of analytical information.A data warehouse can store detailed and/or summarized data.

Accepted Answer

A data warehouse,depending on its purpos

Question 15

Implicit changes of data warehouse requirements are permitted during:

Accepted Answer

A) Data warehouse use 
B) Data warehouse deployment 
C) Creating ETL infrastructure 
D) Implicit changes of requirements are not permitted 
A) Data warehouse use 
B) Data warehouse deployment 
C) Creating ETL infrastructure 
D) Implicit changes of requirements are not permitted

Question 16

What is the difference between a typical (regular)data warehouse and an active data warehouse?

Accepted Answer

A typical data warehouse periodically re

Question 17

Data warehouse front-end applications are often referred to as business intelligence (BI)applications.

Accepted Answer

A) True 
 B)False

Question 18

Summarized operational data is typically physically stored,while summarized analytical data is typically derived (calculated)rather than physically stored.

Accepted Answer

A) True 
 B)False

Question 19

Separate operational data sources cannot contain overlapping information.

Accepted Answer

A) True 
 B)False

Question 20

Explain the term integrated in the following data warehouse definition:
The data warehouse is a structured repository of integrated,subject-oriented,enterprise-wide,historical,and time-variant data.The purpose of the data warehouse is the retrieval of analytical information.A data warehouse can store detailed and/or summarized data.

Accepted Answer

The idea behind a data warehouse is to c

Operational queries typically process:

List the three major components of every data warehousing system.

It is always possible to structure a database that can be used in a straightforward manner for both operational and analytical purposes.

Show a diagram that illustrates the principal activities in the process of the development of the data warehouse.

Which of the following is NOT a part of the data warehouse requirements step?

Data time-horizon is:

Operational queries are typically issued:

What is the difference between developing the initial and subsequent versions of the data warehouse?

Describe the data redundancy difference between operational and analytical database systems.

Implicit changes of data warehouse requirements are permitted during:

What is the difference between a typical (regular)data warehouse and an active data warehouse?

Data warehouse front-end applications are often referred to as business intelligence (BI)applications.

Summarized operational data is typically physically stored,while summarized analytical data is typically derived (calculated)rather than physically stored.

Separate operational data sources cannot contain overlapping information.

Introduction

Database Requirements and ER Modeling

Relational Database Modeling

Update Operations, update Anomalies, and Normalization

SQL

Database Implementation and Use

Data Warehouse and Data Mart Modeling

Data Warehouse Implementation and Use

Overview of Dbms Functionalities and Database Administration

Filters

Exam 7: Data Warehousing Concepts

Operational queries typically process:

List the three major components of every data warehousing system.

It is always possible to structure a database that can be used in a straightforward manner for both operational and analytical purposes.

Show a diagram that illustrates the principal activities in the process of the development of the data warehouse.

Which of the following is NOT a part of the data warehouse requirements step?

Data time-horizon is:

Operational queries are typically issued:

What is the difference between developing the initial and subsequent versions of the data warehouse?

Describe the data redundancy difference between operational and analytical database systems.

Implicit changes of data warehouse requirements are permitted during:

What is the difference between a typical (regular)data warehouse and an active data warehouse?

Data warehouse front-end applications are often referred to as business intelligence (BI)applications.

Summarized operational data is typically physically stored,while summarized analytical data is typically derived (calculated)rather than physically stored.

Separate operational data sources cannot contain overlapping information.

Introduction

Database Requirements and ER Modeling

Relational Database Modeling

Update Operations, update Anomalies, and Normalization

SQL

Database Implementation and Use

Data Warehouse and Data Mart Modeling

Data Warehouse Implementation and Use

Overview of Dbms Functionalities and Database Administration

Filters