DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ30

Plan and implement data platform resources

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

You have an Azure subscription.

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

Which five actions should you carry out, in sequence?

Drag & Drop
Explanation

SQL Data Sync uses an Azure SQL Database as the hub when synchronizing on-premises SQL Server databases. Creating the sync group establishes the metadata database and enables agent registration. The Client Sync Agent is required for on-premises members; it is then connected to the sync metadata database by using the agent key. After the members are registered, configure the group’s sync schema to select the tables to synchronize. Azure SQL Managed Instance is unsupported.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!