exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 3 question 62 discussion

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

HOTSPOT
-

You have an Azure virtual machine named Server1 that has Microsoft SQL Server installed. Server1 contains a database named DB1.

You have a logical SQL server named ASVR1 that contains an Azure SQL database named ADB1.

You plan to use SQL Data Sync to migrate DB1 from Server1 to ASVR1.

You need to prepare the environment for the migration. The solution must ensure that the connection from Server1 to ADB1 does NOT use a public endpoint.

What should you do? 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
voodoo_sh
5 months, 1 week ago
https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-data-sql-server-sql-database?view=azuresql Private link for Data Sync The SQL Data Sync private link is different from the Azure Private Link. The new private link feature allows you to choose a service managed private endpoint to establish a secure connection between the sync service and your member/hub databases during the data synchronization process. A service managed private endpoint is a private IP address within a specific virtual network and subnet. Within Data Sync, the service managed private endpoint is created by Microsoft and is exclusively used by the Data Sync service for a given sync operation. Snapshot isolation must be enabled for both Sync members and hub. For more info, see Snapshot Isolation in SQL Server.
upvoted 1 times
...
2f5c7cd
6 months, 1 week ago
SQL Data Sync private link and SNAPSHOT ISOLATION
upvoted 1 times
...
bingomutant
6 months, 2 weeks ago
agree with given answer - Azure Private Link allows private connectivity to Azure services from within a private virtual network without exposing your data to the public internet, which aligns with the requirement of avoiding public endpoints - and Snapshot Isolation helps in minimizing locking issues and ensures that the data reads during the migration are consistent without blocking operations. This isolation level is well-suited for data synchronization tasks, as it prevents long locks on tables during the sync operation, enhancing performance and concurrency
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