nerdexam
MicrosoftMicrosoft

AZ-305 · Question #435

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

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

Submitted by paula_co· 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. - Database administrators must be prevented from seeing the employees' 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:

Options

  • __typehotspot
  • variantdropdown

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

#Azure SQL Managed Instance#Data security#Dynamic Data Masking#Always Encrypted#Data privacy
Full AZ-305 PracticeBrowse All AZ-305 Questions