Multiple choice technology databases

Fact tables are which of the following?

  1. Completely normalized

  2. Partially normalized

  3. Completely denormalized

  4. Partially denormalized
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Fact tables in dimensional modeling are typically completely normalized - they contain only foreign keys to dimension tables and numeric measures. The normalization prevents update anomalies and ensures efficient querying. Dimension tables, by contrast, are often denormalized for query performance. Fact tables don't contain redundant data.

Keep practicing — related questions