An organization is planning to migrate a relational database to Azure. To minimize administrative overhead, the database solution must support automatic operating system patching, database software updates, and automated backups. Additionally, the database administrators require full administrative control over the underlying operating system to install custom third-party monitoring agents. The organization's cloud architect recommends deploying Azure SQL Database. Is this recommendation correct?
Answer: Answer
Answer
The recommendation is incorrect because Azure SQL Database, as a Platform as a Service (PaaS) offering, does not provide administrative access to the underlying operating system.
The recommendation is incorrect because Azure SQL Database is a fully managed Platform as a Service (PaaS) offering. While it satisfies the need for automatic patching, updates, and backups, it does not provide users with administrative access or control over the underlying operating system. To install custom monitoring agents directly on the OS, the organization would have to deploy their database on an Azure Virtual Machine (IaaS), which would then require them to manually manage OS and database updates.
Step-by-Step Solution
Key Concept
Understanding the management responsibilities and administrative boundaries of Azure PaaS relational database services versus IaaS database deployments.