PrepAway - Latest Free Exam Questions & Answers

You need to configure a login to support the deployment of the new application

ou plan to deploy a new application. The application will perform the following operations: •
Create a new database • Back up the new database 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?

PrepAway - Latest Free Exam Questions & Answers

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.


Leave a Reply