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 80 discussion

Actual exam question from Microsoft's AZ-303
Question #: 80
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 an Azure SQL Database managed instance.
Does this meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide 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 rfox321 at May 31, 2021, 7 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
betamode
Highly Voted 3 years, 11 months ago
Answer should be YES as MS recently announced support for server side transactions for SQL Managed Instance. A server-side experience (code written in stored procedures or server-side scripts) using Transact-SQL is available for Managed Instance only. This is mentioned in following MS document as well - https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview
upvoted 39 times
lefty773
3 years, 11 months ago
Answer is B. Because "Distributed transactions across cloud databases" is a preview. Previews are not included in the exam.
upvoted 13 times
vaisat
3 years, 6 months ago
Distributed transactions for Azure SQL Managed Instance are now generally available. Elastic Database Transactions for Azure SQL Database are in preview. (as of 11/02/21). https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview
upvoted 8 times
...
...
rdemontis
3 years, 10 months ago
Yes you are right
upvoted 3 times
...
...
tp42
Highly Voted 3 years, 11 months ago
Should be "yes" as stated here A server-side distributed transactions using Transact-SQL are available only for Azure SQL Managed Instance https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview
upvoted 11 times
pentium75
3 years, 10 months ago
"Preview", thus does not apply to exam.
upvoted 4 times
...
...
seaman33
Most Recent 1 year, 4 months ago
Selected Answer: A
managed sql db can handle sst
upvoted 1 times
...
moon2351
3 years, 3 months ago
Answer is A
upvoted 1 times
...
az303ms
3 years, 3 months ago
Selected Answer: A
Its a Yes, b'cos MS announced managed sql db can handle sst
upvoted 1 times
...
nd78
3 years, 3 months ago
on Exam today 21st Jan, 2022
upvoted 1 times
...
plmmsg
3 years, 4 months ago
Answer is Yes. Server-side distributed transactions using Transact-SQL are available only for Azure SQL Managed Instance.
upvoted 1 times
...
therealss
3 years, 4 months ago
Looks like it's out of preview now for Azure SQL Managed Instance (dec. 27, 2021), so answer is probably A. "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
...
JBS
3 years, 5 months ago
Answer is B (NO) as in question DB1 ad DB2 are getting deplyed on Azure SQL Database managed instrance and for AZ SQL DB distributed transactions are still in preview.
upvoted 1 times
...
jnlhj
3 years, 8 months ago
Maybe "Azure SQL Database managed instance" is wrong should be "Azure SQL managed instance"? but not sure.
upvoted 2 times
...
ixl2pass
3 years, 8 months ago
YES A server-side distributed transactions using Transact-SQL are available only for Azure SQL Managed Instance reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview
upvoted 1 times
...
syu31svc
3 years, 8 months ago
https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview Yes it's in preview but it works right else why would Azure release it? Just my own logic and reasoning
upvoted 1 times
...
AAPaul
3 years, 10 months ago
I had this question in the exam that i took on July 14th 2021
upvoted 1 times
...
AAPaul
3 years, 10 months ago
A server-side experience (code written in stored procedures or server-side scripts) using Transact-SQL is available for Managed Instance only. https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview#transact-sql-development-experience?wt.mc_id=DP-MVP-4015656 So answer should be Yes.
upvoted 2 times
...
AAPaul
3 years, 10 months ago
A server-side experience (code written in stored procedures or server-side scripts) using Transact-SQL is available for Managed Instance only. https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview#transact-sql-development-experience?wt.mc_id=DP-MVP-4015656
upvoted 1 times
...
Matriks
3 years, 10 months ago
SQL Managed Instance support server-side transactions so the answer is YES
upvoted 1 times
...
nfett
3 years, 11 months ago
answer is A from https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview
upvoted 1 times
...
Load full discussion...
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