Quick Quiz

Correct! A fact is an attribute that quantifies the performance of the business; for example, units sold or total sales.

Incorrect. This statement is true. A fact is an attribute that quantifies the performance of the business; for example, units sold or total sales.

Correct! The dimension table is a table within a relational database with a single part key that is joined to a fact table. Dimensions provide descriptions of the business subjects, and information about each row in the fact table. Dimension tables, including time dimension tables, are typically geometrically smaller than fact tables.

Incorrect. This statement is true. The dimension table is a table within a relational database with a single part key that is joined to a fact table. Dimensions provide descriptions of the business subjects, and information about each row in the fact table. Dimension tables, including time dimension tables, are typically geometrically smaller than fact tables.

Correct! Granularity refers to the level of detail in a fact table.

Incorrect. This statement is true. Granularity refers to the level of detail in a fact table.