Question 980
An API migration needs to expand a JSON address list for each customer while retaining the parent row key. The team implemented this change: Use CROSS APPLY with an appropriate JSON rowset expression. Which result would best confirm the change worked?
Explanation
Correct Answer
Each customer yields correct child addresses with the right parent keys. CROSS APPLY can correlate a table-valued expression with each outer row.
Incorrect Answers
That observation could pass while the problem persists: CROSS APPLY correlates each rowset expression with its source customer; keys must be retained explicitly.
This acceptance test measures the wrong outcome: CROSS APPLY omits unmatched outer rows; use OUTER APPLY when empty collections must retain parents.
The suggested success signal is inadequate because Validate typed mappings, duplicates and parent keys as separate requirements from rowset expansion. The suggested measurement would appear successful even in a reproducible case where the original failure remains.