Exam AZ-303 All Questions

View all questions & answers for the AZ-303 exam

Exam AZ-303 topic 1 question 66 discussion

Actual exam question from Microsoft's AZ-303

Question #: 66
Topic #: 1

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an app named App1 that uses data from two on-premises Microsoft SQL Server databases named DB1 and DB2.
You plan to move DB1 and DB2 to Azure.
You need to implement Azure services to host DB1 and DB2. The solution must support server-side transactions across DB1 and DB2.
Solution: You deploy DB1 and DB2 as Azure SQL databases each on a different Azure SQL Database server.
Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️
Instead deploy DB1 and DB2 to SQL Server on an Azure virtual machine.
Note: Understanding distributed transactions.
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-transactionality-in-azure

by gcpjay at Dec. 11, 2020, 2:21 p.m.

Comments

Submit Cancel

Ramkid

Highly Voted 4 years, 5 months ago

Transactions are supported when the DBs are hosted on the same sql server. So, both the DBs needs to be hosted on the same SQL server

upvoted 22 times

...

skr123

Highly Voted 4 years, 2 months ago

was in exam last week.

upvoted 11 times

...

sandeepmalik

Most Recent 3 years, 2 months ago

In today's exam. Score 900+ Correct answer.

upvoted 3 times

...

KemalM

3 years, 3 months ago

Selected Answer: B

answer is correct

upvoted 1 times

...

moon2351

3 years, 4 months ago

Selected Answer: B

Answer is B

upvoted 1 times

...

nd78

3 years, 4 months ago

on Exam today 21st Jan, 2022

upvoted 1 times

...

ChrisG1454

3 years, 5 months ago

Distributed transactions across cloud databases (preview) Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview

upvoted 1 times

...

tomatosis

3 years, 5 months ago

On exam 23 Dec 2021, the correct answer should be SQL managed instance as it was confirmed with my trainer

upvoted 1 times

...

edmacoar123

3 years, 6 months ago

On exam today 19/11/21. Correct answer. Score 860.

upvoted 3 times

...

RKSBBSR

3 years, 7 months ago

Answer is NO. Distributed transactions for Azure SQL Managed Instance are now generally available. Elastic Database Transactions for Azure SQL Database are in preview. https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview

upvoted 1 times

...

syu31svc

3 years, 9 months ago

"support server-side transactions" -> this would mean on the same server Answer is No

upvoted 3 times

...

BPQ

3 years, 10 months ago

https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison. see Cross-database transactions. Answer is No

upvoted 2 times

...

AAPaul

3 years, 11 months ago

I had this question in the exam that i took on July 14th 2021

upvoted 2 times

...

rdemontis

3 years, 11 months ago

Server side transactions are supported either for Azure SQL Databases in one Server or in multiple servers. The same for Sql MI. So the answer should be Yes https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview

upvoted 1 times

...