Microsoft
70-448 · Question #136
70-448 Question #136: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #136. The question stem and answer options stay visible for context.
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.
Unlock 70-448 to see the answer
You've previewed enough free 70-448 questions. Unlock 70-448 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.