ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam
Go to Exam

Exam DP-300 topic 6 question 26 discussion

Actual exam question from Microsoft's DP-300
Question #: 26
Topic #: 6
[All DP-300 Questions]

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 the backup for Database1 from Server1 to the Server2 by using the RESTORE Transact-SQL command with the REPLACE option.
Does this meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by tordd at May 18, 2022, 1:50 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Ciupaz
Highly Voted 1 year, 6 months ago
Selected Answer: B
Correct answer is No.
upvoted 10 times
...
Icyb3r
Highly Voted 1 year, 7 months ago
It's Incorrect, the correct answer: B. No The first, and most important thing to notice here is that it’s supplying me with a new name. I can change that to anything I want as long as it’s not the name of a database already in existence on my Azure SQL Database Server. You read that correctly, you can restore a database to Azure SQL Database, but there is no WITH REPLACE option. The restore creates a new database. below ref link https://www.scarydba.com/2016/01/11/restoring-a-database-in-azure/
upvoted 6 times
...
lupdba
Most Recent 8 months, 1 week ago
Selected Answer: B
You cannot replace option in Azure SQL Database.
upvoted 2 times
...
Adamus2077
8 months, 2 weeks ago
Selected Answer: B
There is no REPLACE option in Azure SQL Database, or even there is no restore option with T-SQL. https://learn.microsoft.com/en-us/azure/azure-sql/database/recovery-using-backups?view=azuresql-db&tabs=azure-portal
upvoted 2 times
...
Ragnor619
9 months, 3 weeks ago
Selected Answer: A
With REPLACE option is possible
upvoted 1 times
...
Motanel
1 year ago
Selected Answer: B
Correct answer is No.
upvoted 2 times
...
Antonee
1 year ago
Selected Answer: B
Replace would only work in sql server, not in azure sql db/mi
upvoted 1 times
...
amazonalex
1 year ago
answer is NO. Replace would only work in sql server, not in azure sql db/mi
upvoted 1 times
...
KIET2131
1 year, 2 months ago
A 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://learn.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql?view=sql-server-ver16
upvoted 1 times
...
tordd
1 year, 11 months ago
is this correct?
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago