Administering Microsoft SQL Server 2012/2014 Databases — Question 20

You want to remove SQL Server Integration Services from a server running the Windows Server 2008 R2 operating system that also has the Database Engine and SQL Server Analysis Services installed.
Which of the following tools can you use to accomplish this goal?

Answer options

Correct answer: D

Explanation

The correct tool to uninstall SQL Server Integration Services is the SQL Server Installation Center, which provides the necessary options for modifying or removing SQL Server components. The other options, such as SQL Server Management Studio and SQL Server Configuration Manager, do not offer uninstallation capabilities, and while Add/Remove Programs in Control Panel can manage installations, it is not the recommended method for SQL Server components.