Data Warehousing Test(1st)

The extract process is which of the following?

1 Mark(s)

Capturing all of the data contained in various operational systems
Capturing a subset of the data contained in various decision support systems
Capturing all of the data contained in various decision support systems
Capturing a subset of the data contained in various operational systems

A multifield transformation does which of the following?

1 Mark(s)

All of the above
Converts data from multiple fields into one field
Converts data from multiple fields into multiple fields
Converts data from one field into multiple fields

The generic two-level data warehouse architecture includes which of the following?

1 Mark(s)

Near real-time updates
At least one data mart
Data that can extracted from numerous internal and external sources
All of the above

Data in operational systems are typically fragmented and inconsistent.

1 Mark(s)

False
True

Transient data is which of the following?

1 Mark(s)

Data in which changes to existing records cause the previous version of the records to be eliminated
Data that are never deleted once they have been added
Data that are never altered or deleted once they have been added
Data in which changes to existing records do not cause the previous version of the records to be eliminated

Independent data marts are often created because an organization focuses on a series of short-term business objectives.

1 Mark(s)

False
True

The @active data warehouse architecture includes which of the following?

1 Mark(s)

Near real-time updates
At least one data mart
All of the above
Data that can extracted from numerous internal and external sources

Data in the data warehouse are loaded and refreshed from operational systems.

1 Mark(s)

True
False

The load and index is which of the following?

1 Mark(s)

A process to upgrade the quality of data before it is moved into a data warehouse
A process to load the data in the data warehouse and to create the necessary indexes
A process to reject data from the data warehouse and to create the necessary indexes
A process to upgrade the quality of data after it is moved into a data warehouse

Reconciled data is which of the following?

1 Mark(s)

Data stored in the various operational systems throughout the organization.
Data stored in one operational system in the organization.
Current data intended to be the single source for all decision support systems.
Data that has been selected and formatted for end-user support applications.

A goal of data mining includes which of the following?

1 Mark(s)

To analyze data for expected relationships
To confirm that data exists
To explain some observed event or condition
To create a new data warehouse

A star schema has what type of relationship between a dimension and fact table?

1 Mark(s)

All of the above
One-to-one
Many-to-many
One-to-many

A snowflake schema is which of the following types of tables?

1 Mark(s)

All of the above
Fact
Dimension
Helper

Both status data and event data can be stored in a database.

1 Mark(s)

True
False

Fact tables are which of the following?

1 Mark(s)

Completely denoralized
Completely normalized
Partially denoralized
Partially normalized

Periodic data are data that are physically altered once added to the store.

1 Mark(s)

False
True

An operational system is which of the following?

1 Mark(s)

A system that is used to support decision making and is based on current data.
A system that is used to run the business in real time and is based on historical data.
A system that is used to run the business in real time and is based on current data.
A system that is used to support decision making and is based on historical data.

Every key used to join the fact table with a dimensional table should be a surrogate key.

1 Mark(s)

True
False

Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.

1 Mark(s)

False
True

The role of the ETL process is to identify erroneous data and to fix them.

1 Mark(s)

True
False

Data scrubbing is which of the following?

1 Mark(s)

A process to reject data from the data warehouse and to create the necessary indexes
A process to upgrade the quality of data before it is moved into a data warehouse
A process to load the data in the data warehouse and to create the necessary indexes
A process to upgrade the quality of data after it is moved into a data warehouse

Joining is the process of partitioning data according to predefined criteria.

1 Mark(s)

True
False

Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.

1 Mark(s)

False
True

Data transformation includes which of the following?

1 Mark(s)

A process to change data from a detailed level to a summary level
Joining data from one source into various sources of data
A process to change data from a summary level to a detailed level
Separating data from one source into various sources of data

Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.

1 Mark(s)

True
False

Most operational systems are based on the use of transient data.

1 Mark(s)

True
False

Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.

1 Mark(s)

True
False

A data warehouse is which of the following?

1 Mark(s)

Can be updated by end users.
Contains numerous naming conventions and formats.
Organized around important subject areas.
Contains only current data.

Static extract is used for ongoing warehouse maintenance.

1 Mark(s)

True
False

A data mart is designed to optimize the performance for well-defined and predicable uses.

1 Mark(s)

True
False

Data Warehousing Test(1st) : Question 1 of 30