Data Warehousing Quiz

What is a data warehouse?

• A place to store physical goods

• A subject-oriented, integrated, time-variant and non-volatile collection of data

• A type of relational database

• A cloud storage solution

Which type of database is typically used for data warehouses?

• OLTP (Online Transaction Processing)

• OLAP (Online Analytical Processing)

• NoSQL

• Graph database

What does ETL stand for in the context of data warehousing?

• Extract, Transfer, Load

• Evaluate, Test, Launch

• Extract, Transform, Load

• Enhance, Track, Leverage

Which of the following is NOT a characteristic of data in source systems?

• Read/write access

• Aligned by application

• Uniform data formats across different systems

• Limited data history

What is the primary purpose of a data warehouse?

• Transaction processing

• Data storage

• Analysis and decision support

• Real-time data updates

Which schema type has one fact table surrounded by multiple dimension tables?

• Snowflake Schema

• Star Schema

• Fact Constellation Schema

• Relational Schema

What is metadata in the context of a data warehouse?

• The main data stored in the warehouse

• Data about the data in the warehouse

• The source of the data

• The output of data analysis

What is a fact table in a data warehouse schema?

• A table containing descriptive attributes

• A table containing measurable information like amount or quantity

• A table describing the data sources

• A table containing metadata

What is a dimension table in a data warehouse schema?

• A table containing measurable information

• A table describing various aspects of the data

• A table containing only numerical data

• A table used for temporary data storage

What is a Snowflake Schema?

• A schema with multiple fact tables

• A schema where dimension tables are normalized

• A schema with only one dimension table

• A schema without any fact tables