Here are MCQs focused on Concepts of Data Warehousing:
1. What is the main goal of a data warehouse?
A. To optimize data entry processes
B. To store operational data
C. To support decision-making and business intelligence
D. To manage unstructured data
Answer: C
2. Which of the following is NOT a characteristic of a data warehouse?
A. Time-variant
B. Subject-oriented
C. Integrated
D. Frequent updates
Answer: D
3. In the context of data warehousing, “time-variant” means:
A. Data is updated in real-time
B. Data is linked to a specific time period
C. Data is refreshed periodically
D. Data is normalized over time
Answer: B
4. What does “subject-oriented” mean in a data warehouse?
A. Data is organized around specific business subjects like sales or finance
B. Data is stored based on object-relational models
C. Data is focused on a single transaction
D. Data is automatically classified based on content
Answer: A
5. Which layer in a data warehouse architecture is responsible for extracting, transforming, and loading data?
A. Data source layer
B. Data staging layer
C. Data presentation layer
D. Data analysis layer
Answer: B
6. Which of the following statements about a data warehouse is TRUE?
A. It supports real-time transactional data
B. It is designed to optimize storage space
C. It integrates data from multiple sources
D. It is primarily used for data input
Answer: C
7. What is a fact table in a data warehouse?
A. A table that contains dimensions of the data
B. A table that stores quantitative metrics and measures
C. A table used for ETL processing
D. A table with unstructured data
Answer: B
8. The process of identifying and fixing errors in source data during ETL is called:
A. Data aggregation
B. Data normalization
C. Data cleansing
D. Data mapping
Answer: C
9. Which of the following is a common design approach for data warehouses?
A. Object-oriented model
B. Relational model
C. Dimensional model
D. Network model
Answer: C
10. What is metadata in the context of a data warehouse?
A. Data used to track the origin of data sources
B. Data describing the structure, content, and usage of a data warehouse
C. A subset of data used for analytical purposes
D. Raw data ingested into the data warehouse
Answer: B