Question 560
A downstream warehouse must reconstruct detailed changes from a high-volume source table. What should a technical reviewer verify before approving completion?
Explanation
Correct Answer
CDC records change data for replay, unlike simple change tracking versions. The observation “A replay of change tables reconstructs expected mutations including relevant old and new values” directly confirms the chosen action worked for this situation: A downstream warehouse must reconstruct detailed changes from a high-volume source table.
Incorrect Answers
API schema exposure does not supersede stored-procedure privileges or input governance. This observation would not establish that the required result occurred for A downstream warehouse must reconstruct detailed changes from a high-volume source table. The confirming test is: A replay of change tables reconstructs expected mutations including relevant old and new values.
API pagination and predicates reduce overfetching; unsupported query fields must be controlled. This observation would not establish that the required result occurred for A downstream warehouse must reconstruct detailed changes from a high-volume source table. The confirming test is: A replay of change tables reconstructs expected mutations including relevant old and new values.
Tempdb spills indicate memory/workload mismatch and should be diagnosed from actual plans. This observation would not establish that the required result occurred for A downstream warehouse must reconstruct detailed changes from a high-volume source table. The confirming test is: A replay of change tables reconstructs expected mutations including relevant old and new values.