Microsoft Azure Fundamentals (AZ-900)Describe Azure architecture and servicesMedium
A company is migrating its on-premises SQL Server databases to Azure. They require a fully managed relational database service that offers automatic patching, backups, and scalability without managing the underlying operating system or database engine software. Which Azure service should they choose?
- ASQL Server on Azure Virtual Machines
- BAzure SQL Database
- CAzure Synapse Analytics
- DAzure Cosmos DB
Show answer & explanationAnswer & explanation
Correct answer: B. Azure SQL Database
Azure SQL Database is a fully managed Platform-as-a-Service (PaaS) relational database service. It handles automatic patching, backups, and scalability, allowing users to focus solely on application development without managing the underlying infrastructure.
Why the other options are wrong
- A. SQL Server on Azure Virtual Machines is Infrastructure-as-a-Service (IaaS), requiring manual management of the OS and SQL Server.
- C. Azure Synapse Analytics is an analytics service, not a transactional relational database for general application use.
- D. Azure Cosmos DB is a NoSQL database service, not a relational database that would directly replace SQL Server with a fully managed relational equivalent.
Azure SQL Database
A fully managed relational database service in Azure, based on the Microsoft SQL Server engine.
- Platform-as-a-Service (PaaS) offering.
- Automatic patching, backups, and high availability.
- Scalable and secure.
Memory trick: SQL DB is the 'Easy Button' for SQL.