Microsoft
70-451 · Question #4
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…
The correct answer is B. Add the login to the dbcreator and securityadmin server roles. 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
- 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?
Options
- AAdd the login to the sysadmin server role.
- BAdd the login to the dbcreator and securityadmin server roles.
- CAdd the login to the diskadmin and securityadmin server roles.
- DAdd the login to the diskadmin and serveradmin server roles.
How the community answered
(16 responses)- A6% (1)
- B88% (14)
- D6% (1)
Community Discussion
No community discussion yet for this question.