Microsoft
70-451 · Question #100
You 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…
The correct answer is C. Add the login to the dbcreator server role. See the full explanation below for the reasoning.
Question
You 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?
Options
- AAdd the login to the sysadmin server role.
- BAdd the login to the diskadmin and secuntyadmin server roles.
- CAdd the login to the dbcreator server role.
- DAdd the login to the diskadmin and serveradmin server roles.
How the community answered
(23 responses)- A4% (1)
- B13% (3)
- C78% (18)
- D4% (1)
Community Discussion
No community discussion yet for this question.