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

Exam AZ-303 All Questions

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

Exam AZ-303 topic 1 question 28 discussion

Actual exam question from Microsoft's AZ-303
Question #: 28
Topic #: 1
[All AZ-303 Questions]

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 to SQL Server on an Azure virtual machine.
Does this meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
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 Shukai2020 at Dec. 3, 2020, 5:32 a.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
TEMPKAKAM
Highly Voted 4 years, 6 months ago
The provided answer is correct
upvoted 18 times
...
aut0pil0t
Highly Voted 4 years ago
Answer A is correct While server-side transactions are available for Azure SQL Managed Instances via Server Trust Groups as in https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview, it only has partial support as in https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/transact-sql-tsql-differences-sql-server#distributed-transactions. So, the answer A for using SQL server on Azure VMs is correct considering the supportability. Microsoft's wording needs to be different on the docs as I feel. When they say "A server-side distributed transactions using Transact-SQL are available only for Azure SQL Managed Instance", they should mention that it is available only for Azure SQL Managed Instance with other Azure SQL products and features and full SQL Server on Azure VMs are not concerned.
upvoted 8 times
...
sandeepmalik
Most Recent 3 years, 2 months ago
In today's exam. Score 900+ Correct answer.
upvoted 1 times
...
tomatosis
3 years, 5 months ago
On exam 23 Dec 2021, I chose B. The correct answer is SQL managed instance and this was confirmed with my trainer before the exam.
upvoted 2 times
...
edmacoar123
3 years, 6 months ago
On exam today 19/11/21. Score 860.
upvoted 2 times
...
Koshi202
3 years, 7 months ago
also managed instance supports across db transation
upvoted 1 times
...
plmmsg
3 years, 9 months ago
Yes. the answer is correct
upvoted 1 times
...
syu31svc
3 years, 9 months ago
SQL Server on Azure VM has full SQL features and coverage so answer is Yes
upvoted 2 times
...
kkstays
3 years, 10 months ago
9th Aug 21 - Was in today's exam. 54 Questions in total (4 Case study), No Lab
upvoted 3 times
...
VMUN
3 years, 11 months ago
26-June-21, Passed the exam. Answered - Yes
upvoted 4 times
...
Samshr
3 years, 11 months ago
Answer is A. 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. repeated question #66
upvoted 3 times
...
gbabes
4 years ago
According to: https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview "A server-side distributed transactions using Transact-SQL are available only for Azure SQL Managed Instance." so PaaS rather than IaaS, which would be answer B
upvoted 2 times
tita_tovenaar
3 years, 11 months ago
you are right IF you want to use TransactSql. The same article also says:” the ability to coordinate distributed transactions has now been directly integrated into SQL Database or Managed Instance” so answer is A (yes)
upvoted 3 times
...
...
nfett
4 years ago
why is this A. the provided url doesnt really answer this. They are referring to databases and not client/server transactions in the question.
upvoted 1 times
...
skr123
4 years, 2 months ago
correct answer - came in exam last week
upvoted 1 times
...
AWS56
4 years, 5 months ago
Answer : B Explanation: 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
upvoted 1 times
Aghora
4 years, 4 months ago
Why B? you provided same explanation for A, why B ?
upvoted 3 times
...
...
Shukai2020
4 years, 6 months ago
correct aws
upvoted 2 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