Question 90
Scenario: A service returns an array of product tags for each order and the report requires one order-tag row per tag. Which configuration or calculation is the most appropriate?
Explanation
Correct Answer
This directly addresses the stated constraint. Expand-to-rows preserves one-to-many element relationships for list-valued columns. Confirmation: An order with three tags produces three rows linked to the same order ID.
Incorrect Answers
Choosing DirectQuery over a separate SQL endpoint misses the requested DirectLake path. The specific problem here is that expanding tag lists to a single concatenated scalar loses individual tag-level filtering.
Changing only the display format leaves mismatched underlying text/integer key types. The specific problem here is that expanding tag lists to a single concatenated scalar loses individual tag-level filtering.
Hard-coding the server name separately into twelve queries makes environment switches error-prone. The specific problem here is that expanding tag lists to a single concatenated scalar loses individual tag-level filtering.