DP-203 Certification Practice Question #35

Question

You need to build a solution to ensure that users can query specific files in an Azure Data Lake Storage Gen2 account from an Azure Synapse Analytics serverless SQL pool.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Select and Place:

Accepted Answer

The task is to let a serverless SQL pool query files in ADLS Gen2 as external data. Microsoft Learn describes that pattern as creating an external data source for the storage location, an external file format that describes the files, and then an external table that points at those files. The community answer is strong and consistent, and the only minor dissent is that file format and data source can be created in either order. Since the exam asks for one valid sequence and the docs present data source before file format before external table, that sequence is the safest answer.

More DP-203 practice questions