Data Warehouse Intro and Architecture

What is the primary purpose of a data warehouse?

• To store transactional data

• To analyze and report historical data

• To replace operational databases

• To store user credentials

Which characteristic is NOT a feature of a data warehouse?

• Integrated

• Subject-oriented

• Volatile

• Time-variant

In OLTP systems, the focus is primarily on:

• Data analysis

• Transaction processing

• Archiving data

• Generating random queries

Which system is optimized for fast query performance over large datasets?

• OLAP

• OLTP

• ERP

• CRM

What is a star schema?

• A database design for operational systems

• A schema with multiple fact tables

• A simple design with one fact table and multiple dimension tables

• A schema shaped like a galaxy

Which of the following is a key component of a data warehouse architecture?

• ETL process

• OLTP systems

• Web servers

• Machine learning models

True or False: Data in a data warehouse is updated frequently like in OLTP systems.

• TRUE

• FALSE

What is a dimension in the context of data warehousing?

• A table containing numeric data

• A table used for storing descriptive data

• A table storing historical logs

• A table that exists in another dimension

What is the role of ETL in data warehousing?

• Export, Transfer, Link

• Execute, Test, Log

• Eat, Train, Learn

• Extract, Transform, Load

True or False: OLAP tools are used for detailed transaction processing.

• TRUE

• FALSE