Microsoft Cybersecurity Architect — Question 85

Your company has on-premises Microsoft SQL Server databases.
The company plans to move the databases to Azure.
You need to recommend a secure architecture for the databases that will minimize operational requirements for patching and protect sensitive data by using dynamic data masking. The solution must minimize costs.
What should you include in the recommendation?

Answer options

• A. Azure SQL Managed Instance
• B. Azure Synapse Analytics dedicated SQL pools
• C. Azure SQL Database
• D. SQL Server on Azure Virtual Machines

Correct answer: C

Explanation

The correct answer is Azure SQL Database because it offers built-in features like dynamic data masking and automatic patching, thus minimizing operational overhead. Azure SQL Managed Instance and SQL Server on Azure Virtual Machines may require more management and higher costs, while Azure Synapse Analytics is designed for large-scale analytics rather than operational database workloads.