Question 140
A platform governance committee considers: A dataset stores orders as nested JSON arrays, but a report produces one row per order instead of one per line item. What preventive check should be standardized?
Explanation
Correct Answer
Include empty-array and missing-key cases in flattening tests. This reduces recurrence of: FLATTEN expands nested semi-structured arrays into relational rows. The verification should demonstrate: The output includes one row per intended order line while preserving source order identifiers.
Incorrect Answers
Document expected tie behavior in analytic report requirements. That safeguard is aimed at ANOTHER risk: A finance report uses RANK to assign unique row numbers but produces ties and gaps in the sequence. It is less targeted than the control for: FLATTEN expands nested semi-structured arrays into relational rows.
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: FLATTEN expands nested semi-structured arrays into relational rows.
Track query-hit frequency and refresh credits for every materialized view. That safeguard is aimed at ANOTHER risk: An organization enables multiple materialized views for rarely used reports and sees maintenance charges rising above query savings. It is less targeted than the control for: FLATTEN expands nested semi-structured arrays into relational rows.