MENU
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?
Suggested Answer: D
Get Premium DP-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
13 comments · newest first
RE
Renato
11 months ago
Transactional replication is solid, but can be tricky to set up.
VE
Verlene
11 months ago
Availability groups are great for real-time replication.
PO
Portia
12 months ago
Isn't database mirroring outdated? Surprised it's still an option!
ME
Melodie
12 months ago
I disagree, option D seems more cost-effective.
HA
Hailey
12 months ago
I think option B is the best choice for high availability.
KA
Karan
1 year 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.
JO
Jody
1 year 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.
MA
Maryln
1 year 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.
EM
Emerson
1 year ago
I remember we discussed availability groups in class, but I'm not sure if they fit the cost and effort requirements.
LY
Lyda
1 year 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.
TE
Temeka
1 year ago
The chunked response option seems like the most likely culprit here. I'll make sure to double-check that during the exam.
LA
Lawanda
1 year 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.
CI
Ciara
1 year 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.