Multiple choice technology

If you worked for a retail company that changed prices on a very frequent basis, how would you model the price?

  1. In the master data table as an attribute

  2. In the transaction table as a new characteristic

  3. In the ODS to enhance performance

  4. In the fact table
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Frequently changing prices should be modeled as time-dependent transaction data, not static master data attributes. This preserves historical price accuracy and supports performance. The ODS (C) and fact table (D) are incorrect for this use case.

Keep practicing — related questions