Question 290
A source feed includes a nested JSON array of product items and a Silver table needs one row per item. Which test result satisfies the scenario?
Explanation
Correct Answer
This directly verifies the intended outcome: Array expansion converts nested repeat elements into relational rows. The accepted result is: Orders with three items produce three traceable item rows.
Incorrect Answers
Lineage to its order is lost.
Cartesian pairs create false items.
Row-level item measures become difficult.