You are a database solutions architect. Your company plans to develop a solution by using a SQL Server 2008 instance. The solution has the following business requirements: + Import data from various data sources such as Microsoft Office Excel, Microsoft SQL Server 2000, Microsoft SQL Server 2005, and CSV files.
+ Profile the source data before it is imported.
+ Provide collaboration and offline capabilities to mobile users.
+ Allow mobile users to use heterogeneous data stores.
You need to configure the appropriate SQL Server components to accomplish the business requirements. You want to achieve this goal by using the minimum amount of administrative effort. Which two SQL Server components should you use? (Each correct answer presents part of the solution. Choose two.)
A.
Analysis Services
B.
Reporting Services
C.
Integration Services
D.
Notification Services
E.
Microsoft Sync Framework
Explanation:
Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions. You use Integration Services to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data. The packages can work alone or in concert with other packages to address complex business needs. Integration Services can extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations.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.