NEW
Font size
WorksheetsDatawarehouse
Total questions: 13
Worksheet time: 10mins
What is the primary purpose of a data warehouse?
To process real-time transactions
To store unstructured data for archival purposes
To enable business intelligence and analytics
To act as a temporary storage for data before it is loaded into an operational database
Which of the following describes the 'Extract' stage in the ETL process?
Loading data into the target data warehouse
Cleaning and transforming data to fit the target schema
Copying data from source systems
Creating a star schema for the data model
What is a data mart?
A small, subject-oriented data warehouse
A system used for operational data entry
A large-scale, enterprise-wide data warehouse
A tool used for data visualization
Which of the following is a characteristic of a data warehouse?
Volatile
Subject-oriented
Real-time updates
Normalized schema
What is the primary difference between a data warehouse and an operational database (OLTP)?
Operational databases support historical analysis, while data warehouses support real-time transactions.
Data warehouses are designed for fast queries and analysis, while operational databases are designed for fast transaction processing.
Operational databases contain integrated data from multiple sources, while data warehouses do not.
Data warehouses are always smaller than operational databases.
What does OLAP stand for?
Online Latent Analytics Processing
Online Ledger and Accounting Platform
Online Link and Association Protocol
Online Analytical Processing
Which of the following describes the 'L' in the ETL process?
Logging errors during data transformation.
Loading the transformed data into the data warehouse.
Linking different dimension tables together.
Learning new insights from the data.
Which characteristic refers to a data warehouse's focus on a specific business topic, such as sales or customers, rather than on the day-to-day operations?
Integrated
Non-volatile
Subject-oriented
Time-variant
The ability of a data warehouse to store and provide historical data over a long period, allowing for trend analysis, is known as being:
Time-variant
Non-volatile
Integrated
Subject-oriented
Which characteristic ensures that data, once loaded, is never changed or deleted, only added to?
Time-variant
Integrated
Subject-oriented
Non-volatile
The fact that a data warehouse unifies data from multiple, disparate sources (e.g., sales, inventory, and customer systems) into a single, consistent format is an example of what characteristic?
Non-volatile
Subject-oriented
Integrated
Time-variant
When a company adds sales data for the current month to its data warehouse, without deleting the data from previous months, it is demonstrating which two key characteristics?
Subject-oriented and Non-volatile
Integrated and Time-variant
Time-variant and Non-volatile
Subject-oriented and Integrated
A data warehouse contains historical sales information from a company’s different product lines, with data from different stores and regions combined into a single view. This demonstrates which two characteristics?
Time-variant and Non-volatile
Subject-oriented and Integrated
Integrated and Time-variant
Non-volatile and Subject-oriented
