Question 520
A model has mixed Import and DirectQuery sources and analysts expect a single relationship to behave as if both datasets were always current. What should the acceptance test demonstrate?
Explanation
Correct Answer
This directly verifies the intended outcome: Composite models need deliberate storage and freshness assumptions. The accepted result is: Reports show correct totals under tested source states and clearly identified refresh boundaries.
Incorrect Answers
DirectQuery can query live source.
Imported rows may be stale.
Lack of visibility obscures stale results.