YOU HAVE A TEAM MEMBER WHO NEEDS THE ABILITY TO MANAGE SQL SERVER L...

4. You have a team member who needs the ability to manage SQL Server logins

and you do not want them to have permissions to perform any task on the

server. Their responsibilities include resetting logins as well as granting,

denying, and revoking database-level and server-level permissions. Which of

the following server-level roles best fits their permissions requirement?

A. Serveradmin

B. Sysadmin

C. Securityadmin

D. Processadmin