Question 552 of 851

Secure, monitor, and optimize data storage and data processing →mediumMultiple ChoiceObjective-mapped

Secure Sensitive Data in Azure Synapse Analytics

This DP-203 practice question tests your understanding of secure, monitor, and optimize data storage and data processing. This is a configuration task: choose the command set that satisfies every stated requirement. Small differences — like 'secret' vs 'password' or 'transport input ssh' vs 'all' — change whether the answer is correct. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.

Your organization has an Azure Synapse Analytics dedicated SQL pool that stores sensitive customer data. You need to ensure that only authorized users can access the data, and auditing must be enabled to track all access attempts. What should you do first?

Clue words in this question

Noticing these words before you look at the options changes how you read each choice.

Clue: "first"
Why it matters: Order matters here. You are being tested on which action comes before the others — not which action is generally useful.

A
Implement column-level security to restrict sensitive columns.
Why wrong: Column-level security restricts access to specific columns but is not the first step; authentication and authorization must be configured first.
B
Enable auditing on the SQL pool and configure a storage account for audit logs.
Why wrong: Auditing tracks access attempts but does not prevent unauthorized access; it should be enabled after access controls are in place.
C
Configure Microsoft Entra ID authentication and use RBAC to grant only necessary permissions.
Configuring Microsoft Entra ID authentication and RBAC is the foundational step to control who can access the SQL pool, ensuring only authorized users have access.
D
Apply dynamic data masking to the sensitive columns.
Why wrong: Dynamic data masking hides sensitive data from unauthorized users but does not actually restrict access; it is a secondary measure.

Full breakdown with real-world context →

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

✓

Configure Microsoft Entra ID authentication and use RBAC to grant only necessary permissions.

Option C is correct because the first step to secure access to the Azure Synapse Analytics dedicated SQL pool is to configure authentication and authorization using Microsoft Entra ID and RBAC. This establishes who can access the pool and what they can do. Once that is in place, you can then implement additional security measures like auditing (option B), column-level security (option A), or dynamic data masking (option D), but these are secondary steps. Option B is not the first step because auditing tracks access but does not control it. Option A is too granular for initial access control. Option D obfuscates data but does not prevent unauthorized access.

Key principle: Authentication proves identity; authorization controls what that identity can do after login. Both must work for full privileged access.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
Implement column-level security to restrict sensitive columns.
Why it's wrong here
Column-level security restricts access to specific columns but is not the first step; authentication and authorization must be configured first.
✗
Enable auditing on the SQL pool and configure a storage account for audit logs.
Why it's wrong here
Auditing tracks access attempts but does not prevent unauthorized access; it should be enabled after access controls are in place.
✓
Configure Microsoft Entra ID authentication and use RBAC to grant only necessary permissions.
Why this is correct
Configuring Microsoft Entra ID authentication and RBAC is the foundational step to control who can access the SQL pool, ensuring only authorized users have access.
Clue confirmation
The clue word "first" in the question point toward this answer.
Related concept
Authentication checks who the user is.
✗
Apply dynamic data masking to the sensitive columns.
Why it's wrong here
Dynamic data masking hides sensitive data from unauthorized users but does not actually restrict access; it is a secondary measure.

Common exam traps

Common exam trap: authentication is not authorization

Logging in proves the user can authenticate. It does not automatically mean the user is allowed to enter privileged or configuration mode. Watch for AAA authorization, privilege level and command authorization details.

Detailed technical explanation

How to think about this question

This kind of question is testing the difference between identity and permission. A user may successfully log in to a router because authentication is working, but still fail to enter configuration mode because authorization is missing, misconfigured or mapped to a lower privilege level.

KKey Concepts to Remember

Authentication checks who the user is.
Authorization controls what the user is allowed to do after login.
Privilege levels affect access to EXEC and configuration commands.
AAA, TACACS+ and RADIUS can separate login success from command access.

TExam Day Tips

Do not assume successful login means full administrative access.
Look for words such as cannot enter configuration mode, privilege level, authorization or command access.
Separate login problems from permission problems before choosing the answer.

Key takeaway

Authentication proves identity; authorization controls what that identity can do after login. Both must work for full privileged access.

Real-world example

How this comes up in practice

A media company stores terabytes of video archives that are accessed once a year for audit purposes. Moving these objects to a cold storage tier (Azure Archive, S3 Glacier, or Google Nearline) costs a fraction of hot storage. Questions like this test whether you understand storage tiers, access frequency tradeoffs, and retrieval latency requirements.

Visual reference

Quick reference

Access Control Model Comparison

Model	Acronym	Who Controls Access?	Best For
Discretionary Access Control	DAC	Resource owner	Small teams, file shares
Mandatory Access Control	MAC	System / security labels	Classified govt / military
Role-Based Access Control	RBAC	Administrator (via roles)	Enterprise environments
Attribute-Based Access Control	ABAC	Policy engine (user + resource attributes)	Fine-grained, dynamic policies
Rule-Based Access Control	RuBAC	System rules / ACLs	Firewall rules, network ACLs

What to study next

Got this wrong? Here's your next step.

Review Cisco AAA concepts — authentication, authorization, and accounting. Study privilege levels (0–15), command authorization under TACACS+, and how RADIUS differs. Then practise related DP-203 questions on access control and AAA configuration.

Related DP-203 practice-question pages

Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.

Secure, monitor, and optimize data storage and data processing practice questions

Practise DP-203 questions linked to Secure, monitor, and optimize data storage and data processing.

Design and develop data processing practice questions

Practise DP-203 questions linked to Design and develop data processing.

Design and implement data security practice questions

Practise DP-203 questions linked to Design and implement data security.

Monitor and optimize data storage and processing practice questions

Practise DP-203 questions linked to Monitor and optimize data storage and processing.

Design and implement data storage practice questions

Practise DP-203 questions linked to Design and implement data storage.

Develop data processing practice questions

Practise DP-203 questions linked to Develop data processing.

DP-203 fundamentals practice questions

Practise DP-203 questions linked to DP-203 fundamentals.

DP-203 scenario practice questions

Practise DP-203 questions linked to DP-203 scenario.

DP-203 troubleshooting practice questions

Practise DP-203 questions linked to DP-203 troubleshooting.

Practice this exam

Start a free DP-203 practice session

Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.

10 questions 20 questions 30 questions 50 questions Timed 30

DP-203 practice-test guide →Study guide →Browse all practice tests

FAQ

Questions learners often ask

What does this DP-203 question test?

Secure, monitor, and optimize data storage and data processing — This question tests Secure, monitor, and optimize data storage and data processing — Authentication checks who the user is..

What is the correct answer to this question?

The correct answer is: Configure Microsoft Entra ID authentication and use RBAC to grant only necessary permissions. — Option C is correct because the first step to secure access to the Azure Synapse Analytics dedicated SQL pool is to configure authentication and authorization using Microsoft Entra ID and RBAC. This establishes who can access the pool and what they can do. Once that is in place, you can then implement additional security measures like auditing (option B), column-level security (option A), or dynamic data masking (option D), but these are secondary steps. Option B is not the first step because auditing tracks access but does not control it. Option A is too granular for initial access control. Option D obfuscates data but does not prevent unauthorized access.

What should I do if I get this DP-203 question wrong?

Are there clue words in this question I should notice?

Yes — watch for: "first". Order matters here. You are being tested on which action comes before the others — not which action is generally useful.

What is the key concept behind this question?

Authentication checks who the user is.

About these practice questions

Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

Keep practising

Question Discussion

Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.

Loading comments…

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.