Exam 70-462 topic 3 question 23 discussion

Actual exam question from Microsoft's 70-462

Question #: 23
Topic #: 3

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

Show Suggested Answer

Suggested Answer: D 🗳️
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

by corpo at July 22, 2020, 12:28 a.m.

Comments

Submit Cancel

corpo

4 years, 10 months ago

SQL Server Data Tools (SSDT) is a modern development tool for building SQL Server relational databases, Azure SQL Databases, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports

upvoted 2 times

...