Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-300 Exam - Topic 1 Question 70 Discussion

You need to recommend a disaster recovery solution for an on-premises Microsoft SQL Server database. The solution must meet the following requirements:* Support real-time data replication to a different geographic region.* Use Azure as a disaster recovery target.* Minimize costs and administrative effort.What should you include in the recommendation?
D) transactional replication to an Azure SQL Managed Instance
A) database mirroring on an instance of SQL Server on Azure Virtual Machines
B) availability groups for SQL Server on Azure Virtual Machines
C) an Azure SQL Managed Instance link

Microsoft DP-300 Exam - Topic 1 Question 70 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 70
Topic #: 1
[All DP-300 Questions]

You need to recommend a disaster recovery solution for an on-premises Microsoft SQL Server database. The solution must meet the following requirements:

* Support real-time data replication to a different geographic region.

* Use Azure as a disaster recovery target.

* Minimize costs and administrative effort.

What should you include in the recommendation?

Show Suggested Answer Hide Answer
Suggested Answer: D

by Lisha at Mar 25, 2023, 05:36 PM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Renato
10 months ago
Transactional replication is solid, but can be tricky to set up.
upvoted 0 times
...
Verlene
10 months ago
Availability groups are great for real-time replication.
upvoted 0 times
...
Portia
11 months ago
Isn't database mirroring outdated? Surprised it's still an option!
upvoted 0 times
...
Melodie
11 months ago
I disagree, option D seems more cost-effective.
upvoted 0 times
...
Hailey
11 months ago
I think option B is the best choice for high availability.
upvoted 0 times
...
Karan
11 months ago
I practiced a similar question about disaster recovery, and I think Azure SQL Managed Instance might be the best choice for minimizing costs and admin work.
upvoted 0 times
...
Jody
11 months ago
I feel like database mirroring was mentioned as a potential solution, but I can't recall if it supports the geographic replication we need.
upvoted 0 times
...
Maryln
11 months ago
I think transactional replication could be a good option since it supports real-time data, but I need to double-check if it meets all the criteria.
upvoted 0 times
...
Emerson
11 months ago
I remember we discussed availability groups in class, but I'm not sure if they fit the cost and effort requirements.
upvoted 0 times
...
Lyda
11 months ago
The key here is assessing the risk of harm to the guests. Zoe should carefully evaluate the situation and take appropriate action based on that assessment, rather than just defaulting to a full notification.
upvoted 0 times
...
Temeka
11 months ago
The chunked response option seems like the most likely culprit here. I'll make sure to double-check that during the exam.
upvoted 0 times
...
Lawanda
12 months ago
This is a tricky one. I'm not entirely sure about the proper way to use the REVOKE statement in this case. I'll need to review my notes and maybe even look up some examples to make sure I understand the correct syntax before selecting an answer.
upvoted 0 times
...
Ciara
12 months ago
Hmm, I'm a bit unsure about the specific properties needed to request an access token. I'll need to review my notes on the Microsoft identity platform.
upvoted 0 times
...

Save Cancel