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

Question Title

* 1. Select the consistency level offered by Azure SQL Data Sync

Eventual consistency

Transactional consistency

Strong consistency

Question Title

* 2. Identify the type of triggers used by Azure SQL Sync

Create

Update

Insert

Create

Question Title

* 3. Does Azure SQL data sync support XML types.

Yes

No

Question Title

* 4. You customers architecture requires datetime data type as primary key. Will Azure SQL datasync work in this scenario.

Datetime can be used as primary key for Azure data sync.

Datetime cannot be used as primary key for Azure data sync

Question Title

* 5. Each table must have a primary key

True

False

Question Title

* 6. You customer is looking to adopt Azure SQL Data sync for Disaster Recovery. What is your feedback.

Azure SQL Data sync is not suitable for Disaster Recovery

Azure provides SQL Database backups

Azure data sync is suitable for DR