DP-300 Question #376: Real Exam Question with Answer & Explanation

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:

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.

Full DP-300 Practice Browse All DP-300 Questions