Microsoft Exam DP-203 Topic 11 Question 18 Discussion

Actual exam question for Microsoft's DP-203 exam

Question #: 18
Topic #: 11

You have files and folders in Azure Data Lake Storage Gen2 for an Azure Synapse workspace as shown in the following exhibit.

You create an external table named ExtTable that has LOCATION='/topfolder/'.

When you query ExtTable by using an Azure Synapse Analytics serverless SQL pool, which files are returned?

AFile2.csv and File3.csv only

BFile1.csv and File4.csv only

CFile1.csv, File2.csv, File3.csv, and File4.csv

DFile1.csv only

Show Suggested Answer

Suggested Answer: C

To run a T-SQL query over a set of files within a folder or set of folders while treating them as a single entity or

rowset, provide a path to a folder or a pattern (using wildcards) over a set of files or folders.

by Cassi at May 03, 2022, 08:03 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!