You have installed the SQL Server Integration Services (SSIS) feature on a server running Windows
Server 2008 R2 SP1.
Which of the following features must you install if you want to ensure that you can run packages in
32-bit mode?
A.
Client Tools SDK
B.
Data Quality Client
C.
SQL Server Data Tools
D.
Client Tools Backwards Compatibility
A. Incorrect: The Client Tools SDK includes the software development kit that has
resources for programmers. It does not allow you to run SSIS packages in 32-bit
mode on a computer running a 64-bit operating system.
B. Incorrect: The Data Quality Client allows you to perform data quality operations
against Data Quality Server. You can’t use this feature to run SSIS packages in
32-bit mode on a computer running a 64-bit operating system.
C. Correct: Installing the SQL Server Data Tools shared feature allows you to run SSIS
packages in 32-bit mode on a computer running a 64-bit operating system.
58 CHAPTER 1 Planning and Installing SQL Server 2012
D. Incorrect: Client Tools Backwards Compatibility enables backward compatibility
for packages created in previous versions of the product but does not enable you
to run SSIS packages in 32-bit mode on a computer running a 64-bit operating
system.
C