ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam
Go to Exam

Exam AZ-305 topic 2 question 15 discussion

Actual exam question from Microsoft's AZ-305
Question #: 15
Topic #: 2
[All AZ-305 Questions]

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 Azure SQL databases in an elastic pool
  • B. two databases on the same Azure SQL managed instance
  • C. two databases on the same SQL Server instance on an Azure virtual machine
  • D. two Azure SQL databases on different Azure SQL Database servers
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by Gowind at Sept. 2, 2022, 2:56 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Gowind
Highly Voted 2 years, 6 months ago
Selected Answer: B
https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview?view=azuresql 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.
upvoted 24 times
...
NotMeAnyWay
Highly Voted 1 year, 11 months ago
Selected Answer: B
B. two databases on the same Azure SQL managed instance An Azure SQL Managed Instance is a fully managed SQL Server Database Engine hosted in Azure that provides most of the SQL Server capabilities. It supports features like cross-database queries and transactions, which is crucial for your requirement of supporting server-side transactions across DB1 and DB2. Additionally, since it's a fully managed solution, it minimizes the administrative effort needed to update and maintain the system.
upvoted 16 times
...
yyandrakk
Most Recent 2 months ago
Selected Answer: B
I believe that currently it is still the B, but it is true that currently the Elastic Query is in preview and may soon make more sense to the A. https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-query-overview?view=azuresql
upvoted 2 times
...
[Removed]
3 months, 3 weeks ago
Selected Answer: B
B is correct
upvoted 2 times
...
23169fd
8 months, 2 weeks ago
Selected Answer: B
B. Two databases on the same Azure SQL managed instance Reasoning: Support server-side transactions: Azure SQL Managed Instance supports distributed transactions across multiple databases, meeting the requirement for server-side transactions. Minimize administrative effort: Managed instances provide a managed environment with automatic patching, backups, and high availability, reducing the administrative effort compared to managing SQL Server on virtual machines or separate databases on different servers.
upvoted 3 times
23169fd
8 months, 2 weeks ago
why other options are not suitable: A. Two Azure SQL databases in an elastic pool: Reason: Elastic pools are designed for cost efficiency and managing multiple databases with varying resource demands, but they do not support distributed transactions across databases. C. Two databases on the same SQL Server instance on an Azure virtual machine: Reason: While this setup supports distributed transactions, it requires significant administrative effort to manage the virtual machine, including patching, backups, and high availability. D. Two Azure SQL databases on different Azure SQL Database servers: Reason: This setup does not support distributed transactions across different servers and increases administrative complexity.
upvoted 3 times
...
...
Lazylinux
10 months, 1 week ago
Selected Answer: B
The Given answer B is correct - The keyword is server-side transaction execution across multiple dbs. it's one of the key features of SQL managed instance. However Client-side transaction execution is feature of both SQL MI and AZ SQL DB
upvoted 1 times
...
zellck
2 years ago
Selected Answer: B
B is the answer. https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview?view=azuresql#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 instances that belong to the same Server trust group. In this scenario, managed instances need to use linked server to reference each other.
upvoted 4 times
...
totalz
2 years ago
B is the best answer no doubt, but D is also a correct answer according to the doc. See limitations 1st point! This doc is missing a lot of things...
upvoted 1 times
...
OPT_001122
2 years, 1 month ago
Selected Answer: B
B. two databases on the same Azure SQL managed instance
upvoted 1 times
...
Bummer_boy
2 years, 1 month ago
Selected Answer: B
The thing is server-side transaction execution across multiple dbs. it's one of the key features of SQL managed instance.
upvoted 2 times
...
mscbgslt
2 years, 2 months ago
12/29/2022 -> This article describes using elastic database transactions which allow you to run distributed transactions across cloud databases for Azure SQL Database and Azure SQL Managed Instance.
upvoted 7 times
OPT_001122
2 years, 1 month ago
Thanks for mentioning the date
upvoted 1 times
...
...
Samko635
2 years, 4 months ago
Selected Answer: B
Azure SQL DB does NOT support server-side transaction, only client-side. Ref: https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview?view=azuresql#common-scenarios
upvoted 4 times
...
jellybiscuit
2 years, 5 months ago
Selected Answer: B
Elastic query for Azure SQL Databases is currently in preview mode, which would allow this. For now, SQL MI is the right answer though.
upvoted 2 times
Samko635
2 years, 4 months ago
Azure SQL DB does NOT support server-side transaction, only client-side. Ref: https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview?view=azuresql#common-scenarios
upvoted 1 times
xRiot007
1 year ago
You posted the docs, but did you actually read them? Seems not. Let's do it together: "A server-side experience (code written in stored procedures or server-side scripts) using Transact-SQL is available for SQL Managed Instance only" And then it continues telling you that you can either have transactions between DB or DB MIs like this: "Running elastic database transactions between Azure SQL Database and Azure SQL Managed Instance is not supported. Elastic database transaction can only span across a set of databases in SQL Database or a set databases across managed instances."
upvoted 1 times
...
...
...
most_lenyora
2 years, 6 months ago
Correct
upvoted 2 times
...
Snownoodles
2 years, 6 months ago
Selected Answer: B
Given answer is correct. Keywords: instance to instance/minimal management
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago