What should you recommend?

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?

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?

A.
Use SQL Azure Data Sync Service.

B.
Use SQL Server replication.

C.
Use SQL Server backup and restore.

D.
Use SQL Server database snapshots.



Leave a Reply 0

Your email address will not be published. Required fields are marked *