Microsoft Azure Data FundamentalsDescribe how to work with relational data on AzureMedium
A company is migrating its legacy on-premises SQL Server databases to Azure. The databases contain complex stored procedures, triggers, and SQL Agent jobs that are critical for business operations. The company needs full SQL Server engine compatibility and administrative control. Which Azure relational data service is the most suitable choice?
- AAzure SQL Managed Instance (PaaS)
- BAzure SQL Database (PaaS)
- CAzure Synapse Analytics Dedicated SQL Pool (PaaS)
- DAzure Database for MySQL (PaaS)
Show answer & explanationAnswer & explanation
Correct answer: A. Azure SQL Managed Instance (PaaS)
Azure SQL Managed Instance offers near 100% compatibility with the latest SQL Server (on-premises) database engine, providing full SQL Server features, administrative control, and lift-and-shift capability for existing applications.
Why the other options are wrong
- B. Azure SQL Database is a fully managed PaaS SQL Server, but it has some compatibility differences and does not support SQL Agent jobs directly.
- C. Azure Synapse Analytics Dedicated SQL Pool is a data warehousing solution, not designed for transactional SQL Server workloads with complex features like SQL Agent jobs.
- D. Azure Database for MySQL is for MySQL workloads and not compatible with SQL Server features like stored procedures and SQL Agent jobs.
Azure SQL Managed Instance
Azure SQL Managed Instance is a fully managed, intelligent, scalable cloud database service that provides the broadest SQL Server engine compatibility.
- Near 100% compatibility with SQL Server (on-premises).
- Supports SQL Agent, CLR, cross-database queries.
- Lift-and-shift existing SQL Server applications to Azure.
Memory trick: Managed Instance: SQL Server's cloud twin.