Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Azure Solutions Architect Expert · Microsoft
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
A server-side experience (code written in stored procedures or server-side scripts) using Transact-SQL is available for SQL Managed Instance only. https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview?view=azuresql
I believe that currently it is still the B, but it is true that currently the Elastic Query is in preview and may soon make more sense to the A. https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-query-overview?view=azuresql
B. Two databases on the same Azure SQL managed instance Reasoning: Support server-side transactions: Azure SQL Managed Instance supports distributed transactions across multiple databases, meeting the requirement for server-side transactions. Minimize administrative effort: Managed instances provide a managed environment with automatic patching, backups, and high availability, reducing the administrative effort compared to managing SQL Server on virtual machines or separate databases on different servers.