You need to use transactions between multiple SQL databases. What database option will you use to support the transactions?
Experience Level: Senior
Tags: Azure CloudAzure SQL DatabaseAzure Virtual Machines
Answer
A safe bet would be to use Azure VM with SQL server installed that will host both database.
There is also an option to use elastic database transactions for Azure SQL Database and Azure SQL Managed Instance, but this feature is in preview.
Related Azure Cloud job interview questions
According to Microsoft Cloud Adoption Framework (CAF), what are the three specific terms related to Management phaze that can help improve conversations among business stakeholders?
Microsoft Cloud Adoption Framework (CAF) JuniorWhat are 6 key steps for establishing a management baseline according to Microsoft Cloud Adoption Framework (CAF)?
Microsoft Cloud Adoption Framework (CAF) JuniorWhat is management baseline according to Microsoft Cloud Adoption Framework (CAF)?
Microsoft Cloud Adoption Framework (CAF) JuniorWhat are the 5 disciplines of cloud governance according to Microsoft Cloud Adoption Framework (CAF)?
Microsoft Cloud Adoption Framework (CAF) JuniorIs Cloud Security Posture Management (CSPM) available for all Azure Subscriptions?
Microsoft Defender Junior