DP-203 · Question #83
You have an Azure Synapse Analytics serverless SQL pool named Pool1 and an Azure Data Lake Storage Gen2 account named storage1. The AllowedBlobpublicAccess porperty is disabled for storage1. You…
The correct answer is C. database scoped credentials. User must have SELECT permission on an external table to read the data. External tables access underlying Azure storage using the database scoped credential defined in data source. Note: A database scoped credential is a record that contains the authentication information that…
Question
You have an Azure Synapse Analytics serverless SQL pool named Pool1 and an Azure Data Lake Storage Gen2 account named storage1. The AllowedBlobpublicAccess porperty is disabled for storage1. You need to create an external data source that can be used by Azure Active Directory (Azure AD) users to access storage1 from Pool1. What should you create first?
Options
- Aan external resource pool
- Ba remote service binding
- Cdatabase scoped credentials
- Dan external library
How the community answered
(26 responses)- A15% (4)
- B4% (1)
- C77% (20)
- D4% (1)
Explanation
User must have SELECT permission on an external table to read the data. External tables access underlying Azure storage using the database scoped credential defined in data source. Note: A database scoped credential is a record that contains the authentication information that is required to connect to a resource outside SQL Server. Most credentials include a Windows user https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tables https://docs.microsoft.com/en-us/sql/t-sql/statements/create-database-scoped-credential-
Topics
Community Discussion
No community discussion yet for this question.