Which other shared feature should you add to the installation?

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?
A . Master Data Services (MDS)
B . Client Tools Connectivity
C . Management Tools – Complete
D . SQL Server Data Tools

View Answer

Answer: D

Explanation:

SQL Server Data Tools (SSDT) provides project templates and design surfaces for building SQL Server content types ― relational databases, Analysis Services models, Reporting Services reports, and Integration Services packages.

SSDT is backwards compatible, so you can always use the newest SSDT to design and deploy databases, models, reports, and packages that run on older versions of SQL Server.

References: https://docs.microsoft.com/en-us/sql/ssdt/previous-releases-of-sql-server-data-tools­ssdt-and-ssdt-bi?view=sql-server-2017