exam questions

Exam 70-463 All Questions

View all questions & answers for the 70-463 exam

Exam 70-463 topic 2 question 42 discussion

Actual exam question from Microsoft's 70-463
Question #: 42
Topic #: 2
[All 70-463 Questions]

DRAG DROP -
A new dedicated server is used to execute resource-intensive SQL Server Integration Services (SSIS) 2012 packages. The environment that you are deploying the packages to has the following constraints:
✑ The operating system is Windows Server 2008 R2.
✑ The SSIS packages are stored in the SSIS catalog.
✑ Some of these SSIS packages use 32-bit custom components.
You need to install only the components that are required to deploy and run the packages on the new server.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
Note:
Step 1:
Step 2:
If you require 32-bit versions of the Integration Services runtime and tools to run certain packages in 32-bit mode, you must also install SQL Server Data Tools
(SSDT).
Note:
For a complete installation of IntegrationServices, together with the tools and documentation for developing and managing packages, select both Integration
Services and the following Shared Features:
✑ SQL Server Data Tools to install the tools for designing packages.
✑ Management Tools Complete to install SQL Server Management Studio for managing packages.
✑ Client Tools SDK to install managed assemblies for Integration Services programming.
Step 3: The SSIS packages are stored in the SSIS catalog. The catalog must be manually created.
References: https://msdn.microsoft.com/en-us/library/gg471508(v=sql.110).aspx

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Eras
4 years, 5 months ago
for 32 bit needs data tool
upvoted 1 times
...
mickeygeorge
4 years, 11 months ago
Is Sql server data tools needed?
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...