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 : D 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 : D 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 : A 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 : B 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 : C Discuss
6) A snowflake schema is which of the following types of tables?
7) The generic two-level 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 : B Discuss
8) Fact tables are which of the following?
Completely denoralized![]()
Partially denoralized![]()
Completely normalized![]()
Partially normalized![]()
Answer : C Discuss
9) Data transformation includes which of the following?
A process to change data from a detailed level to a summary level![]()
A process to change data from a summary level to a detailed level![]()
Joining data from one source into various sources of data![]()
Separating data from one source into various sources of data![]()
Answer : A Discuss
10) Reconciled data is which of the following?
Data stored in the various operational systems throughout the organization.![]()
Current data intended to be the single source for all decision support systems.![]()
Data stored in one operational system in the organization.![]()
Data that has been selected and formatted for end-user support applications.![]()
Answer : B Discuss