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?
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.