Azure Data Warehouse Concepts Quiz

1. Which of the following is a characteristic of OLAP systems?

Optimized for transactional processing

Supports complex analytical queries and multidimensional analysis

Designed for daily operational updates

Prioritizes write performance over read performance

Submit

3. What is a conformed dimension?

A dimension shared across multiple fact tables with consistent keys

A dimension that has been validated for accuracy

A dimension stored in compressed format

A dimension used only in real-time systems

4. True or False: OLTP systems are designed for analytical reporting and complex queries.

True

False

5. What is the purpose of a data staging area in a warehouse?

To permanently store raw data

To temporarily hold and validate data before loading

To replace the data warehouse

To archive old data only

Submit

7. What does a surrogate key provide in dimensional modeling?

A unique, system-generated identifier independent of business data

A compressed version of the fact table

A foreign key to link multiple fact tables

A timestamp for tracking data changes

8. True or False: Columnar storage is less efficient than row storage for analytical queries.

True

False

Submit

10. What is a slowly changing dimension (SCD)?

A dimension that changes frequently and requires version tracking

A dimension that rarely or never changes

A dimension used only in real-time analytics

A dimension with missing data values

11. What is a data warehouse primarily designed to do?

Store transactional data for daily operations

Consolidate and analyze historical data for business intelligence

Replace all operational databases

Process real-time streaming data only

12. True or False: A data mart is a smaller, subject-specific subset of a data warehouse.

True

False

Submit

14. What is the primary advantage of denormalization in data warehouses?

Reduces data redundancy

Improves query performance and readability

Eliminates the need for indexes

Simplifies database administration

15. Which normalization form eliminates partial dependencies?

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

Boyce-Codd Normal Form (BCNF)

16. What is a fact table in dimensional modeling?

A table storing customer contact information

A table containing measurements and metrics tied to dimensions

A table used only for data validation

A table that stores historical changes

Submit

18. What does ETL stand for in data warehouse terminology?

Extract, Transform, Load

Evaluate, Translate, Link

Execute, Track, Learn

Encode, Transfer, Locate

19. Which Azure service is best suited for building a cloud-based data warehouse?

Azure Cosmos DB

Azure SQL Data Warehouse (Synapse Analytics)

Azure Blob Storage

Azure Table Storage

Azure Data Fundamentals Data Warehouse Concepts Quiz

1. Which of the following is a characteristic of OLAP systems?

2.

What first name or nickname would you like us to use?

2. Azure Synapse Dedicated SQL Pool provides ____-based processing for large-scale analytics.

3. What is a conformed dimension?

4. True or False: OLTP systems are designed for analytical reporting and complex queries.

5. What is the purpose of a data staging area in a warehouse?

6. Azure Data Lake Storage is optimized for ____.

7. What does a surrogate key provide in dimensional modeling?

8. True or False: Columnar storage is less efficient than row storage for analytical queries.

9. In Azure Synapse Analytics, what is a ____ used to distribute data across compute nodes?

10. What is a slowly changing dimension (SCD)?

11. What is a data warehouse primarily designed to do?

12. True or False: A data mart is a smaller, subject-specific subset of a data warehouse.

13. Azure Data Factory is primarily used for ____.

14. What is the primary advantage of denormalization in data warehouses?

15. Which normalization form eliminates partial dependencies?

16. What is a fact table in dimensional modeling?

17. In a star schema, the ____ table contains descriptive attributes and dimensions.

18. What does ETL stand for in data warehouse terminology?

19. Which Azure service is best suited for building a cloud-based data warehouse?