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 Reporting Services
C.
SQL Server Analysis Services
D.
Client Tools SDK
A. Correct: Integration Services stores packages in an instance of the Database
Engine and uses SQL Server Agent for scheduling those packages. If you do not
have a local instance of the Database Engine, SSIS packages will run on the server
on which they were started.
B. Incorrect: SSRS is not required to run SSIS packages locally on an ETL server that
has SSIS installed. You must install a local instance of the Database Engine to run
SSIS packages locally.
C. Incorrect: SSAS is not required to run SSIS packages locally on an ETL server that
has SSIS installed. You must install a local instance of the Database Engine to run
SSIS packages locally.
D. Incorrect: The Client Tools SDK is not required to run SSIS packages locally on an
ETL server that has SSIS installed. You must install a local instance of the Database
Engine to run SSIS packages locally
A