DP-203 · Question #149
Drag and Drop Question You have an Azure Synapse Analytics workspace named WS1. You have an Azure Data Lake Storage Gen2 container that contains JSON-formatted files in the following format. You need
The correct answer is openrowset; openjson. OPENROWSET is the correct first function because it is used in Azure Synapse serverless SQL pools to read data from external sources such as Azure Data Lake Storage Gen2, allowing you to specify the file path, format, and credentials. OPENJSON is the correct second function becau
Question
Exhibit
Answer Area
Drag items
Correct arrangement
- openrowset
- openjson
Explanation
OPENROWSET is the correct first function because it is used in Azure Synapse serverless SQL pools to read data from external sources such as Azure Data Lake Storage Gen2, allowing you to specify the file path, format, and credentials. OPENJSON is the correct second function because it parses JSON-formatted text and returns the data as rows and columns, which is necessary to shred the nested JSON structure into a relational format that SQL can work with. Together, OPENROWSET retrieves the raw file content and OPENJSON transforms the JSON payload into queryable tabular data.
Topics
Community Discussion
No community discussion yet for this question.