Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 2 question 80 discussion

Actual exam question from Microsoft's DP-203

Question #: 80
Topic #: 2

HOTSPOT -
You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool named Pool1 and an Azure Data Lake Storage account named storage1. Storage1 requires secure transfers.
You need to create an external data source in Pool1 that will be used to read .orc files in storage1.
How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-external-data-source-transact-sql?view=azure-sqldw-latest&preserve-view=true&tabs=dedicated

by Hema_V at Sept. 3, 2022, 3:25 a.m.

Comments

Submit Cancel

Hema_V

Highly Voted 1 year, 7 months ago

Answer: abfss and Hadoop Hint: Storage1 requires secure transfers --> The default option is to use enable secure SSL connections when provisioning Azure Data Lake Storage Gen2. When this is enabled, you must use abfss when a secure TLS/SSL connection is selected. Reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-external-data-source-transact-sql?view=azure-sqldw-latest&preserve-view=true&tabs=dedicated

upvoted 40 times

...

vigilante89

Highly Voted 1 year, 4 months ago

abfss and Hadoop

upvoted 7 times

...

kkk5566

Most Recent 8 months ago

Answer: abfss and Hadoop

upvoted 2 times

...

ZIMARAKI

1 year, 3 months ago

abfss & hadoop

upvoted 5 times

...

greenlever

1 year, 6 months ago

abfss Hadoop abfss endpoint when your account has secure transfer enabled

upvoted 6 times

...

sesank

1 year, 7 months ago

abfss Hadoop

upvoted 4 times

...

anks84