Question 1

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 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

________ 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 schemas 
A)  Dimensional modeling 
B)  Column databases 
C)  Fact tables 
D)  Snowflake schemas

Question 5

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. 
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.

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Discuss the four key terms related to data warehousing.

Accepted Answer

A data warehouse is subject-oriented,mea

Question 8

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. 
A)  ROLAP tools. 
B)  MOLAP tools. 
C)  slice and dice. 
D)  none of the above.

Question 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

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. 
A)  subject-oriented. 
B)  integrated. 
C)  time-variant. 
D)  nonvolatile.

Question 12

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 above 
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 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

A fact table holds descriptive data about the business.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

Metadata describe other data.There are t

Question 16

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 17

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

Accepted Answer

1.Extraction - data are extracted from i

Question 18

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 19

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 management 
A)  Multiple, nonsynchronized systems 
B)  Focus on customer relationship management 
C)  Downsizing 
D)  Focus on supplier relationship management

Question 20

Why are data mining applications growing rapidly?

Accepted Answer

Data mining applications are g

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

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

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

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

A logical data mart is a(n):

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

Discuss the four key terms related to data warehousing.

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

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.

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

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

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

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

A fact table holds descriptive data about the business.

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

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.

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

A dependent data mart:

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

Why are data mining applications growing rapidly?

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

Exam 9: Data Warehousing

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

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

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

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

A logical data mart is a(n):

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

Discuss the four key terms related to data warehousing.

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

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.

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

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

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

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

A fact table holds descriptive data about the business.

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

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.

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

A dependent data mart:

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

Why are data mining applications growing rapidly?

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters