Database - Data Warehousing
Database - Data Warehousing
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
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.
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
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.
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.
6. A snowflake schema is which of the following types of tables?
- Fact
- Dimension
- Helper
- All of the above
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.
8. Fact tables are which of the following?
- Completely denoralized
- Partially denoralized
- Completely normalized
- Partially normalized
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
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.