What should you include in the recommendation?

You need to recommend a solution to meet the security requirements of the junior database administrators.

What should you include in the recommendation?
A . A server role
B . A database role
C . A credential
D . A shared login

View Answer

Answer: C

Explanation:

* Scenario: A group of junior database administrators must be able to view the server state of the SQL Server instance that hosts the Sales database. The junior database administrators will not have any other administrative rights.

* Credentials provide a way to allow SQL Server Authentication users to have an identity outside of SQL Server. Credentials can also be used when a SQL Server Authentication user needs access to a domain resource, such as a file location to store a backup.