Question

Data granularity refers to:

a.
the primary key in the dimension table in the data warehouse.

b.
the foreign key in the dimension table in the data warehouse.

c.
the level of detail in the fact table in the data warehouse.

d.
the primary key in the fact table in the data warehouse.

Answer 1

(C).The level of detail in the fact table in the data warehouse.

Step-by-step explanation:

Data Granularity is the level of detail of the data stored in the fact table in the data warehouse.If the granularity is high it means that the data which is detailed that is near or at the transaction level . If the granularity is Low it means the data which is summarized or aggregated, usually from the transaction level data.