Discussion
Home ‣ Database ‣ Data Warehousing Comments
- Question
A data warehouse is which of the following?
Options- A. Can be updated by end users.
- B. Contains numerous naming conventions and formats.
- C. Organized around important subject areas.
- D. Contains only current data.
- Correct Answer
- Organized around important subject areas.
- 1. The extract process is which of the following?
Options- A. Capturing all of the data contained in various operational systems
- B. Capturing a subset of the data contained in various operational systems
- C. Capturing all of the data contained in various decision support systems
- D. Capturing a subset of the data contained in various decision support systems Discuss
- 2. A goal of data mining includes which of the following?
Options- A. To explain some observed event or condition
- B. To confirm that data exists
- C. To analyze data for expected relationships
- D. To create a new data warehouse Discuss
- 3. The @active data warehouse architecture includes which of the following?
Options- A. At least one data mart
- B. Data that can extracted from numerous internal and external sources
- C. Near real-time updates
- D. All of the above. Discuss
- 4. An operational system is which of the following?
Options- A. A system that is used to run the business in real time and is based on historical data.
- B. A system that is used to run the business in real time and is based on current data.
- C. A system that is used to support decision making and is based on current data.
- D. A system that is used to support decision making and is based on historical data. Discuss
- 5. Fact tables are which of the following?
Options- A. Completely denoralized
- B. Partially denoralized
- C. Completely normalized
- D. Partially normalized Discuss
- 6. Data transformation includes which of the following?
Options- A. A process to change data from a detailed level to a summary level
- B. A process to change data from a summary level to a detailed level
- C. Joining data from one source into various sources of data
- D. Separating data from one source into various sources of data Discuss
- 7. The generic two-level data warehouse architecture includes which of the following?
Options- A. At least one data mart
- B. Data that can extracted from numerous internal and external sources
- C. Near real-time updates
- D. All of the above. Discuss
- 8. Data scrubbing is which of the following?
Options- A. A process to reject data from the data warehouse and to create the necessary indexes
- B. A process to load the data in the data warehouse and to create the necessary indexes
- C. A process to upgrade the quality of data after it is moved into a data warehouse
- D. A process to upgrade the quality of data before it is moved into a data warehouse Discuss
- 9. A star schema has what type of relationship between a dimension and fact table?
Options- A. Many-to-many
- B. One-to-one
- C. One-to-many
- D. All of the above. Discuss
- 10. Transient data is which of the following?
Options- A. Data in which changes to existing records cause the previous version of the records to be eliminated
- B. Data in which changes to existing records do not cause the previous version of the records to be eliminated
- C. Data that are never altered or deleted once they have been added
- D. Data that are never deleted once they have been added Discuss
Data Warehousing problems
Search Results
Correct Answer: Capturing a subset of the data contained in various operational systems
Correct Answer: To explain some observed event or condition
Correct Answer: All of the above.
Correct Answer: A system that is used to run the business in real time and is based on current data.
Correct Answer: Completely normalized
Correct Answer: A process to change data from a detailed level to a summary level
Correct Answer: Data that can extracted from numerous internal and external sources
Correct Answer: A process to upgrade the quality of data before it is moved into a data warehouse
Correct Answer: One-to-many
Correct Answer: Data in which changes to existing records cause the previous version of the records to be eliminated
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.