nerdexam
Microsoft

DP-300 · Question #20

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…

The correct answer is B. No. You can't overwrite an existing Azure SQL Database database during restore. Correct solution: From the Azure portal, you delete Database1 from Server2, and then you create a new database on Server2 by using the backup of Database1 from Server1…

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

Question

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 two Azure SQL Database servers named Server1 and Server2. Each server contains an Azure SQL database named Database1. You need to restore Database1 from Server1 to Server2. The solution must replace the existing Database1 on Server2. Solution: You restore Database1 from Server1 to the Server2 by using the RESTORE Transact- SQL command and the REPLACE option. Does this meet the goal?

Options

  • AYes
  • BNo

How the community answered

(61 responses)
  • A
    21% (13)
  • B
    79% (48)

Explanation

You can't overwrite an existing Azure SQL Database database during restore. Correct solution: From the Azure portal, you delete Database1 from Server2, and then you create a new database on Server2 by using the backup of Database1 from Server1. https://docs.microsoft.com/en-us/azure/azure-sql/database/recovery-using-backups

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice