DATA MINING AND DATA WAEHOUSING POSSIBLE OBJECTIVE TYPE QUESTIONS & ANSWERS
1. Data scrubbing is the
A. process of rejecting the data in the data warehouse and to create the necessary indexes
B. process of accepting the data from the data warehouse and to create the necessary indexes
C. A process to upgrade the quality of data before it is moved into a data warehouse
D. A process of upgrading the quality of data after it is moved into a data warehouse

ANSWER : C

2. The architecture of Active data warehouse includes which of the following?
A. Closer to real-time updates
B. As a minimum of one data mart
C. Data that can extracted from numerous internal and external sources
D. All of the above.

ANSWER : D

3. An operational system which means …show more content…
A data warehouse
A. Systematized around important subject areas
B. Can be updated by end users
C. Comprises only current data
D. All of the above

ANSWER : A

6. A snowflake schema is a table of
A. Helper
B. Fact
C. Dimension
D. All of the above

ANSWER : D
7. Fact tables are
A. Fully denormoralized
B. Completely normalized
C. Partially demoralized
D. Partially normalized

ANSWER : B

8. The generic two-level data warehouse architecture includes which of the following?
A. Data that can extracted from several internal and external sources
B. Near real-time updates
C. At least one data mart
D. None of the above

ANSWER : A

9. Data transformation is the
A. Linking data from one source into many sources of data
B. Process of changing the data from a detailed level to a summary level
C. Separating data from one source into many sources of data
D. All of the above

ANSWER :B

10. Reconciled data means
A. Data stored in the several operational systems throughout the organization
B. Data stored in one operational system in the organization
C. Current data intended to be the single source for all decision support systems
D. Data that has been selected and formatted for end-user support applications

ANSWER :C

11. The load & index is