exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 6 question 51 discussion

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

HOTSPOT
-

You have an Azure subscription that contains a storage account named databasebackups.

You have an Azure SQL managed instance named DB1.

You need to back up DB1 to databasebackups.

How should you complete the commands? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:

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
bingomutant
6 months, 4 weeks ago
Answer correct - SAS and COPY-ONLY. In Azure SQL Managed Instances, the COPY_ONLY option is required because the service manages the regular backup chain. The COPY_ONLY backup ensures that the backup chain is not interrupted or affected, which is essential for Azure SQL Managed Instance. So, the correct completion of the command should prioritize COPY_ONLY to meet the requirements of the managed instance environment.
upvoted 1 times
...
sca88
1 year ago
The answer is correct https://techcommunity.microsoft.com/t5/azure-sql-blog/native-database-backup-in-azure-sql-managed-instance/ba-p/386154 The only mandatory property is COPY_ONLY. Azure SQL Managed Instance owns the backup chain. This means that you cannot perform database backup that breaks the backup chain. Azure SQL Managed Instance allows you to perform only COPY_ONLY backups.
upvoted 3 times
...
Dalamain
1 year ago
Going with COMPRESSION because according to best practices it can save on costs: https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server-backup-to-url-best-practices-and-troubleshooting?view=sql-server-ver16#manage-backups
upvoted 1 times
...
Pulsejetdragster
1 year, 2 months ago
SAS makes sense, can anyone confirm that back would be to the url with "COPY_ONLY"? I am still searching for the correct answer, but I feel that it could be with CHECKSUM
upvoted 1 times
drgr123
1 year, 2 months ago
Keyword for checksum would be for online migration
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago