Microsoft Exam Questions

You are planning on deploying a server that will be dedicated for ETL (Extraction, Transformation, a

You are planning on deploying a server that will be dedicated for ETL (Extraction, Transformation, and Loading) processes.

You want to ensure that SSIS (SQL Server Integration Services)

packages will run on this dedicated ETL server and not on any other server on which they were started.

Which of the following features must you install on the ETL server in addition to SSIS to accomplish this goal?

A. Database Engine

B. SQL Server Report

ing Services

C. SQL Server Analysis Services

D. Client Tools SDK