Module 2 - Relational Database Services in Azure

Question 1

Overview of Azure SQL

Answer 1

It’s a collection of Microsoft SQL Services in Azure.
- SQL Server on Azure Virtual Machines
- Azure SQL Managed Instance
- Azure SQL Database
- Azure SQL Edge

Question 2

SQL Server on Azure Virtual Machines (Azure SQL Services)

Answer 2

• Type of cloud service: IaaS
• SQL Server compatibility: Fully compatible on-premises physical and virtualized installations
• Architecture: SQL Server instances are installed in a virtual machine
• Management: You must manage all aspects of the server

Question 3

Azure SQL Managed Instance (Azure SQL Services)

Answer 3

• Type of cloud service: PaaS
• SQL Server compatibility: Near 100% compatible with SQL Server to Migrate on premises DB using Azure Database Migration service
• Architecture: Each managed instance can support multiple databases.
• Management: Fully automated updates, backups and recovery

Question 4

Azure SQL Database (Azure SQL Services)

Answer 4

• Type of cloud service: PaaS
• SQL Server compatibility: Supports most SQL Server capabilities. Some features depend on an on-premises application.
• Architecture: Dedicated, managed server. Elastic pool to share resources.
• Management: Fully automated updates, backups and recovery