Question 60
A platform governance committee considers: An analyst sums values extracted from a VARIANT JSON payload but obtains string concatenation or conversion errors. What preventive check should be standardized?
Explanation
Correct Answer
Add data-type assertions for common JSON attributes in transformation tests. This reduces recurrence of: Semi-structured extraction produces typed VARIANT expressions that require deliberate conversion for arithmetic. The verification should demonstrate: A fixture with numeric and invalid payloads yields expected sums and explicit rejected or null values.
Incorrect Answers
Test idempotent replay and multiple-source-match conflicts before release. That safeguard is aimed at ANOTHER risk: A developer wants to update target customer records from daily source changes but uses INSERT for every delivery. It is less targeted than the control for: Semi-structured extraction produces typed VARIANT expressions that require deliberate conversion for arithmetic.
Use boundary and late-arriving data tests for rolling aggregate SQL. That safeguard is aimed at ANOTHER risk: An analyst calculates monthly moving averages but an unbounded window includes later months and changes historical metrics. It is less targeted than the control for: Semi-structured extraction produces typed VARIANT expressions that require deliberate conversion for arithmetic.
Include root task state and graph status in deployment checks. That safeguard is aimed at ANOTHER risk: A scheduled task references a warehouse that is suspended and does not execute after an administrator forgets to resume the task graph. It is less targeted than the control for: Semi-structured extraction produces typed VARIANT expressions that require deliberate conversion for arithmetic.