Microsoft
AZ-305 · Question #294
Hotspot Question You are building an Azure web app that will store the Personally Identifiable Information (PII) of employees. You need to recommend an Azure SQL. Database solution for the web app. Th
Sign in or unlock AZ-305 to reveal the answer and full explanation for question #294. The question stem and answer options stay visible for context.
Submitted by satoshi_tk· Mar 6, 2026Design data storage solutions
Question
Hotspot Question You are building an Azure web app that will store the Personally Identifiable Information (PII) of employees. You need to recommend an Azure SQL. Database solution for the web app. The solution must meet the following requirements: - Maintain availability in the event of a single datacenter outage. - Support the encryption of specific columns that contain PII. - Automatically scale up during payroll operations. - Minimize costs. What should you include in the recommendations? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer:
Exhibit
Answer Area
- Service tier and computer tier:Business Critical service tier and Serverless computer tierGeneral Purpose service tier and Serverless computer tierHyperscale service tier and Provisioned compute tier
- Encryption method:Always EncryptedMicrosoft SQL Server and database encryption keysTransparent 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
#Azure SQL Database#Always Encrypted#Database Service Tiers#High Availability
