Register to Better Coder! It's free.
Enjoy the premium features and succeed at every job interview.
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
How can you send emails as a response to CosmosDB data changes?
Azure App serviceAzure CloudAzure Cosmos DB SeniorYou deciding between storing diagnostic data to Log Analytics Workspace or Azure Storage. What could be the factors that will affect the decision?
Azure CloudAzure Log Analytics WorkspaceAzure Storage SeniorYou have multiple SQL databases with varying usage patterns. You need to host them and allow the compute resources allocated to the database to scale dynamically. The solution needs to meet an SLA of 99.99% uptime and have reserved capacity. How would you solve the requirements?
Azure CloudAzure SQL Database SeniorHow do you configure host caching for data disk and log disk for your VM that hosts SQL Server in Azure?
Azure CloudAzure SQL DatabaseAzure Virtual Machines SeniorWhat is Azure Data Factory self-hosted integration runtime?
Azure CloudAzure Data Factory Senior