Exam AZ-303 All Questions

View all questions & answers for the AZ-303 exam

Exam AZ-303 topic 1 question 67 discussion

Actual exam question from Microsoft's AZ-303

Question #: 67
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 on the same 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 naneguptha at Jan. 4, 2021, 12:32 p.m.

Comments

Submit Cancel

Hunter4life

Highly Voted 4 years, 5 months ago

Answer should be "No". Reason being: "Elastic database transactions enable applications to make atomic changes to data stored in several different databases. The preview focuses on client-side development experiences in C# and .NET. A server-side experience (code written in stored procedures or server-side scripts) using Transact-SQL is available for Managed Instance only." Server-side is currently only supported in SQL MI.

upvoted 28 times

Nicodebian

4 years, 4 months ago

Agree with Hunter4life, the key here is : Server-side is currently only supported in SQL MI

upvoted 3 times

...

naneguptha

Highly Voted 4 years, 5 months ago

Answer is Yes. w.r.t question 67.

upvoted 13 times

AWS56

4 years, 5 months ago

Agree, the answer is YES "A"

upvoted 3 times

...

rxlicon

Most Recent 1 year, 10 months ago

Server-side is currently only supported in SQL MI.

upvoted 1 times

...

sachinp2305

3 years, 3 months ago

Correct Answer - Appeared in today's exam 29 March 2022,

upvoted 1 times

...

sandeepmalik

3 years, 3 months ago

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

upvoted 1 times

...

AngelDevart

3 years, 4 months ago

If we ignore that the Support for Server-Side transactions in Azure SQL DB is currently on preview, the answer is No, but you can use it already.

upvoted 1 times

...

nd78

3 years, 5 months ago

on Exam today 21st Jan, 2022

upvoted 1 times

...

Uppal

3 years, 5 months ago

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

upvoted 1 times

...

MayilKannan

3 years, 6 months ago

Answer should be "No". Server side is supported only in Managed Instances. https://docs.microsoft.com/en-us/answers/questions/379123/sql-server-side-transaction-on-azure-sql-database.html

upvoted 1 times

...

HarryZ

3 years, 6 months ago

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. https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview So, the answer should be yes

upvoted 2 times

...

edmacoar123

3 years, 7 months ago

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

upvoted 4 times

...

syu31svc

3 years, 10 months ago

Answer is No Managed Instance only https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview

upvoted 5 times

...

kannban

3 years, 11 months ago

I think the answer is still "No" . The article below that others have pasted mentions this "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." Question is not referencing MI instance

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

tita_tovenaar

3 years, 11 months ago

I don't get it. In your reference it is stated four times that "A server-side experience (code written in stored procedures or server-side scripts) using Transact-SQL is available for Managed Instance only." Unless there are other ways than Transact (which I haven't found) then answer is NO

upvoted 3 times

...

VMUN

4 years ago

26-June-21, Passed the exam. Answered - NO

upvoted 3 times

...

exampass999

4 years ago

Answer: YES

upvoted 1 times

...

Load full discussion...