ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam
Go to Exam

Exam DP-203 topic 4 question 69 discussion

Actual exam question from Microsoft's DP-203
Question #: 69
Topic #: 4
[All DP-203 Questions]

You have an Azure Blob storage account named storage1 and an Azure Synapse Analytics serverless SQL poo1 named Pool1.

From Pool1, you plan to run ad-hoc queries that target storage1.

You need to ensure that you can use shared access signature (SAS) authorization without defining a data source.

What should you create first?

  • A. a stored access policy
  • B. a server-level credential
  • C. a managed identity
  • D. a database scoped credential
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by samianae at Jan. 27, 2025, 3:27 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
imatheushenrique
1 month, 2 weeks ago
Selected Answer: D
D. a database scoped credential When querying Azure Blob Storage (storage1) from Azure Synapse Analytics serverless SQL pool (Pool1) using Shared Access Signature (SAS) authorization, you need a way for Synapse to authenticate to the storage without explicitly defining a data source. To achieve this, you must: Create a database-scoped credential that stores the SAS token. Use OPENROWSET or external tables to query the data.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago