Microsoft Azure Data FundamentalsDescribe how to work with relational data on AzureEasy
A company is designing a new application that requires a highly scalable relational database service in Azure. The application needs to support automatic patching, backups, and high availability with minimal administrative overhead. Which Azure relational data service should the company choose?
- ASQL Server on Azure Virtual Machines
- BAzure SQL Database
- CAzure SQL Database Managed Instance
- DAzure Synapse Analytics
Show answer & explanationAnswer & explanation
Correct answer: B. Azure SQL Database
Azure SQL Database is a fully managed Platform-as-a-Service (PaaS) offering that provides automatic patching, backups, and high availability. It requires minimal administrative overhead, aligning with the company's needs for a highly scalable relational database.
Why the other options are wrong
- A. SQL Server on Azure Virtual Machines is Infrastructure-as-a-Service (IaaS) and requires significant administrative overhead for patching, backups, and high availability.
- C. Managed Instance offers more SQL Server compatibility but still requires more management than Azure SQL Database.
- D. Azure Synapse Analytics is primarily for data warehousing and analytics, not for transactional relational databases in a typical application.
Azure SQL Database (PaaS)
A fully managed relational database service in Azure that provides built-in high availability, automatic backups, and patching.
- Platform-as-a-Service (PaaS)
- Minimal administrative overhead
- High scalability and availability
Memory trick: SQL choices: Managed, PaaS, IaaS, Data Warehouse.