How well do you know Azure SQL Data Sync - Part 1 - Powered by www.krishnacloud.school

Sync Schema

Sync Direction

Sync Interval

Conflict Resolution Policy

Sync metadata sync

Hub and spoke

Mesh

Point to Point

No , only SQL Azure database can be configured as Hub Database.

Yes , its possible to configure any type of database as Hub database including IaaS SQL Server.

Customer created and Customer owned.

Azure created and Customer Owned.

Azure Created and Azure Owned.

True

False

Hub to Member

Member to Hub

Sync can be configure as Hub to Member and Member to Hub

Changes are tracked using insert, update, and delete triggers.

Changes are tracked using stored procedures.

Changes are recorded in side table.

Changes are recorded in the main table with hidden columns.

Hub or Member wins

Both Hub and Member wins.

True

False