Administering a SQL Database Infrastructure — Question 126

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?

Answer options

• A. Database Engine
• B. SQL Server Reporting Services
• C. SQL Server Analysis Services
• D. Client Tools SDK

Correct answer: A

Explanation

The Database Engine is essential for executing the SSIS packages as it provides the necessary data storage and processing capabilities. The other options, such as SQL Server Reporting Services and SQL Server Analysis Services, are not required for running SSIS packages, and the Client Tools SDK is primarily for development purposes rather than execution.