Question 1

A fact table holds descriptive data about the business.

Accepted Answer

A) True 
 B)False

Question 2

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.E) C) and D)
F) A) and D)

Question 3

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.E) A) and C)
F) B) and D)

Question 4

Explain the four basic steps to build an independent data mart.

Accepted Answer

1.Extraction - data are extracted from i...

Question 5

When multiple systems in an organization are synchronized,the need for data warehousing increases.

Accepted Answer

A) True 
 B)False

Question 6

Discuss the four key terms related to data warehousing.

Accepted Answer

A data warehouse is subject-oriented,mea...

Question 7

The development of the relational data model did not contribute to the emergence of data warehousing.

Accepted Answer

A) True 
 B)False

Question 8

________ is/are a new technology which trade(s) off storage space savings for computing time.

Accepted Answer

A)   Dimensional modeling
B)   Column databases
C)   Fact tables
D)   Snowflake schemasE) B) and C)
F) A) and B)

Question 9

Why are data mining applications growing rapidly?

Accepted Answer

Data mining applications are g...

Question 10

Multidimensional OLAP (MOLAP)tools use variations of SQL and view the database as a relational database,in either a star schema or other normalized or denormalized set of tables.

Accepted Answer

A) True 
 B)False

Question 11

Operational and informational systems are generally separated because of which of the following factors?

Accepted Answer

A)   A data warehouse centralizes data that are scattered throughout disparate operational systems and makes them readily available for decision support applications.
B)   A properly designed data warehouse adds value to data by improving their quality and consistency.
C)   A separate data warehouse eliminates contention for resources that results when informational applications are confounded with operational processing.
D)   All of the aboveE) C) and D)
F) A) and D)

Question 12

Which of the following organizational trends does not encourage the need for data warehousing?

Accepted Answer

A)   Multiple, nonsynchronized systems
B)   Focus on customer relationship management
C)   Downsizing
D)   Focus on supplier relationship managementE) B) and C)
F) All of the above

Question 13

The real-time data warehouse accepts ________ feeds of transactional data and immediately transforms and loads the data into the data warehouse.

Accepted Answer

The answer of The real-time data warehouse accepts ________ feeds...

Question 14

The characteristic that indicates that a data warehouse is organized around key high-level entities of the enterprise is:

Accepted Answer

A)   subject-oriented.
B)   integrated.
C)   time-variant.
D)   nonvolatile.E) B) and D)
F) A) and B)

Question 15

An event is a database action that results from a transaction.

Accepted Answer

A) True 
 B)False

Question 16

What is the role of metadata in the three-layer data architecture?

Accepted Answer

Metadata describe other data.There are t...

Question 17

Independent data marts do not generally lead to redundant data and efforts.

Accepted Answer

A) True 
 B)False

Question 18

Organizations adopt data mart architectures because it is easier to have separate,small data warehouses than to get all organizational parties to agree to one view of the organization in a central data warehouse.

Accepted Answer

A) True 
 B)False

Question 19

OLAP tools that use the database as a traditional relational database are called:

Accepted Answer

A)   ROLAP tools.
B)   MOLAP tools.
C)   slice and dice.
D)   none of the above.E) A) and D)
F) None of the above

Question 20

A logical data mart is a(n) :

Accepted Answer

A)   data mart consisting of only logical data.
B)   data mart created by a relational view of a slightly denormalized data warehouse.
C)   integrated, subject-oriented, detailed database designed to serve operational users.
D)   centralized, integrated data warehouse.E) B) and C)
F) B) and D)

Exam 9: Data Warehousing

An event is a database action that results from a transaction.

Correct AnswerverifiedShow Answer

A fact table holds descriptive data about the business.

Correct AnswerverifiedShow Answer

________ is/are a new technology which trade(s) off storage space savings for computing time.

Correct AnswerverifiedShow Answer

Independent data marts do not generally lead to redundant data and efforts.

Correct AnswerverifiedShow Answer

When multiple systems in an organization are synchronized,the need for data warehousing increases.

Correct AnswerverifiedShow Answer

Which of the following organizational trends does not encourage the need for data warehousing?

Correct AnswerverifiedShow Answer

Discuss the four key terms related to data warehousing.

Correct AnswerverifiedA data warehouse is subject-oriented,mea...View AnswerShow Answer

The development of the relational data model did not contribute to the emergence of data warehousing.

Correct AnswerverifiedShow Answer

What is the role of metadata in the three-layer data architecture?

Correct AnswerverifiedMetadata describe other data.There are t...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

The real-time data warehouse accepts ________ feeds of transactional data and immediately transforms and loads the data into the data warehouse.

Correct AnswerverifiedShow Answer

Operational and informational systems are generally separated because of which of the following factors?

Correct AnswerverifiedShow Answer

Organizations adopt data mart architectures because it is easier to have separate,small data warehouses than to get all organizational parties to agree to one view of the organization in a central data warehouse.

Correct AnswerverifiedShow Answer

Why are data mining applications growing rapidly?

Correct AnswerverifiedData mining applications are g...View AnswerShow Answer

A logical data mart is a(n) :

Correct AnswerverifiedShow Answer

A dependent data mart:

Correct AnswerverifiedShow Answer

OLAP tools that use the database as a traditional relational database are called:

Correct AnswerverifiedShow Answer

The characteristic that indicates that a data warehouse is organized around key high-level entities of the enterprise is:

Correct AnswerverifiedShow Answer

Multidimensional OLAP (MOLAP)tools use variations of SQL and view the database as a relational database,in either a star schema or other normalized or denormalized set of tables.

Correct AnswerverifiedShow Answer

Explain the four basic steps to build an independent data mart.

Correct Answerverified1.Extraction - data are extracted from i...View AnswerShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A data warehouse is subject-oriented,mea...
View Answer

Correct Answer
verified

Correct Answer
verified
Metadata describe other data.There are t...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Data mining applications are g...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
1.Extraction - data are extracted from i...
View Answer