Question 370
A VARIANT column stores a JSON number as a string in some rows, causing downstream SUM to fail. Which test result would demonstrate that the intended data contract is met?
Explanation
Correct Answer
Expected numeric and malformed string fixtures yield defined sums and quarantine outcomes. This is the most directly relevant verification 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
Generated text is not automatically a stable typed relational contract. That consideration does not remove the current constraint: semi-structured values need type normalization before numerical aggregation.
Replaying unchanged invalid input repeats the same deterministic rejection. For the observed behavior, semi-structured values need type normalization before numerical aggregation.
A post-join WHERE predicate rejects null-extended outer-join rows. The controlling issue in this question is that semi-structured values need type normalization before numerical aggregation.