Question 1

In contrast to a narrow constituency of operational data,analytical data is used by a widespread set of users.

Accepted Answer

A) True 
 B)False

Question 2

A typical organization maintains and utilizes a number of operational data sources.

Accepted Answer

A) True 
 B)False

Question 3

A data warehouse is created within an organization as a separate data store whose primary purpose is data analysis.

Accepted Answer

A) True 
 B)False

Question 4

Data warehouse requirements can be refined and/or expanded following:

Accepted Answer

A) Data warehouse use 
B) Data warehouse deployment 
C) Creating ETL infrastructure 
D) All of the above 
A) Data warehouse use 
B) Data warehouse deployment 
C) Creating ETL infrastructure 
D) All of the above

Question 5

What is a dependent data mart?

Accepted Answer

A dependent data mart does not have its

Question 6

The operational data sources include the data warehouses and data marts.

Accepted Answer

A) True 
 B)False

Question 7

What is an independent data mart?

Accepted Answer

An independent data mart is a

Question 8

Which of the following is NOT true:

Accepted Answer

A) Data marts typically have fewer data sources than data warehouses 
B) Data marts typically have broader focus than data warehouses 
C) Data marts are typically not as big as data warehouses 
D) Data marts typically have shorter implementation time than data warehouses 
A) Data marts typically have fewer data sources than data warehouses 
B) Data marts typically have broader focus than data warehouses 
C) Data marts are typically not as big as data warehouses 
D) Data marts typically have shorter implementation time than data warehouses

Question 9

Creating ETL infrastructure includes creating necessary procedures and code for:

Accepted Answer

A) Designing and creating applications for indirect use by the end users 
B) The seamless load of the transformed data into the operational data bases 
C) Automatic extraction of relevant data from the data warehouses 
D) Transformation of the extracted data,so that its quality is assured and its structure conforms to the structure of the modeled and implemented data warehouse 
A) Designing and creating applications for indirect use by the end users 
B) The seamless load of the transformed data into the operational data bases 
C) Automatic extraction of relevant data from the data warehouses 
D) Transformation of the extracted data,so that its quality is assured and its structure conforms to the structure of the modeled and implemented data warehouse

Question 10

Explain the term structured repository 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 database contain

Question 11

It is usually possible to configure the system to optimally process frequent queries requiring smaller amounts of data and to optimally process less frequent queries requesting large amounts of data at the same time.

Accepted Answer

A) True 
 B)False

Question 12

ETL infrastructure has to account for and reconcile all of the differences in the metadata and the data between the operational sources and the target data warehouses.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

Data in operational systems is regularly

Question 14

Show an example data set organized in two different ways illustrating the difference between the application-oriented and subject-oriented organization of data.

Accepted Answer

Sure! Here's an example data set related

Question 15

Analytical databases are referred to as application-oriented.

Accepted Answer

A) True 
 B)False

Question 16

The design and creation of data warehouse front-end applications can take place in parallel with data warehouse creation.

Accepted Answer

A) True 
 B)False

Question 17

Analytical databases are created for the analysis of one or more specific business subject areas,such as sales,returns,cost,or profit.

Accepted Answer

A) True 
 B)False

Question 18

Increasing the speed of a single query is always a priority,even if it requires slowing down the majority of other queries.

Accepted Answer

A) True 
 B)False

Question 19

Keeping data in the operational system past its time horizon enables the operational queries to run faster.

Accepted Answer

A) True 
 B)False

Question 20

The purpose of the source system is:

Accepted Answer

A) Original operational purpose only 
B) As a source system for the data warehouse only 
C) Both the original operational purpose and as a source system for the data warehouse 
D) As a write-only source system 
A) Original operational purpose only 
B) As a source system for the data warehouse only 
C) Both the original operational purpose and as a source system for the data warehouse 
D) As a write-only source system

In contrast to a narrow constituency of operational data,analytical data is used by a widespread set of users.

A typical organization maintains and utilizes a number of operational data sources.

A data warehouse is created within an organization as a separate data store whose primary purpose is data analysis.

Data warehouse requirements can be refined and/or expanded following:

What is a dependent data mart?

The operational data sources include the data warehouses and data marts.

What is an independent data mart?

Which of the following is NOT true:

Creating ETL infrastructure includes creating necessary procedures and code for:

It is usually possible to configure the system to optimally process frequent queries requiring smaller amounts of data and to optimally process less frequent queries requesting large amounts of data at the same time.

ETL infrastructure has to account for and reconcile all of the differences in the metadata and the data between the operational sources and the target data warehouses.

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

Show an example data set organized in two different ways illustrating the difference between the application-oriented and subject-oriented organization of data.

Analytical databases are referred to as application-oriented.

The design and creation of data warehouse front-end applications can take place in parallel with data warehouse creation.

Analytical databases are created for the analysis of one or more specific business subject areas,such as sales,returns,cost,or profit.

Increasing the speed of a single query is always a priority,even if it requires slowing down the majority of other queries.

Keeping data in the operational system past its time horizon enables the operational queries to run faster.

The purpose of the source system is:

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

In contrast to a narrow constituency of operational data,analytical data is used by a widespread set of users.

A typical organization maintains and utilizes a number of operational data sources.

A data warehouse is created within an organization as a separate data store whose primary purpose is data analysis.

Data warehouse requirements can be refined and/or expanded following:

What is a dependent data mart?

The operational data sources include the data warehouses and data marts.

What is an independent data mart?

Which of the following is NOT true:

Creating ETL infrastructure includes creating necessary procedures and code for:

It is usually possible to configure the system to optimally process frequent queries requiring smaller amounts of data and to optimally process less frequent queries requesting large amounts of data at the same time.

ETL infrastructure has to account for and reconcile all of the differences in the metadata and the data between the operational sources and the target data warehouses.

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

Show an example data set organized in two different ways illustrating the difference between the application-oriented and subject-oriented organization of data.

Analytical databases are referred to as application-oriented.

The design and creation of data warehouse front-end applications can take place in parallel with data warehouse creation.

Analytical databases are created for the analysis of one or more specific business subject areas,such as sales,returns,cost,or profit.

Increasing the speed of a single query is always a priority,even if it requires slowing down the majority of other queries.

Keeping data in the operational system past its time horizon enables the operational queries to run faster.

The purpose of the source system is:

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