Microsoft
70-583 · Question #54
You are designing a strategy for synchronizing a SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign…
The correct answer is A. Use SQL Azure Data Sync Service. See the full explanation below for the reasoning.
Question
You are designing a strategy for synchronizing a SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships. You need to recommend an approach for ensuring that all changes in the remote databases synchronize with the SQL Azure database. What should you recommend?
Options
- AUse SQL Azure Data Sync Service.
- BUse SQL Server replication.
- CUse SQL Server backup and restore.
- DUse SQL Server database snapshots.
How the community answered
(63 responses)- A78% (49)
- B3% (2)
- C13% (8)
- D6% (4)
Community Discussion
No community discussion yet for this question.