MENU
You have two on-premises servers that run Windows Server 2019 and host a Microsoft SQL Server 2017 Always On availability group named AG1. AG1 contains a single database named DB1.
You have an Azure subscription. The subscription contains a virtual machine named VM1 that runs Linux.
You need to migrate DB1 to a SQL Server 2019 instance on VM1. The solution must minimize the downtime of DB1 during the migration.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Suggested Answer: A
Get Premium DP-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
14 comments · newest first
ZA
Zack
11 months ago
Just make sure to check compatibility issues first!
CI
Ciara
11 months ago
I think using backup and restore would work too.
LE
Leota
12 months ago
Wait, can you really migrate from SQL Server 2017 to 2019 like that?
EL
Elin
12 months ago
Totally agree, it's the best way to minimize downtime.
RA
Raelene
1 year ago
You can use the Data Migration Assistant for this!
TY
Tyra
1 year ago
I believe we should consider using Azure Database Migration Service, but I’m not confident about the specifics of the configuration.
GL
Glory
1 year ago
I remember something about using transactional replication for minimizing downtime, but I can't recall the exact steps.
JO
Josue
1 year ago
This reminds me of a practice question where we had to use backup and restore methods, but I feel like there’s a more efficient way to do this.
LA
Lai
1 year ago
I think we might need to use the Data Migration Assistant to assess compatibility first, but I'm not entirely sure.
WE
Weldon
1 year ago
I'm not too familiar with DANE, but the description of it verifying the integrity of name information retrieved via DNS sounds like the most relevant option to me. I'll select A and hope for the best!
KA
Kattie
1 year ago
I feel pretty confident that grep -i ''yellow'' is the correct choice because it's specifically for matching patterns in text files without case sensitivity.
KR
Kristofer
1 year ago
Tags seemed optional in some examples we went over, but the other fields definitely were not allowed to be empty.
JA
Janna
1 year ago
Hmm, I'm not sure about the difference between incidents and service requests. I'll have to think this through carefully.
WI
Wilburn
1 year ago
I'm confident the answer is B. Firebase Authentication is the service that handles user authentication, including storing user account information like email and password.