70-465 Question #77: Real Exam Question with Answer & Explanation

Question

You need to provide a group of users from the IT and Manufacturing departments the minimum administrative rights to view database information and server state for the Manufacturing database on MainDB1. What should you do?

Options

• AYou should configure a Database Role.
• BYou should configure a Server Role.
• CYou should configure a Shared SQL Server Login.
• DYou should configure a Local Security Group.

Explanation

To provide a group of users with minimum administrative rights to view server state and database information for the Manufacturing database on MainDB1, you should configure a Server Role.

Common mistakes.

• A. Database roles grant permissions only within a specific database and cannot be used to view server-level information like 'server state'.
• C. A Shared SQL Server Login is an authentication principal, an identity for connecting to SQL Server, not a mechanism for assigning permissions or administrative rights.
• D. A Local Security Group is an operating system construct and does not directly grant permissions within SQL Server; while Windows groups can be mapped to SQL Server logins, configuring the group itself doesn't assign SQL Server permissions.

Concept tested. SQL Server server-level permissions and roles

Reference. https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/server-level-roles

No community discussion yet for this question.