Exam AZ-300 topic 5 question 11 discussion

Actual exam question from Microsoft's AZ-300

Question #: 11
Topic #: 5

You are developing an app that references data which is sharded across multiple Azure SQL databases.
The app must guarantee transactional consistency for changes across several different sharding key values.
You need to manage the transactions.
What should you implement?

A. Elastic database transactions with horizontal partitioning.
B. Distributed transactions coordinated by Microsoft Distributed Transaction Coordinator (MSDTC).
C. Server-coordinated transactions from .NET application.
D. Elastic database transactions with vertical partitioning.

Show Suggested Answer

Suggested Answer: A 🗳️
References:
https://docs.microsoft.com/mt-mt/azure/sql-database/sql-database-elastic-transactions-overview?view=azurermps-6.13.0

by Famous_Guy at April 18, 2020, 4:37 p.m.

Comments

Submit Cancel

Nikita_1998

Highly Voted 4 years, 11 months ago

Elastic database transactions for SQL Database also support coordinating distributed transactions where you use the OpenConnectionForKey method of the elastic database client library to open connections for a "scaled out" data tier. Consider cases where you need to guarantee transactional consistency for changes across several different sharding key values. Horizontal scaling refers to adding or removing databases in order to adjust capacity or overall performance, also called "scaling out". So given answer is correct

upvoted 5 times

...