Question 300
A platform governance committee considers: An analyst calculates monthly moving averages but an unbounded window includes later months and changes historical metrics. What preventive check should be standardized?
Explanation
Correct Answer
Use boundary and late-arriving data tests for rolling aggregate SQL. This reduces recurrence of: Window frames set which rows participate in each rolling calculation. The verification should demonstrate: A fixture's early months are unaffected by events occurring after their timestamp.
Incorrect Answers
Use query linting and controlled row-count assertions for production joins. That safeguard is aimed at ANOTHER risk: A query uses a comma-separated FROM list and a missing join predicate multiplies rows, inflating sales totals. It is less targeted than the control for: Window frames set which rows participate in each rolling calculation.
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: Window frames set which rows participate in each rolling calculation.
Reevaluate predicate selectivity and credit impact after query pattern changes. That safeguard is aimed at ANOTHER risk: A selective point lookup needs acceleration but an engineer wants to recluster an entire table without measuring existing pruning. It is less targeted than the control for: Window frames set which rows participate in each rolling calculation.