Microsoft
DP-300 · Question #84
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 A. Yes. This procedure is necessary and correct, as there is no option in Azure SQL Database to directly restore a database. https://docs.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql
Submitted by marco_it· Mar 6, 2026Design and implement data storage
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: From Microsoft SQL Server Management Studio (SSMS), you rename Database1 on Server2 as Database2. From the Azure portal, you create a new database on Server2 by restoring the backup of Database1 from Server1, and then you delete Database2. Does this meet the goal?
Options
- AYes
- BNo
How the community answered
(31 responses)- A74% (23)
- B26% (8)
Explanation
This procedure is necessary and correct, as there is no option in Azure SQL Database to directly restore a database. https://docs.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql
Topics
#Azure SQL backup#database restore#cross-server restore#disaster recovery
Community Discussion
No community discussion yet for this question.