nerdexam
Microsoft

DP-300 · Question #376

Drag and Drop Question 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…

The correct answer is Deploy an Azure SQL database.; Create a sync group.; Install and configure the Client Sync Agent app on SQL1 and SQL2.; Sync the metadata database configuration.; Configure the sync group. SQL Data Sync requires an Azure SQL Database (not a Managed Instance) to act as the hub database that coordinates synchronization. The correct sequence is: first deploy an Azure SQL Database as the hub, then create a sync group associated with that hub, install and configure…

Submitted by dimitri_ru· Mar 6, 2026Implement and manage data synchronization using Azure SQL Data Sync - typically covered under 'Deploy and Manage Azure SQL' or 'Implement a Relational Database in Azure' in certifications such as DP-300 (Azure Database Administrator Associate).

Question

Drag and Drop Question 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. Answer:

Exhibit

DP-300 question #376 exhibit

Answer Area

Drag items

Deploy an Azure SQL database.Deploy an Azure SQL managed instance.Create a sync group.Configure the sync group.Sync the metadata database configuration.Install and configure the Client Sync Agent app on SQL1 and SQL2.

Correct arrangement

  • Deploy an Azure SQL database.
  • Create a sync group.
  • Install and configure the Client Sync Agent app on SQL1 and SQL2.
  • Sync the metadata database configuration.
  • Configure the sync group.

Explanation

SQL Data Sync requires an Azure SQL Database (not a Managed Instance) to act as the hub database that coordinates synchronization. The correct sequence is: first deploy an Azure SQL Database as the hub, then create a sync group associated with that hub, install and configure the Client Sync Agent on the on-premises SQL Server instances (SQL1 and SQL2) to enable connectivity, sync the metadata database configuration so the agent registers the on-premises databases with the sync group, and finally configure the sync group to define which tables and columns to sync, along with sync direction and frequency. This order ensures prerequisites are in place before each dependent step.

Topics

#SQL Data Sync#Azure SQL Database#Hybrid Connectivity#Data Synchronization

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-300 Practice