Microsoft
DP-203 · Question #344
You have an Azure subscription that contains a storage account named storage1 and an Azure Synapse Analytics dedicated SQL pool. The storage1 account contains a CSV file that requires an account key f
The correct answer is B. a database scoped credential. https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/create-use-external-tables
Submitted by miguelv· Mar 30, 2026Design and implement data storage
Question
You have an Azure subscription that contains a storage account named storage1 and an Azure Synapse Analytics dedicated SQL pool. The storage1 account contains a CSV file that requires an account key for access. You plan to read the contents of the CSV file by using an external table. You need to create an external data source for the external table. What should you create first?
Options
- Aa database role
- Ba database scoped credential
- Ca database view
- Dan external file format
How the community answered
(36 responses)- A3% (1)
- B72% (26)
- C17% (6)
- D8% (3)
Explanation
https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/create-use-external-tables
Topics
#database scoped credential#external table#external data source#ADLS Gen2
Community Discussion
No community discussion yet for this question.