Microsoft Azure Data Fundamentals — Question 174

You need to implement an Azure platform as a service (PaaS) service that will host a relational database. The solution must support built-in autoscaling.

Which service should you implement?

Answer options

• A. Azure SQL Database
• B. SQL Server on Azure Virtual Machines
• C. Azure SQL Managed Instance
• D. Azure SQL Edge

Correct answer: A

Explanation

Azure SQL Database is designed specifically as a PaaS solution that includes built-in autoscaling features, making it the ideal choice for hosting relational databases. In contrast, SQL Server on Azure Virtual Machines requires manual management and does not provide native autoscaling, while Azure SQL Managed Instance and Azure SQL Edge have different use cases that do not focus on the same level of autoscaling as Azure SQL Database.