DP-203 Exam - Question 123

Question

DRAG DROP -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 to use the serverless SQL pool in WS1 to read the files. How should you complete the Transact-SQL statement? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Select and Place:.

Examice · Accepted Answer

Box 1: openrowset -The easiest way to see to the content of your CSV file is to provide file URL to OPENROWSET function, specify csv FORMAT. Example:SELECT *FROM OPENROWSET(BULK 'csv/population/population. csv',DATA_SOURCE = 'SqlOnDemandDemo',FORMAT = 'CSV', PARSER_VERSION = '2. 0',FIELDTERMINATOR =',',ROWTERMINATOR = '
'Box 2: openjson -You can access your JSON files from the Azure File Storage share by using the mapped drive, as shown in the following example:SELECT book. * FROM -OPENROWSET(BULK N't:\books\books. json', SINGLE_CLOB) AS jsonCROSS APPLY OPENJSON(BulkColumn)WITH( id nvarchar(100), name nvarchar(100), price float,pages_i int, author nvarchar(100)) AS bookReference:https://docs. microsoft. com/en-us/azure/synapse-analytics/sql/query-single-csv-file https://docs. microsoft. com/en-us/sql/relational-databases/json/import-json-documents-into-sql-server.

Maunik · Answer

Answer is correct
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/query-json-files

gf2tw · Answer

The question and answer seem out of place, there was no mention of the CSV and the query in the answer doesn't match up with openjson at all

ELJORDAN23 · Answer

Answer is correct:
https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-json-files#query-json-files-using-openjson

PallaviPatel · Answer

correct

SebK · Answer

Correct

Deeksha1234 · Answer

correct

zorko10 · Answer

does openjson do the same thing as jsoncontent ? 
I tried running a query on a json file and the auto filled code used jsoncontent instead of openjson

mamahani · Answer

openrowset / openjson

kkk5566 · Answer

Answer is correct

KarlGardnerDataEngineering · Answer

This took me about 10 hours to understand this query

evangelist · Answer

To complete the Transact-SQL statement for reading JSON-formatted files using the serverless SQL pool in WS1, you should use OPENROWSET to access the data and OPENJSON to parse the JSON content. Here is the correct completion of the statement:

DP-203 Exam - Question 123

Discussion