Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 1 question 41 discussion

Actual exam question from Microsoft's DP-203

Question #: 41
Topic #: 1

DRAG DROP -
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:

Show Suggested Answer

Suggested Answer:

Step 1: Create an external data source
You can create external tables in Synapse SQL pools via the following steps:
1. CREATE EXTERNAL DATA SOURCE to reference an external Azure storage and specify the credential that should be used to access the storage.
2. CREATE EXTERNAL FILE FORMAT to describe format of CSV or Parquet files.
3. CREATE EXTERNAL TABLE on top of the files placed on the data source with the same file format.
Step 2: Create an external file format object
Creating an external file format is a prerequisite for creating an external table.
Step 3: Create an external table
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tables

by gf2tw at Dec. 10, 2021, 10:07 a.m.

Comments

Submit Cancel

avijitd

Highly Voted 3 years, 1 month ago

Looks correct answer

upvoted 41 times

...

vctrhugo

Highly Voted 1 year, 7 months ago

1. CREATE EXTERNAL DATA SOURCE to reference an external Azure storage and specify the credential that should be used to access the storage. 2. CREATE EXTERNAL FILE FORMAT to describe format of CSV or Parquet files. 3. CREATE EXTERNAL TABLE on top of the files placed on the data source with the same file format.

upvoted 21 times

...

dgerok

Most Recent 10 months, 1 week ago

The answer is correct

upvoted 1 times

...

kkk5566

1 year, 5 months ago

source, format ,external

upvoted 1 times

...

CrazyHorse

2 years, 5 months ago

If I run CREATE EXTERNAL FILE FORMAT before CREATE EXTERNAL DATA SOURCE, will it change something?

upvoted 6 times

almachg

1 year, 10 months ago

Can anyone who knows answer this, would like to know too. Asked chatgpt and it says there's no functional difference. However, it is generally considered a best practice to create the external file format before the external data source.

upvoted 3 times

aemilka

1 year, 10 months ago

"More than one order of answer choices is correct", so it seems to me that CREATE EXTERNAL FILE FORMAT before CREATE EXTERNAL DATA SOURCE should be accepted too.

upvoted 5 times

...

zekescookies

1 year, 9 months ago

It doesn't really matter in which order you create a file format or a data source. I have done it in different orders before.

upvoted 4 times

...

Deeksha1234

2 years, 6 months ago

given answer is correct

upvoted 1 times

...

Dicer

2 years, 6 months ago

why creating a query that creates a table is not correct?

upvoted 1 times

VeroDon

2 years, 6 months ago

CeTAS also exports the query results to Blob storage or Data LAke. Its not a requirement in this question :) https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-cetas

upvoted 3 times

...

SKN0865

2 years, 7 months ago

Correct: See Microsoft docs: You can create external tables in Synapse SQL pools via the following steps: 1) CREATE EXTERNAL DATA SOURCE to reference an external Azure storage and specify the credential that should be used to access the storage. 2) CREATE EXTERNAL FILE FORMAT to describe format of CSV or Parquet files. 3) CREATE EXTERNAL TABLE on top of the files placed on the data source with the same file format.

upvoted 5 times

...