Concepts of data warehouse MCQs January 8, 2026November 19, 2024 by u930973931_answers 10 min Score: 0 Attempted: 0/10 Subscribe 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 2. Which of the following is NOT a characteristic of a data warehouse? (A) Time-variant (B) Subject-oriented (C) Integrated (D) Frequent updates 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 4. What does “subject-oriented” mean in a data warehouse? (A) Data is automatically classified based on content (B) Data is stored based on object-relational models (C) Data is focused on a single transaction (D) Data is organized around specific business subjects like sales or finance 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 6. Which of the following statements about a data warehouse is TRUE? (A) It integrates data from multiple sources (B) It is designed to optimize storage space (C) It supports real-time transactional data (D) It is primarily used for data input 7. What is a fact table in a data warehouse? (A) A table that stores quantitative metrics and measures (B) A table that contains dimensions of the data (C) A table used for ETL processing (D) A table with unstructured data 8. The process of identifying and fixing errors in source data during ETL is called: (A) Data aggregation (B) Data cleansing (C) Data normalization (D) Data mapping 9. Which of the following is a common design approach for data warehouses? (A) Object-oriented model (B) Relational model (C) Network model (D) Dimensional model 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