Question 200
A product dimension has many records per SKU version but the fact must join the version active on the sale date. What should the engineer verify before declaring success?
Explanation
Correct Answer
This outcome directly verifies the scenario's required behavior: temporal joins need validity windows, not only static product keys.
Incorrect Answers
New descriptions overwrite historical reporting context.
Multiple historical versions match one sale.
Nondeterministic selection cannot guarantee effective-date correctness.