Microsoft
70-458 · Question #136
70-458 Question #136: Real Exam Question with Answer & Explanation
Sign in or unlock 70-458 to reveal the answer and full explanation for question #136. The question stem and answer options stay visible for context.
Question
You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model. The project is deployed to a single SSIS catalog, and transfers data to and from multiple databases hosted on SQL Server. The project must be configured to be able to export data to and from five different production servers that run SQL Server 2012. Each target server requires different values for connection strings and parameters in the SSIS project. You need to meet the requirements by using the least amount of administrative effort. What should you do?
Options
- AFor each target server, create separate Environments in the SSIS catalog of the host
- BCreate one registry configuration. Add a connection string for each target server.
- CCreate one XML configuration file. Add a connection string for each target server.
- DFor each target server, create a separate package and include each package in the
Unlock 70-458 to see the answer
You've previewed enough free 70-458 questions. Unlock 70-458 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.