nerdexam
MicrosoftMicrosoft

AZ-305 · Question #130

AZ-305 Question #130: Real Exam Question with Answer & Explanation

Sign in or unlock AZ-305 to reveal the answer and full explanation for question #130. The question stem and answer options stay visible for context.

Submitted by brentm· Mar 6, 2026Design data storage solutions

Question

You have to deploy an Azure SQL database named db1 for your company. The databases must meet the following security requirements: - When IT help desk supervisors query a database table named customers, they must be able to see the full number of each credit card - When IT help desk operators query a database table named customers, they must only see the last four digits of each credit card number - A column named Credit Card rating in the customers table must never appear in plain text in the database system. - Only client applications must be able to decrypt the information that is stored in this column Which of the following can be implemented for the Credit Card rating column security requirement?

Options

  • AAlways Encrypted
  • BAzure Advanced Threat Protection
  • CTransparent Data Encryption
  • DDynamic Data Masking

Unlock AZ-305 to see the answer

You've previewed enough free AZ-305 questions. Unlock AZ-305 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.

Full AZ-305 PracticeBrowse All AZ-305 Questions