2. Data Engineering

Data Modeling — Quiz

Test your understanding of data modeling with 5 practice questions.

Practice Questions

Question 1

Which of the following data modeling approaches is primarily optimized for analytical querying and reporting?

Question 2

In relational database design, what is the primary purpose of a 'candidate key'?

Question 3

Which normal form (NF) requires that all non-key attributes are dependent on the primary key, the whole primary key, and nothing but the primary key?

Question 4

Consider a dimensional model for sales data. Which of the following would be an example of a 'measure' typically found in a fact table?

Question 5

What is the primary characteristic of a 'snowflake schema' in dimensional modeling?