Data Warehousing Concepts Quiz

Which of the following best defines a Data Warehouse?

• A system used for transactional data processing

• A centralized repository for historical data analysis

• A replacement for operational database systems

• A storage system for unstructured video content

Which statement correctly describes the Delivery Process in Data Warehousing?

• Transfers processed data to source systems

• Delivers real-time alerts to users

• Moves transformed data into the warehouse

• Delivers mail notifications to customers

Which of the following is a key difference between a Database System and a Data Warehouse?

• Databases are used for static reporting only

• Warehouses store only raw, unprocessed data

• Warehouses support analytical processing tasks

• Databases have more historical storage than warehouses

What is the main feature of a Multi-Dimensional Data Model?

• Uses columns and rows for table access

• Organizes data into a flat file format

• Represents data in a star or snowflake form

• Contains only numeric and text values

Which component defines a Data Cube in a warehouse?

• A list of operations and algorithms

• A single table storing all raw data

• A multi-dimensional array of measures

• A document describing cube design

What best describes a Star Schema?

• Centralized fact table with denormalized dimensions

• All dimensions are normalized hierarchies

• Only one fact table linked to multiple cubes

• Set of independent fact and dimension tables

What is the main idea of a Snowflake Schema?

• Uses unstructured JSON data files

• Normalizes dimensions into multiple related tables

• Reduces the number of fact tables

• Uses a single flat file for reporting

What defines a Fact Constellation schema?

• One fact table connected to multiple reports

• A single hierarchy of dimension levels

• Multiple fact tables sharing dimension tables

• Only summarized facts are stored

What is a Concept Hierarchy in data warehousing?

• Flat structure for all attributes

• Ordered levels of data abstraction

• Predefined static metadata fields

• A method for row-level indexing

Which component belongs to the Process Architecture of a warehouse?

• Event triggers and locks

• Data integration and transformation flows

• Only database schema scripts

• Email alerts and message queues