Microsoft Cybersecurity Architect Expert SC-100
Get started today
Ultimate access to all questions.
Your company currently uses on-premises Microsoft SQL Server databases and is planning to migrate these databases to Azure. In this scenario, it is essential to develop a secure architecture that reduces the operational burden related to patch management and employs dynamic data masking to safeguard sensitive information. Additionally, given the budgetary constraints, the architecture should also focus on cost minimization. What solution would you recommend considering these requirements?
Your company currently uses on-premises Microsoft SQL Server databases and is planning to migrate these databases to Azure. In this scenario, it is essential to develop a secure architecture that reduces the operational burden related to patch management and employs dynamic data masking to safeguard sensitive information. Additionally, given the budgetary constraints, the architecture should also focus on cost minimization. What solution would you recommend considering these requirements?
Explanation:
Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement. Azure SQL Database is always running on the latest stable version of the SQL Server database engine and patched OS with 99.99% availability. PaaS capabilities built into Azure SQL Database enable you to focus on the domain-specific database administration and optimization activities that are critical for your business. Additionally, it supports dynamic data masking to protect sensitive data and is cost-effective, making it the most suitable option for the scenario described.