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 73 discussion

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

DRAG DROP
-

You have two on-premises Microsoft SQL Server instances named SQL1 and SQL2.

You have an Azure subscription.

You need to sync a subset of tables between the databases hosted on SQL1 and SQL2 by using SQL Data Sync.

Which five actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Show Suggested Answer Hide Answer
Suggested Answer:
by Mtour at Oct. 17, 2024, 6:42 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
voodoo_sh
6 months, 3 weeks ago
Agree with below steps - tested myself: 1. Deploy and Azure SQL database 2. Create a sync group 3. Install and configure the Client Sync Agent app on SQL1 and SQL2 4. Sync the metadata database configuration 5. Configure the sync group
upvoted 1 times
...
2f5c7cd
7 months, 3 weeks ago
https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-sql-server-configure?view=azuresql 1. Deploy and Azure SQL database 2. Create a sync group 3. Install and configure the Client Sync Agent app on SQL1 and SQL2 4. Sync the metadata database configuration 5. Configure the sync group
upvoted 1 times
...
Mtour
7 months, 3 weeks ago
To sync the tables between on-premises Microsoft SQL Server instances using Azure SQL Data Sync, the correct order of actions is: Deploy an Azure SQL database - This is necessary as the Azure SQL database acts as the hub database for synchronization. Create a sync group - This will define the synchronization topology, which includes the hub and member databases. Configure the sync group - Set up the parameters for the sync group, including the sync direction and the specific tables or columns to sync. Install and configure the Client Sync Agent app on SQL1 and SQL2 - The Client Sync Agent enables on-premises SQL Servers to sync with Azure. Sync the metadata database configuration - This completes the sync configuration by syncing the metadata that describes the sync relationships. This sequence ensures that the necessary components are set up for Azure SQL Data Sync.
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