Question 870
A VARIANT column stores a JSON number as a string in some rows, causing downstream SUM to fail. Which prevention step most appropriately addresses the root cause?
Explanation
Correct Answer
Validate expected type distributions before analytics. This is the most directly relevant preventive control because semi-structured values need type normalization before numerical aggregation. A concrete acceptance check is: Expected numeric and malformed string fixtures yield defined sums and quarantine outcomes. To reduce recurrence: Validate expected type distributions before analytics.
Incorrect Answers
Hash partitioning concentrates a dominant key into one reducer partition. For the observed behavior, semi-structured values need type normalization before numerical aggregation.
Lexical ordering and time-based ranges are not equivalent for irregular date strings. The controlling issue in this question is that semi-structured values need type normalization before numerical aggregation.
Warning-only checks cannot enforce a stop-on-violation business requirement. Here the important technical distinction is that semi-structured values need type normalization before numerical aggregation.