Question 1

Which of the following is NOT an objective of derived data?

Accepted Answer

A)  Ease of use for decision support systems 
B)  Faster response time for user queries 
C)  Support data mining applications 
D)  Eliminate the need for application software 
A)  Ease of use for decision support systems 
B)  Faster response time for user queries 
C)  Support data mining applications 
D)  Eliminate the need for application software

Question 2

All of the following are unique characteristics of a logical data mart EXCEPT:

Accepted Answer

A)  logical data marts are not physically separate databases, but rather a relational view of a data warehouse. 
B)  the data mart is always up-to-date since data in a view is created when the view is referenced. 
C)  the process of creating a logical data mart is lengthy. 
D)  data are moved into the data warehouse rather than a separate staging area. 
A)  logical data marts are not physically separate databases, but rather a relational view of a data warehouse. 
B)  the data mart is always up-to-date since data in a view is created when the view is referenced. 
C)  the process of creating a logical data mart is lengthy. 
D)  data are moved into the data warehouse rather than a separate staging area.

Question 3

A conformed dimension is one or more dimension tables associated with only one fact table.

Accepted Answer

A) True 
 B)False

Question 4

Conformed dimensions allow users to do the following:

Accepted Answer

A)  delete correlated data. 
B)  query across fact tables with consistency. 
C)  identify viruses in web sites. 
D)  fix viruses in html documents. 
A)  delete correlated data. 
B)  query across fact tables with consistency. 
C)  identify viruses in web sites. 
D)  fix viruses in html documents.

Question 5

An enterprise data warehouse that accepts near-real time feeds of transactional data and immediately transforms and loads the appropriate data is called a real-time data warehouse.

Accepted Answer

A) True 
 B)False

Question 6

Discuss the difference between transient data and periodic data.

Accepted Answer

Transient data are data in whi

Question 7

What is the surrogate key rule for the star schema, and what are the main reasons for this rule?

Accepted Answer

Each and every key used to join the fact

Question 8

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

Accepted Answer

1. Extraction-data are extracted from in

Question 9

A database action that results from a transaction is called a(n):

Accepted Answer

A)  transition. 
B)  event. 
C)  log entry. 
D)  journal happening. 
A)  transition. 
B)  event. 
C)  log entry. 
D)  journal happening.

Question 10

A dependent data mart is filled from the enterprise data warehouse and its reconciled data.

Accepted Answer

A) True 
 B)False

Question 11

________ 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 12

Explain the difference between operational and informational systems as well as the primary factors that contribute to the need for separation.

Accepted Answer

An operational system is built to run a

Question 13

Data that are never physically altered once they are added to the store are called ________ data.

Accepted Answer

A)  transient 
B)  override 
C)  periodic 
D)  complete 
A)  transient 
B)  override 
C)  periodic 
D)  complete

Question 14

An operational data store is typically a relational database and normalized, but it is tuned for decision-making applications.

Accepted Answer

A) True 
 B)False

Question 15

A star schema contains both fact and ________ tables.

Accepted Answer

A)  narrative 
B)  cross functional 
C)  dimension 
D)  starter 
A)  narrative 
B)  cross functional 
C)  dimension 
D)  starter

Question 16

An operational data store typically holds a history of snapshots of the state of an organization whereas an enterprise data warehouse does not typically contain history.

Accepted Answer

A) True 
 B)False

Question 17

Explain what the star schema is.

Accepted Answer

The star schema is a simple database des

Question 18

What is a logical data mart and what makes this architecture unique?

Accepted Answer

A logical data mart is created by a rela

Question 19

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 20

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

Which of the following is NOT an objective of derived data?

All of the following are unique characteristics of a logical data mart EXCEPT:

A conformed dimension is one or more dimension tables associated with only one fact table.

Conformed dimensions allow users to do the following:

An enterprise data warehouse that accepts near-real time feeds of transactional data and immediately transforms and loads the appropriate data is called a real-time data warehouse.

Discuss the difference between transient data and periodic data.

What is the surrogate key rule for the star schema, and what are the main reasons for this rule?

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

A database action that results from a transaction is called a(n):

A dependent data mart is filled from the enterprise data warehouse and its reconciled data.

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

Explain the difference between operational and informational systems as well as the primary factors that contribute to the need for separation.

Data that are never physically altered once they are added to the store are called ________ data.

An operational data store is typically a relational database and normalized, but it is tuned for decision-making applications.

A star schema contains both fact and ________ tables.

An operational data store typically holds a history of snapshots of the state of an organization whereas an enterprise data warehouse does not typically contain history.

Explain what the star schema is.

What is a logical data mart and what makes this architecture unique?

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

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

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 9: Data Warehousing

Which of the following is NOT an objective of derived data?

All of the following are unique characteristics of a logical data mart EXCEPT:

A conformed dimension is one or more dimension tables associated with only one fact table.

Conformed dimensions allow users to do the following:

An enterprise data warehouse that accepts near-real time feeds of transactional data and immediately transforms and loads the appropriate data is called a real-time data warehouse.

Discuss the difference between transient data and periodic data.

What is the surrogate key rule for the star schema, and what are the main reasons for this rule?

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

A database action that results from a transaction is called a(n):

A dependent data mart is filled from the enterprise data warehouse and its reconciled data.

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

Explain the difference between operational and informational systems as well as the primary factors that contribute to the need for separation.

Data that are never physically altered once they are added to the store are called ________ data.

An operational data store is typically a relational database and normalized, but it is tuned for decision-making applications.

A star schema contains both fact and ________ tables.

An operational data store typically holds a history of snapshots of the state of an organization whereas an enterprise data warehouse does not typically contain history.

Explain what the star schema is.

What is a logical data mart and what makes this architecture unique?

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

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

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters