Question 120
A landing table contains XML-like or JSON-like values varying by row. Which flexible data type should it evaluate?
Explanation
Correct Answer
Correct: heterogeneous values in one column. VARIANT can hold a value of a supported semi-structured or scalar type.
Incorrect Answers
Not best here: OBJECT represents an unordered collection of key-value pairs; the problem instead requires heterogeneous values in one column.
Not best here: ARRAY represents an ordered sequence of elements; the problem instead requires heterogeneous values in one column.
Not best here: VARCHAR stores ordinary character strings without native nested-type semantics; the problem instead requires heterogeneous values in one column.