Which two SQL Server components should you use?

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.)

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.
Reporting Services

B.
Integration Services

C.
Notification Services

D.
Microsoft Sync Framework

E.
Analysis Services



Leave a Reply 0

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