Administering Microsoft SQL Server 2012/2014 Databases — Question 42

You need to install SQL Server on a server. The server must meet the following requirements:
✑ Include SQL Server Integration Services (SSIS)
✑ Be able to run 32-bit SSIS legacy packages
You add the Integration Services shared feature to the installation.
Which other shared feature should you add to the installation?

Answer options

Correct answer: D

Explanation

The correct answer is D, SQL Server Data Tools, because it is necessary for developing and deploying SSIS packages, especially when dealing with legacy 32-bit packages. The other options do not provide the required features for running 32-bit SSIS legacy packages.