70-448 · Question #1
You design a package by using SQL Server 2008 Integration Services (SSIS). The package is designed by using your local development environment. The package extracts data from a remote server and…
The correct answer is D. Assign the users to a custom database role in the MSDB database. See the full explanation below for the reasoning.
Question
You design a package by using SQL Server 2008 Integration Services (SSIS). The package is designed by using your local development environment. The package extracts data from a remote server and inserts it in the PROD database on the local SQL Server 2008 instance. You deploy the package to the MSDB database on the production server. You need to ensure that only users that belong to an appropriate database role can modify and execute the deployed package. You also need to ensure that these users cannot access other packages that are deployed to the server. What should you do?
Options
- AAssign the users to the db_ssisoperator role.
- BAssign the users to the db_ssisltduser role.
- CAssign the users to a custom database role in the PROD database.
- DAssign the users to a custom database role in the MSDB database.
How the community answered
(46 responses)- A7% (3)
- B17% (8)
- C4% (2)
- D72% (33)
Community Discussion
No community discussion yet for this question.