70-463 Question #146: Real Exam Question with Answer & Explanation

Question

Options

• ASet the Sensitive property of the parameter to True.
• BEdit each package Connection Manager.
• CEdit the project Connection Manager in Solution Explorer.
• DCreate a project parameter named ServerName.
• ECreate a package parameter named ServerName in each package.
• FSet the Required property of the parameter to True.

Explanation

C: From Question: " The server name for the database must be set by using a parameter named ServerParam when any package in the project is executed." D: SSIS 2012 has introduced the concept of Project level connection managers. An SSIS project is generally more than one package. To simplify lives, the SSIS team now allows for the sharing of common resources across projects, connection managers being one of those F: When a parameter is marked as required, a server value or execution value must be specified for that parameter. Otherwise, the corresponding package does not execute. Although the parameter has a default value at design time, it will never be used once the project is deployed. - Integration Services (SSIS) parameters allow you to assign values to properties within packages at the time of package execution. You can create project parameters at the project level and package parameters at the package Project parameters are used to supply any external input the project receives to one or more packages in the project. Package parameters allow you to modify package execution without having to edit and redeploy the package.

No community discussion yet for this question.