Microsoft
70-465 · Question #77
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
Sign in or unlock 70-465 to reveal the answer and full explanation for question #77. The question stem and answer options stay visible for context.
Submitted by krish.m· Mar 5, 2026Design database security solutions
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.
Unlock 70-465 to see the answer
You've previewed enough free 70-465 questions. Unlock 70-465 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#SQL Server security#Server roles#Least privilege