A SaaS vendor hosts several customer databases on one Azure SQL Managed Instance. One business operation must update an order in one database and an inventory row in another as a single transaction, rolling back fully if either write fails. What should the architect rely on?
Show answer and explanation
Answer: D
Azure SQL Managed Instance supports transactions that span multiple databases on the same instance, using standard SQL Server semantics. An update to two databases can therefore commit or roll back together. Always Encrypted protects column contents from the administrator but does not make multi-database writes atomic. Database Mail sends messages, and SQL Server Agent runs scheduled jobs. Neither coordinates atomic updates across databases.
Why the other options are wrong
- A. Always Encrypted protects sensitive column values from unauthorized readers. It does not make writes to two databases atomic.
- B. Database Mail sends email messages from the instance. It has no role in transaction coordination or rollback across databases.
- C. SQL Server Agent schedules and runs jobs. A job that runs every minute does not provide atomic commit or rollback across two databases.