Exam AZ-304 topic 3 question 10 discussion

Correct https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview#azure-active-directory-integration

https://www.examtopics.com/exams/microsoft/az-303/view/2/ You need to implement Azure services to host DB1 and DB2. The solution must support server-side transactions across DB1 and DB2. Solution: You deploy DB1 and DB2 to SQL Server on an Azure virtual machine. Reference: https://docs.particular.net/nservicebus/azure/understanding-transactionality-in-azure

In AZ-305 exam, 9 april 22

I think C is correct

Distributed transactions for Azure SQL Managed Instance are now generally available. Elastic Database Transactions for Azure SQL Database are in preview. https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview

This is C Distributed transactions for Azure SQL Managed Instance are now generally available. Dec 2021 https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview#transact-sql-development-experience

According to this: https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview#transactions-for-sql-managed-instance for me Answer is C

"Minimize administrative effort to update " This is C; Managed Instance

Depends. If we assume Preview answers are allowed, then C, if not then D.

came in exam on 20-sep-21, I passed, i choose C

Answer is D....as other options are still under Preview.

Managed instance already supported server-side tractions https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview#transact-sql-development-experience

Both C and D support server-side transactions but C has a less administrative effort

Actually this should be a series of questions ... multiple answers are correct. See https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview

Answer is D

Answer is C: Managed Instances https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview Transact-SQL development experience "A server-side distributed transactions using Transact-SQL are available only for Azure SQL Managed Instance. Distributed transaction can be executed only between Managed Instances that belong to the same Server trust group. In this scenario, Managed Instances need to use linked server to reference each other." Don't confuse this with the AZ-303 questions like I did. The correct answer is managed instrances.

303 question, an the answer is D. "instead use virtual machine instance"