Microsoft DP-300 Exam - Topic 10 Question 13 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 13
Topic #: 10

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 run the Remove-AzSqlDatabase PowerShell cmdlet for Database1 on Server2. You run the Restore-AzSqlDatabase PowerShell cmdlet for Database1 on Server2.

Does this meet the goal?

AYes

BNo

Show Suggested Answer

Suggested Answer: B

Instead restore Database1 from Server1 to the Server2 by using the RESTORE Transact-SQL command and the REPLACE option.

Note: REPLACE should be used rarely and only after careful consideration. Restore normally prevents accidentally overwriting a database with a different database. If the database specified in a RESTORE statement already exists on the current server and the specified database family GUID differs from the database family GUID recorded in the backup set, the database is not restored. This is an important safeguard.

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

by Reena at May 05, 2022, 08:05 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Andra

4 months ago

Agreed, using PowerShell for this is spot on!

upvoted 0 times

...

Vallie

4 months ago

Wait, can you really restore like that? Sounds risky!

upvoted 0 times

...

Robt

4 months ago

You definitely need to remove the old database first.

upvoted 0 times

...

Leonida

5 months ago

I think it’s a bit more complicated than that.

upvoted 0 times

...

Marleen

5 months ago

Yes, that’s the right approach!

upvoted 0 times

...

Detra

5 months ago

I believe the restore command should work, but I’m not confident if removing the database is necessary for this scenario.

upvoted 0 times

...

Micaela

5 months ago

I’m a bit confused about the cmdlets. Does Remove-AzSqlDatabase actually delete the database before restoring?

upvoted 0 times

...

Janae

5 months ago

I remember a practice question where we had to restore a database, and I feel like we didn't need to remove it first.

upvoted 0 times

...

Aliza

5 months ago

I think using Remove-AzSqlDatabase first makes sense, but I'm not sure if that's the right order for restoring.

upvoted 0 times

...

Leonor

5 months ago

Hmm, I'm a bit unsure about this one. The SQL query is using the LIKE operator, but the MongoDB options don't seem to have an exact equivalent. I'll have to think this through carefully.

upvoted 0 times

...

Danica

5 months ago

Easy, the answer is B. Social engineering is the biggest threat to basic security questions. Attackers can use all kinds of tricks to get that info.

upvoted 0 times

...

Gracie

5 months ago

I'm pretty certain that we have to use "monitor session" as the base command, but the specific arguments are a bit fuzzy to me right now.

upvoted 0 times

...

Jeannetta

5 months ago

Data cleanup? I'm not sure I follow the logic there. Wouldn't that just be a prerequisite for building the schedule, not the biggest challenge itself? I'm leaning towards random demand as the answer.

upvoted 0 times

...

Tiara

5 months ago

Definitely Feedback. The confirmation message is a clear way to let the user know their action was successful, which is a core principle of good user interface design.

upvoted 0 times

...

Jose

5 months ago

If I recall correctly, liabilities need to be provided for when it's probable we will lose, but I'm not completely sure about recognizing the asset at the same time.

upvoted 0 times

...

Anastacia

5 months ago

Availability seems crucial. For an e-commerce site, being down even briefly could mean massive revenue loss. That's why cloud service might be better.

upvoted 0 times

...