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 1 question 33 discussion

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

HOTSPOT -
You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1.
You plan to perform an online migration of DB1 to an Azure SQL managed instance by using the Azure Database Migration Service.
You need to create a backup of DB1 that is accessible to the Azure Database Migration Service.
What should you run for the backup and where should you store the backup? 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: ..with CHECKSUM option -
Azure Database Migration Service does not initiate any backups, and instead uses existing backups, which you may already have as part of your disaster recovery plan, for the migration. Be sure that you take backups using the WITH CHECKSUM option.

Box 2: An SMB share -
For online migrations from SQL Server to SQL Managed Instance using Azure Database Migration Service, you must provide the full database backup and subsequent log backups in the SMB network share that the service can use to migrate your databases.
Reference:
https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-managed-instance-online
by valente_sven1 at Sept. 27, 2021, 8:59 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
nicolase
Highly Voted 3 years, 1 month ago
Answer is correct https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-managed-instance-online
upvoted 7 times
voodoo_sh
4 months, 4 weeks ago
Not agree. Run: Full and Log backups to separate files with CHECKSUM (correct) Store Backups in: Azure Blob Storage Why not Fireshare ? because when I select Network File Share in Azure DMS, it says: This scenario is currently disabled and requires a self-hosted integration runtime to access the migration source server and database backups.
upvoted 1 times
...
...
valente_sven1
Highly Voted 3 years, 7 months ago
Absolutely right. Files must be separate.
upvoted 7 times
...
bingomutant
Most Recent 7 months, 1 week ago
Blob storage is better answer , it is more seamless migration offering with DMS , whereas smb is total nightmare for this type of migration - possible , but way sub-optimal.Other comments below support this.
upvoted 6 times
...
igorclapa
1 year, 7 months ago
The local SMB network share or Azure file share that contains the full database backup files and transaction log backup files that Azure Database Migration Service can use for migration. The service account running the source SQL Server instance must have read\write privileges on this network share. Provide an FQDN or IP addresses of the server in the network share, for example, '\\servername.domainname.com\backupfolder' or '\\IP address\backupfolder'. For improved performance, it's recommended to use separate folder for each database to be migrated. You can provide the database level file share path by using the Advanced Settings option. https://learn.microsoft.com/en-us/azure/dms/tutorial-sql-server-managed-instance-online
upvoted 1 times
...
testdumps2017
1 year, 8 months ago
I will go with the Blob Storage Account, since I used it quite a number of times in past projects. As already quoted here, SMB share is a bit of an administrative nightmare - the integration runtime does not work quite well.
upvoted 6 times
...
Junindiaz
1 year, 9 months ago
Neste caso existem duas respostas possiveis?
upvoted 1 times
...
BrenFa101
2 years, 2 months ago
When doing an online migration to Managed Instance you can store the backups in blob storage without needing to have an SMB share and the integration runtime running. https://learn.microsoft.com/en-us/azure/dms/tutorial-sql-server-managed-instance-online-ads
upvoted 2 times
...
New_Azure_User
2 years, 9 months ago
Correct answer: Using Azure Database Migration Service, you must provide the full database backup and subsequent log backups in the SMB network share that the service can use to migrate your databases. Be sure that you take backups using the WITH CHECKSUM option
upvoted 4 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