Question 10
What is the most relevant root cause when this requirement fails? A public REST endpoint returns monthly inventory JSON, and the analyst needs to ingest its supported objects into Power Query.
Explanation
Correct Answer
This defect explains why the required behavior failed. The Web connector and structured-data expansion convert API payloads to tabular data. The corrective action is: Use the Web connector with appropriate authentication and expand the returned JSON records into a table.
Incorrect Answers
Removing the business transaction key breaks later relationships and reconciliation. The stated evidence instead indicates: Attempting to connect using the SQL Server connector will not parse a REST JSON response.
Merging April to May by customer ID would combine columns instead of stacking transactions. The stated evidence instead indicates: Attempting to connect using the SQL Server connector will not parse a REST JSON response.
Accepting the automatic comma delimiter splits monetary numbers into stray columns. The stated evidence instead indicates: Attempting to connect using the SQL Server connector will not parse a REST JSON response.