nerdexam
Microsoft

DP-203 · Question #261

A famous online payment gateway provider is creating a new product where the users can pay their credit card bills and earn reward coins. As part of compliance, they need to ensure that all the data,

Sign in or unlock DP-203 to reveal the answer and full explanation for question #261. The question stem and answer options stay visible for context.

Submitted by wei.xz· Mar 30, 2026Secure, monitor, and optimize data storage and data processing

Question

A famous online payment gateway provider is creating a new product where the users can pay their credit card bills and earn reward coins. As part of compliance, they need to ensure that all the data, including credit card details and PIIs, are securely kept. This product is backed by a dedicated SQL pool in azure Synapse analytics. The major concern is that the database team that performs maintenance should not be able to view the customer's info. Which of the following can be the best solution?

Options

  • AImplement Transparent data encryption
  • BUse Azure Defender for SQL
  • CUse Dynamic data masking (DDM)
  • DAssign only SQL security manager role to maintenance team members

Unlock DP-203 to see the answer

You've previewed enough free DP-203 questions. Unlock DP-203 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#dynamic data masking#dedicated SQL pool#PII protection#maintenance team access
Full DP-203 Practice