You have an Azure Synapse Analytics serverless SQL pool. You need to return a list of files and the number of rows in each file. How should you complete the Transact-SQL statement? To answer, drag…

The complete Transact-SQL statement is: SELECT asa.filename() AS [filename], COUNT_BIG() AS [rows] FROM OPENROWSET ( BULK 'parquet/production/year=2017/month=9/.parquet', DATA_SOURCE = 'datalake1', FORMAT = 'PARQUET' ) asa GROUP BY [filename]

Query and transform data

Question

You have an Azure Synapse Analytics serverless SQL pool. You need to return a list of files and the number of rows in each file.
How should you complete the Transact-SQL statement? To answer, drag the appropriate values to the 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.

Exhibit

Explanation

The complete Transact-SQL statement is:

SELECT asa.filename() AS [filename], COUNT_BIG() AS [rows] FROM OPENROWSET ( BULK 'parquet/production/year=2017/month=9/.parquet', DATA_SOURCE = 'datalake1', FORMAT = 'PARQUET' ) asa GROUP BY [filename]

Topics

#Azure Synapse Analytics#Serverless SQL Pool#T-SQL Functions#File Metadata

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice