Deck 7: Data Warehousing Concepts

Question 1

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

Answer 1

False

Question 2

Implicit changes of data warehouse requirements are permitted during:

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

Answer 2

D

Question 3

Operational queries are typically issued:

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

Answer 3

A

Question 4

The purpose of the source system is:

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

Question 5

Operational queries typically process:

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

Question 6

Data time-horizon is:

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 7

Creating ETL infrastructure includes creating necessary procedures and code for:

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 8

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

Question 9

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

Question 10

The performance of operational day-to-day tasks involving data use can be severely diminished if such tasks have to compete for computing resources with analytical queries.

Question 11

Which of the following is NOT true:

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 12

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

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

Question 13

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

Question 14

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.

Question 15

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

Question 16

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

Question 17

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

Question 18

Operational data typically represents the current state of affairs in the real world,while analytical data can represent both the current situation and snapshots from the past.

Question 19

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

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

Question 20

Operational queries are typically issued:

A)By fewer users than analytical queries
B)By more users than analytical queries
C)By an equal number of users as analytical queries
D)By no users if the corporation has users issuing analytical queries

Question 21

Explain the term retrieval of analytical information 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.

Question 22

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

Question 23

Separate operational data sources cannot contain overlapping information.

Question 24

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.

Question 25

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.

Question 26

Data marts are always implemented as relational databases.

Question 27

Analytical databases are referred to as application-oriented.

Question 28

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.

Question 29

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

Question 30

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.

Question 31

A data mart is a data store based on the same principles as a data warehouse but with
a wider scope.

Question 32

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

Question 33

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

Question 34

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

Question 35

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.

Question 36

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

Question 37

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.

Question 38

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

Question 39

Operational databases are referred to as subject-oriented.

Question 40

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.

Question 41

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

Question 42

List the three major components of every data warehousing system.

Question 43

What is an independent data mart?

Question 44

What is a dependent data mart?

Question 45

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.

Question 46

Describe the data warehouse deployment step.

Question 47

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

Question 48

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