70-448 · Question #136
You are creating a SQL Server 2008 Integration Services (SSIS) package which is created through utilizing local development environment for Company.com. You get data by package which inserts it in…
The correct answer is D. You should allot the users to a common database role in the MSDB database. See the full explanation below for the reasoning.
Question
You are creating a SQL Server 2008 Integration Services (SSIS) package which is created through utilizing local development environment for Company.com. You get data by package which inserts it in the PROD database on the local SQL Server 2008 instance from a remote server. You publish it to the MSDB database on the production server. Not only should you make users who belong to a proper database role change and run the deployed package. But also you should make sure that these users could not access other packages which are published to the server. Which is the correct answer?
Options
- AYou should allot the users to the db_system role.
- BYou should allot the users to the db_owner role.
- CYou should allot the users to a common database role in the default database.
- DYou should allot the users to a common database role in the MSDB database.
How the community answered
(26 responses)- A4% (1)
- B4% (1)
- C8% (2)
- D85% (22)
Community Discussion
No community discussion yet for this question.