# AZ-305 — Question 843

**Type:** hot_area
**Topics:** azure, sql_database, security, scalability

## Question

HOTSPOT
-

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.

//IMG//

## Correct Answer

_See scenario._

**Reference:** examtopics_top_comment

---
Source: https://hiexam.net/q/microsoft/AZ-305/843  
Practice (tracked): https://hiexam.net/study/AZ-305/practice