Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 6 question 24 discussion

Actual exam question from Microsoft's DP-300

Question #: 24
Topic #: 6

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 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.
Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: A 🗳️

by Meir at Aug. 16, 2020, 3:19 p.m.

Comments

Submit Cancel

JohnCrawford

Highly Voted 3 years, 11 months ago

As already noted, you cannot overwrite an existing database during an Azure SQL DB restore operation. In fact, you also cannot use REPLACE during the operation so the given answer is wrong. The correct answer is, yes, this meets the requirements. After having deleted the existing database you can set the restore operation to restore the database as any name you choose.

upvoted 33 times

...

IsmailShariff

Highly Voted 4 years, 1 month ago

Yes is the correct answer but answer is shown as No please correct it. Thanks

upvoted 15 times

...

duzee

Most Recent 1 year, 5 months ago

The solution described in the scenario does not meet the goal of replacing the existing Database1 on Server2 with the restored version from Server1. Deleting Database1 from Server2 and creating a new database using the backup of Database1 from Server1 would create a new database on Server2 with a different name. It would not replace the existing Database1 on Server2. To meet the goal of replacing the existing Database1 on Server2, you would need to restore the backup of Database1 from Server1 directly onto the existing Database1 on Server2 using the appropriate restore process, such as using the RESTORE DATABASE statement with the WITH REPLACE option or using Azure SQL Database Point-in-Time Restore functionality. Therefore, the correct answer is: B. No.

upvoted 1 times

...

cusman

2 years, 8 months ago

Selected Answer: A

Yes - Since Azure SQL DB RESTORE doesn't allow REPLACE, you would have to DROP before RESTORE.

upvoted 3 times

...

jerkyflexoff

3 years, 1 month ago

If you delete the database in SQL Azure you delete the backup.

upvoted 1 times

Dalamain

8 months ago

WRONG... if you delete the logical server it resided in then yes.

upvoted 1 times

...

learnazureportal

3 years, 4 months ago

The correct is Answer is "No".

upvoted 2 times

...

dhasu

3 years, 6 months ago

It should be YES

upvoted 2 times

...

dhasu

3 years, 7 months ago

It should be YES

upvoted 2 times

...

U_C

3 years, 8 months ago

The answer is Yes. Use Master go CREATE DATABASE MyAzuredemo_1 AS COPY OF myazuredemo12.MyAzureDemo (SERVICE_OBJECTIVE = 'S2') go

upvoted 3 times

U_C

3 years, 8 months ago

Or you can use PowerShell: $ResourceGroupName="MyResourceGroup" $sourceSQLServer="myazureDemo12" $SourceDatabaseName="MyAzureDemo" $CopyResourceGroupName="MyResourceGroup" $CopyDatabaseName="MyAzureDemo_2" az sql db copy --resource-group $ResourceGroupName --server $sourceSQLServer --name $SourceDatabaseName --dest-name $CopyDatabaseName

upvoted 1 times

U_C

3 years, 8 months ago

Note, the question says to restore from Azure Portal. If you log on Azure Portal, you can create a new database but you can NOT restore from a backup because there is no "Restore" option in Azure SQL Database no matter you use SSMS or Azure Data Studio. The approach is to export from source database and import into target database. I was wrong. The answer is correct, "No".

upvoted 3 times

U_C

3 years, 8 months ago

Please refer to https://docs.microsoft.com/en-us/azure/azure-sql/database/recovery-using-backups if you don't have Azure environment to check and verify.

upvoted 1 times

Aggie0702

3 years, 2 months ago

The link is for database recovery by using automated database backups, rather than the environment question referred

upvoted 2 times

...

Raffer

3 years, 8 months ago

The correct answer is "A". You *can* restore a database from a backup made in the *same region*, even if the backup is of a database on another server. In this scenario: 1. Delete the SERVER2 database (can't restore over the top of a database with the same name). 2. Restore the SERVER1 database onto SERVER2. https://docs.microsoft.com/en-us/azure/azure-sql/database/recovery-using-backups#geo-restore

upvoted 2 times

...

rtk513

3 years, 9 months ago

The only thing you need to do is restore the database and even though this isn't the best method, it will get the job done. Answer is A

upvoted 1 times

...

Corbiz

3 years, 10 months ago

Answer: No. You can only restore a database from a server to another if the database has been configured with geo-redundant backup storage. https://docs.microsoft.com/en-us/azure/azure-sql/database/recovery-using-backups

upvoted 1 times

Corbiz

3 years, 9 months ago

Sorry, answer is Yes. Azure SQL backups are geo-redundant by default.

upvoted 4 times

...

Geese_Howard

3 years, 10 months ago

Answer is A. Yes it satisfies the requirements. Also as everybody else said Azure SQL does not have replace option available.

upvoted 3 times

...

QiangQiang

3 years, 10 months ago

You can't overwrite an existing database during restore.

upvoted 2 times

...

MohsinBhai

4 years, 3 months ago

Sorry the Ans is Yes it will work, A is the correct option

upvoted 6 times

Andrea25

4 years, 3 months ago

You obviusly can delete the previous DB for replace with the new one... but this solution is not the "rapid" mode... instead you can restore the new db replacing the old, is more fast, only-in-one and one shot solution :)

upvoted 2 times

Frisco

4 years, 1 month ago

When restoring a database on Azure SQL DB you can't overwrite an existing DB. Delete + restore is the way to go (option A). Ref: https://docs.microsoft.com/en-us/azure/azure-sql/database/recovery-using-backups

upvoted 13 times

...

MohsinBhai

4 years, 3 months ago

The Correct answer is B, we have done this alot.

upvoted 1 times

...

Meir

4 years, 4 months ago

The answer is correct, but not the explanation. See https://www.mssqltips.com/sqlservertip/5189/restore-an-azure-sql-database-from-one-server-to-another-server/ for the correct process

upvoted 8 times

Aggie0702

3 years, 2 months ago

The approach this link referred to isn't the same as the explanation provided which is by using restore and replace command.

upvoted 1 times

...