Check your knowledge

Answer the following questions to see what you've learned.

What does data granularity mean?

The amount of data that you have, meaning that higher granularity means more data to work with.

The level of detail in your data, meaning that higher granularity means more detailed data.

Data granularity is a type of schema design.

What is the difference between a fact table and a dimension table?

Fact tables contain observational data while dimension tables contain information about specific entities within the data.

Fact tables contain information about specific entities while dimension tables contain information about observational data.

There is no difference.

Choose the best answer to explain relationship cardinality?

Cardinality is the measure of unique values in a table.

Cardinality is the granularity of the data.

Cardinality is how long it takes for the data to load.

You must answer all questions before checking your work.