nerdexam
Microsoft

AZ-305 · Question #329

Hotspot Question You have an Azure subscription. The subscription contains an Azure SQL managed instance that stores employee details, including social security numbers and phone numbers. You need to

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

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

Question

Hotspot Question You have an Azure subscription. The subscription contains an Azure SQL managed instance that stores employee details, including social security numbers and phone numbers. You need to configure the managed instance to meet the following requirements: - The helpdesk team must see only the last four digits of an employee's phone number. - Cloud administrators must be prevented from seeing the employee's social security numbers. What should you enable for each column in the managed instance? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer:

Exhibit

AZ-305 question #329 exhibit

Answer Area

  • Phone numbers:
    Always EncryptedColumn encryptionDynamic data maskingTransparent Data Encryption (TDE)
  • Social security numbers:
    Always EncryptedColumn encryptionDynamic data maskingTransparent Data Encryption (TDE)

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.

Topics

#dynamic data masking#Always Encrypted#Azure SQL Managed Instance#column-level security
Full AZ-305 Practice