Exam DP-203 topic 1 question 114 discussion

Actual exam question from Microsoft's DP-203

Question #: 114
Topic #: 1

HOTSPOT
-

You have an Azure Data Lake Storage account that contains CSV files. The CSV files contain sales order data and are partitioned by using the following format.

/data/salesorders/year=xxxx/month=y

You need to retrieve only the sales orders from January 2023 and February 2023.

How should you complete the query? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by Sleuth at June 6, 2024, 8:41 a.m.

Comments

Submit Cancel

Sleuth

Highly Voted 11 months, 2 weeks ago

Answer is correct see below link for more details on filepath() function https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-specific-files#filepath

upvoted 5 times

...

CezarioAbrantesPP

Most Recent 10 months, 3 weeks ago

SELECT r.filepath() AS filepath ,r.filepath(1) AS [year] ,r.filepath(2) AS [month] ,COUNT_BIG(*) AS [rows] FROM OPENROWSET( BULK 'csv/taxi/yellow_tripdata_*-*.csv', DATA_SOURCE = 'SqlOnDemandDemo', FORMAT = 'CSV', PARSER_VERSION = '2.0', FIRSTROW = 2 ) WITH ( vendor_id INT ) AS [r] WHERE r.filepath(1) IN ('2017') AND r.filepath(2) IN ('10', '11', '12') GROUP BY r.filepath() ,r.filepath(1) ,r.filepath(2) ORDER BY filepath;

upvoted 2 times

...

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 1 question 114 discussion

Comments

Sleuth

CezarioAbrantesPP

SY0-701