Multiple choice technology web technology

Data in a fact table can be at different grains

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Fact tables in a dimensional model must maintain a single, consistent grain - all rows in a fact table should represent the same level of detail (e.g., all at daily level, or all at transaction level). Mixing grains in a single fact table violates dimensional modeling principles and causes analytical errors.

Keep practicing — related questions