UNIT-1 Data Warehousing and OLAP (A sec)

What is the key purpose of a data warehouse?

• Handle daily transactions

• Manage passwords

• Real-time processing

• Support decision-making

Who defined a data warehouse as “subject-oriented, integrated, time-variant, and nonvolatile”?

• Ralph Kimball

• Bill Gates

• Larry Ellison

• W.H. Inmon

Which of the following best describes the "subject-oriented" nature of data warehouses?

• Real-time updates

• Transaction-level focus

• Organized by file type

• Focused on major business subjects like sales and customers

Data warehouses integrate data from:

• Only XML files

• Only spreadsheets

• One homogeneous source

• Multiple heterogeneous sources

Which property of data warehouse indicates that it retains historical data?

• Subject-oriented

• Integrated

• Nonvolatile

• Time-variant

What does "nonvolatile" mean in the context of data warehouses?

• Data changes frequently

• Data is volatile

• Data is deleted periodically

• Data is not updated in real time

Which of the following is NOT an advantage of using a data warehouse?

• Improved query performance

• Separation from operational systems

• Real-time transactional updates

• Historical trend analysis

Operational databases are optimized for:

• Analytics

• Visualization

• Aggregation

• Transactions

A system designed to help executives analyze business performance is likely using:

• OLTP

• Email server

• ERP

• OLAP

Which of the following supports real-time transaction processing?

• OLAP

• Data marts

• Data cubes

• OLTP