70-450 · Question #16
You administer a SQL Server 2008 instance for your company. Your company has a team of database administrators. A team of application developers create SQL Server 2008 Integration Services (SSIS)…
The correct answer is B. Create a deployment utility for the SSIS project. This is a strange question. The underlying lesson is that deployment utilities make SSIS package deployment easier, especially in situations where limited access may be available. Direct and indirect package configurations are explained on MSDN.
Question
You administer a SQL Server 2008 instance for your company. Your company has a team of database administrators. A team of application developers create SQL Server 2008 Integration Services (SSIS) packages on the test server in a shared project. One of the packages requires a fixed cache file. On completion of development, the packages will be deployed to the production server. Only the database administrators can access the production server. You need to ensure that the application developers can deploy the project successfully to the production server. What should you do?
Options
- AUse the Import and Export Wizard to save packages.
- BCreate a deployment utility for the SSIS project.
- CCreate a direct package configuration for each package.
- DCreate an indirect package configuration for all packages.
How the community answered
(31 responses)- A3% (1)
- B84% (26)
- C10% (3)
- D3% (1)
Explanation
This is a strange question. The underlying lesson is that deployment utilities make SSIS package deployment easier, especially in situations where limited access may be available. Direct and indirect package configurations are explained on MSDN.
Topics
Community Discussion
No community discussion yet for this question.