exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 1 question 6 discussion

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

HOTSPOT -
You have an on-premises Microsoft SQL Server 2016 server named Server1 that contains a database named DB1.
You need to perform an online migration of DB1 to an Azure SQL Database managed instance by using Azure Database Migration Service.
How should you configure the backup of DB1? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Full and log backups only
Make sure to take every backup on a separate backup media (backup files). Azure Database Migration Service doesn't support backups that are appended to a single backup file. Take full backup and log backups to separate backup files.

Box 2: WITH CHECKSUM -
Azure Database Migration Service uses the backup and restore method to migrate your on-premises databases to SQL Managed Instance. Azure Database
Migration Service only supports backups created using checksum.
Incorrect Answers:
NOINIT Indicates that the backup set is appended to the specified media set, preserving existing backup sets. If a media password is defined for the media set, the password must be supplied. NOINIT is the default.

UNLOAD -
Specifies that the tape is automatically rewound and unloaded when the backup is finished. UNLOAD is the default when a session begins.
Reference:
https://docs.microsoft.com/en-us/azure/dms/known-issues-azure-sql-db-managed-instance-online

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
sincerebb
3 weeks, 5 days ago
Backup type: Full backup only Backup option: WITH CHECKSUM
upvoted 1 times
...
bingomutant
7 months, 2 weeks ago
Given answer correct. For an online migration, DMS requires you to provide both a full backup and log backups to allow continuous synchronization and minimize downtime.
upvoted 1 times
...
Azure4Jahid
1 year, 2 months ago
I cannot see any option for taking backup in DMS. It's all about setting up project, setting up source and destination and finally start cutover and update the connection string. Where do you see the taking backups?
upvoted 1 times
...
Acrophat
2 years ago
According to the documentation "Take full, differential and log backups to separate backup files." as part of the requirements.
upvoted 3 times
...
alch50
2 years, 1 month ago
How can you make a full backup without logs, which are included automatically? The question is incorrect
upvoted 1 times
...
alch50
2 years, 2 months ago
Full backup only. Why do you need the log backup?
upvoted 1 times
...
KIET2131
2 years, 2 months ago
Backup type: Full backup only Backup option: WITH CHECKSUM
upvoted 3 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