Data Warehouse Quiz

What is the primary purpose of a Data Warehouse?

• To handle real-time transactions

• To store and analyze large volumes of historical data

• To replace the need for a DBMS

• To manage daily operational tasks

Which process ensures only relevant data is selected for analysis in a Data Warehouse?

• Data Cleaning

• Data Filtering

• Data Transformation

• Data Monitoring

Which system would you use for real-time transaction processing?

• OLAP

• DBMS

• ETL Tool

• Data Mining Tool

What is the advantage of incremental extraction in the ETL process?

• It extracts all data in one go.

• It only extracts data that has changed since the last extraction.

• It uses advanced analytics to transform data.

• It eliminates the need for data cleaning.

What is the role of the middle tier in the 3-tier architecture of a Data Warehouse?

• Stores raw data after the ETL process

• Processes data for analytical queries

• Provides tools for reporting and visualization

• Monitors data loading and indexing

Why is a Data Warehouse preferred over a transactional database for analyzing 5 years of sales data?

• It is optimized for real-time updates.

• It allows complex queries without affecting daily operations.

• It automatically generates reports.

• It requires less storage space.

What does the term "Batch Processing" refer to in the context of ETL?

• Processing real-time data updates

• Dividing large volumes of data into smaller, manageable parts

• Extracting all data in one go

• Filtering data for specific queries

Which layer in the 3-tier Data Warehouse architecture is responsible for data visualization?

• Bottom Tier

• Middle Tier

• Top Tier

• OLAP Server

Which tool is most suitable for generating dashboards in a Data Warehouse environment?

• ETL Tool

• BI Tool

• OLAP Server

• Data Mining Tool

What is the primary goal of the "Loading" phase in ETL?

• Extracting data from multiple sources

• Transforming data into a standardized format

• Storing transformed data into the target system

• Monitoring data quality