DP-203 Practice Question: Secure, monitor, and optimize data storage and data processing
You have an Azure Stream Analytics job that writes output to Azure Synapse Analytics. You need to ensure that the job can authenticate to Synapse Analytics using a managed identity. What should you do?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Enable system-assigned managed identity on the Stream Analytics job and configure the output to use it.
To authenticate to Azure Synapse Analytics using a managed identity, you should enable the system-assigned managed identity on the Stream Analytics job (it is enabled by default) and then configure the output to use managed identity authentication. Option A is correct. Option B is incorrect because a SAS token is not a managed identity. Option C is incorrect because while a user-assigned managed identity could be used, the system-assigned managed identity is sufficient and is the simpler option. Option D is incorrect because SQL Server authentication does not use managed identity and is less secure than managed identity authentication.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Enable system-assigned managed identity on the Stream Analytics job and configure the output to use it.
Why this is correct
This is the correct method to use managed identity for authentication.
- ✗
Generate a shared access signature (SAS) token for the Synapse Analytics workspace.
Why it's wrong here
SAS tokens are not used for Synapse Analytics authentication from Stream Analytics.
- ✗
Create a user-assigned managed identity and assign it to the Stream Analytics job.
Why it's wrong here
A user-assigned managed identity cannot be assigned to a Stream Analytics job because the service only supports system-assigned managed identities for authenticating to Azure Synapse Analytics. This option is tempting because user-assigned identities are commonly used across many Azure services to grant granular, reusable permissions, and would be correct for scenarios where multiple resources need to share the same identity, such as when several jobs must authenticate to the same Synapse workspace without individual identity management.
- ✗
Configure the output to use SQL Server authentication with a username and password.
Why it's wrong here
This is not managed identity authentication.
Go deeper
Related to this question
Learn chapter
Introduction to Azure Data Engineering
Key term
Azure Synapse Analytics
Azure Synapse Analytics is a cloud-based data integration, warehousing, and analytics service that brings together big data and data warehouse capabilities under one platform.
Key term
Azure Stream Analytics
Azure Stream Analytics is a fully managed, real-time data processing service that analyzes and transforms high volumes of streaming data from various sources to deliver low-latency insights and trigger actions.
About these practice questions
Courseiva writes every DP-203 question from scratch — 760 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-203 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-203 exam.