Exit 70-451 PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008
Question 3 of 5
0% complete
Q3 Single choice

You plan to deploy a new application. The application will perform the following operations:

You need to configure a login to support the deployment of the new application. The solution must ensure that the application uses the most restrictive permissions possible.

What should you do?

  • A

    Add the login to the sysadmin server role.

  • B

    Add the login to the diskadmin and secuntyadmin server roles. After the database is created, add a user to the db_backupoperator database role.

  • C

    Add the login to the dbcreator server role.

  • D

    Add the login to the diskadmin and serveradmin server roles. After the database is created, add a user to the db_backupoperator database role.

Previous Next