Microsoft
70-467 · Question #17
70-467 Question #17: Real Exam Question with Answer & Explanation
Sign in or unlock 70-467 to reveal the answer and full explanation for question #17. The question stem and answer options stay visible for context.
Question
You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS project that includes several SSIS packages. Each SSIS package will define the same connection managers and variables. You have the following requirements: - Ensure that the deployment model supports changing the content of connection strings by using parameters at execution time. - Ensure that the deployment model automatically starts from calls to the catalog.start_execution stored procedure in the SSISDB database. - Maximize performance at execution time. - Minimize development effort. You need to design a solution that meets the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Options
- AUse a project deployment model.
- BUse a project deployment model.
- CUse a package deployment model.
- DUse a package deployment model.
Unlock 70-467 to see the answer
You've previewed enough free 70-467 questions. Unlock 70-467 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.