You plan to deploy a new application. The application will perform the following operations:
·Create a new database ·Add new logins ·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 diskadmin and serveradmin server roles. Once the database is
created, add a user to the db_backupoperator database role.
B.
Add the login to the sysadmin server role.
C.
Add the login to the dbcreator and securityadmin server roles.
D.
Add the login to the diskadmin and securityadmin server roles. Once the database is
created, add a user to the db_backupoperator database role.