Data Warehouse Quiz

What is the primary purpose of a data warehouse?

• To manage transactions

• To support decision-making

• To store passwords

• To host websites

Which component transforms raw data before entering the warehouse?

• Data Mart

• OLTP

• ETL (Extract, Transform, Load)

• OLAP

What is "metadata" in a data warehouse context?

• User data

• Data about data

• Encrypted files

• Duplicate records

Which of the following best represents a subject-oriented concept in DW?

• Payment history

• Stock control system

• Customer behavior

• Login sessions

Data in a warehouse is said to be "non-volatile" because:

• It changes frequently

• It is stored in RAM

• It does not get updated in real-time

• It gets auto-deleted

Which of these is NOT a key characteristic of a data warehouse?

• Integrated

• Time-variant

• Volatile

• Subject-oriented

Which of the following is time-variant data used for?

• Live transactions

• Reporting past trends

• Real-time updates

• Malware detection

Which is a benefit of implementing a data warehouse?

• Slower reports

• Higher system costs

• Competitive advantage

• Less productivity

What does a data mart represent?

• A marketplace for datasets

• A department-specific subset of data warehouse

• An outdated storage format

• A backup drive

How does data warehousing help in decision-making?

• By summarizing current and historical data

• By printing receipts

• By deleting duplicate files

• By storing user passwords