ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 121 - AZ-305 discussion

Report
Export

You have an app named App1 that uses two on-premises Microsoft SQL Server databases named DB1 and DB2. You plan to migrate DB1 and DB2 to Azure.

You need to recommend an Azure solution to host DB1 and DB2. The solution must meet the following requirements:

• Support server-side transactions across DB1 and DB2.

• Minimize administrative effort to update the solution.

What should you recommend?

A.
two SQL Server databases on an Azure virtual machine
Answers
A.
two SQL Server databases on an Azure virtual machine
B.
two Azure SQL databases on different Azure SQL Database servers
Answers
B.
two Azure SQL databases on different Azure SQL Database servers
C.
two Azure SQL databases in an elastic pool
Answers
C.
two Azure SQL databases in an elastic pool
D.
two Azure SQL databases on the same Azure SQL Database managed instance
Answers
D.
two Azure SQL databases on the same Azure SQL Database managed instance
Suggested answer: D

Explanation:

When both the database management system and client are under the same ownership (e.g. when SQL Server is deployed to a virtual machine), transactions are available and the lock duration can be controlled. Reference: https:// docs.particular.net/nservicebus/azure/understanding-transactionalityin- azure

asked 02/10/2024
Max Archer
38 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first