Which SQL Server 2012 component offers the capability to extract, transform, and load data from external sources?
A)Analysis Services
B)Reporting Services
C)Integration Services
D)Transformation Services

Question

Quizplus · Accepted Answer

Integration Services (SSIS) is a SQL Server 2012 component that provides the capability to extract, transform, and load (ETL) data from external sources. It includes tools to extract data from a variety of sources, transform the data through various operations, and load the transformed data into one or more destinations. SSIS also provides features for data profiling, data cleansing, and other data-related tasks. Analysis Services provides analytical capabilities and OLAP processing, while Reporting Services provides tools for creating and distributing reports. Transformation Services is not a valid SQL Server component.

Which SQL Server 2012 Component Offers the Capability to Extract