nerdexam
Microsoft

DP-300 · Question #442

Drag and Drop Question You have an on-premises server named Server1 that has Microsoft SQL Server 2022 installed. You have an Azure subscription that contains an Azure SQL managed instance named Ml1.

Sign in or unlock DP-300 to reveal the answer and full explanation for question #442. The question stem and answer options stay visible for context.

Submitted by tarun92· Mar 6, 2026Plan and implement data platform resources

Question

Drag and Drop Question You have an on-premises server named Server1 that has Microsoft SQL Server 2022 installed. You have an Azure subscription that contains an Azure SQL managed instance named Ml1. Ml1 contains a database named DB2. You need to create a copy of DB2 on Server1. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Answer:

Exhibit

DP-300 question #442 exhibit

Answer Area

Drag items

Back up DB2 to a file and use the COPY_ONLY option.Back up DB2 to a URL and use the COPY_ONLY option.Restore DB2 from the file and use the RESTORE WITH RECOVERY option.Create a credential on MI1.Create a credential on Server1.Restore DB2 from the URL and use the WITH MOVE option.

Unlock DP-300 to see the answer

You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Azure SQL Managed Instance#Database Backup#Database Restore#Data Migration
Full DP-300 Practice