Database - Data Warehousing

Exercise : Data Warehousing - General Questions
1.
Data scrubbing is which of the following?
A process to reject data from the data warehouse and to create the necessary indexes
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
A process to upgrade the quality of data before it is moved into a data warehouse
Answer: Option
Explanation:
No answer description is available. Let's discuss.

2.
The @active data warehouse architecture includes which of the following?
At least one data mart
Data that can extracted from numerous internal and external sources
Near real-time updates
All of the above.
Answer: Option
Explanation:
No answer description is available. Let's discuss.

3.
A goal of data mining includes which of the following?
To explain some observed event or condition
To confirm that data exists
To analyze data for expected relationships
To create a new data warehouse
Answer: Option
Explanation:
No answer description is available. Let's discuss.

4.
An operational system is which of the following?
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 current data.
A system that is used to support decision making and is based on historical data.
Answer: Option
Explanation:
No answer description is available. Let's discuss.

5.
A data warehouse is which of the following?
Can be updated by end users.
Contains numerous naming conventions and formats.
Organized around important subject areas.
Contains only current data.
Answer: Option
Explanation:
No answer description is available. Let's discuss.