Home » Microsoft » 70-518 » Which technology should you use?
You are designing an application in the .net framework 4.0 The application is used mostly in a disconnected scenario. The application requires offline data from a Microsoft Sql Server 2008 database. When the application connects to the network, data will be modified and synchronized. You need to ensure that the application does not access the database server directly to synchronize data when online.
Which technology should you use?
A. WCF Data Service
B. Remote Data Acces
C. ADO.NET Sync Services
D. SQL Server Merge Replication
Correct Answer: C
Explanation/Reference:
ADO.NET Sync services also knowed as Microsoft Sync Framework.
Microsoft Sync Framework is a data synchronization platform from Microsoft that can be used to synchronize data across multiple data stores. Sync Framework includes a transport-agnostic architecture, into which data store-specific synchronization providers, modelled on the ADO.NET data provider API, can be plugged in. Sync Framework can be used for offline access to data, by working against a cached set of data and submitting the changes to a master database in a batch, as well as to synchronize changes to a data source across all consumers (publish/subscribe sync) and peer-to-peer synchronization of multiple data sources. Sync Framework features built-in capabilities for conflict detection – whether data to be changed has already been updated – and can flag them for manual inspection or use defined policies to try to resolve the conflict. Sync Services includes an embedded SQL Server Compact database to store metadata about the synchronization relationships as well as about each sync attempt. The Sync Framework API are surfaced both in managed code, for use with .NET Framework applications, as well as unmanaged code, for use with COM applications. It was scheduled to ship with Visual Studio 2008.