AZ-305 Question 62
Single answerA financial services company wants to migrate its on-premises SQL Server databases to Azure. They rely on cross-database queries, extended T-SQL stored procedures, and need near 100% SQL Server compatibility with minimal infrastructure management overhead. Which Azure service should you recommend for deploying their relational data?
- A
Azure SQL Database (Single Database)
- B
Azure SQL Managed Instance
- C
Azure Database for MySQL
- D
Azure Synapse Analytics (dedicated SQL pool)
Show answer and explanation
Correct answer: B
Explanation
For applications that require maximum SQL Server compatibility, including cross-database queries, extended stored procedures, and T-SQL features, Azure SQL Managed Instance is generally the recommended choice. According to Microsoft’s documentation, Azure SQL Managed Instance provides full SQL Server surface area compatibility in a fully managed environment, making it ideal for seamless migrations of existing SQL Server workloads without extensive refactoring.
- A. Incorrect.
Azure SQL Database (Single Database) supports most T-SQL features, but certain advanced features like cross-database queries may not be fully supported. Additionally, it provides a slightly different level of compatibility compared to full SQL Server.
- B. Correct.
Azure SQL Managed Instance offers near 100% compatibility with on-premises SQL Server, including support for cross-database transactions and advanced T-SQL features, while minimizing infrastructure management overhead. This makes it the best fit for the scenario.
- C. Incorrect.
Azure Database for MySQL is a relational database service but uses MySQL engine features and syntax, not T-SQL. It’s not suitable for SQL Server workloads that need advanced T-SQL and cross-database queries.
- D. Incorrect.
Azure Synapse Analytics (dedicated SQL pool) is mainly designed for large-scale analytical workloads rather than transactional or operational databases. It isn’t intended to support advanced SQL Server transactional features with near 100% compatibility.