MCQOPTIONS
Saved Bookmarks
| 1. |
You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package on a development server named ABCDB03. The SSIS package obtains data that will be inserted in a database named CKProducts from a remote SQL Server 2008 database server named TESKING-DB01. The data is published to the MSDB database on a production server named ABC-DB02. You should make sure that only users belonging to the appropriate database role are able to change and run the package. What should you do? |
| A. | You should assign the users to the db_system role. |
| B. | You should assign the users to a pre-defined security role. |
| C. | You should assign the users to a common database role in the default database. |
| D. | You should assign the users to a common database role in the MSDB database. |
| Answer» E. | |