Microsoft
70-448 · Question #1
70-448 Question #1: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #1. The question stem and answer options stay visible for context.
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.
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.