Microsoft DP-300 Exam - Topic 5 Question 12 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 12
Topic #: 5

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?

AYes

BNo

Show Suggested Answer

Suggested Answer: A

The REPLACE option overrides several important safety checks that restore normally performs. The overridden checks are as follows:

Restoring over an existing database with a backup taken of another database.

With the REPLACE option, restore allows you to overwrite an existing database with whatever database is in the backup set, even if the specified database name differs from the database name recorded in the backup set. This can result in accidentally overwriting a database by a different database.

https://docs.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql

by Emerson at May 07, 2022, 04:45 PM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Barrett

4 months ago

Definitely meets the goal, just make sure to check permissions!

upvoted 0 times

...

Roselle

4 months ago

Wait, can you really use RESTORE with REPLACE for cross-server? Sounds risky!

upvoted 0 times

...

Sharee

4 months ago

Pretty sure you can’t restore across servers like that.

upvoted 0 times

...

Dalene

5 months ago

I don’t think that’s correct. REPLACE might not work as expected.

upvoted 0 times

...

Terina

5 months ago

Yes, that’s the right way to do it!

upvoted 0 times

...

Ramonita

5 months ago

I believe the answer is yes, but I might be mixing up the commands. I need to double-check if RESTORE works the same way in Azure as it does in SQL Server.

upvoted 0 times

...

Elbert

5 months ago

I’m a bit confused; I thought Azure had different methods for restoring databases. Is RESTORE even applicable here?

upvoted 0 times

...

Jovita

5 months ago

I remember practicing a similar question, and I feel like the REPLACE option is meant for on-premises SQL Server, not Azure.

upvoted 0 times

...

Jerlene

5 months ago

I think using the RESTORE command with the REPLACE option should work, but I'm not entirely sure if it applies to Azure SQL databases.

upvoted 0 times

...

Shawnda

5 months ago

Hmm, this seems like a tricky one. I'll need to think through the different options carefully.

upvoted 0 times

...

Vincent

5 months ago

Okay, I've got this. PolarDB supports multiple engines, so the answer must be True. I'm confident in this one.

upvoted 0 times

...

Louvenia

5 months ago

I think the ability to drag and drop camera feeds is a feature that makes the Meraki MV Dashboard user-friendly, but I can't remember if it's the main key feature.

upvoted 0 times

...

Eleni

5 months ago

Option C seems like a good starting point to me. Combining the location and car type features into a single feature cross could help the model capture the interactions we're looking for.

upvoted 0 times

...