Which permission should you grant to User1?

You have a server named SQL1 that has Microsoft SQL Server 2016 installed. SQL1 contains a database named DB1. You need to ensure that a user named User1 can query dynamic management views to monitor DB1. The solution must minimize the number of permissions assigned to User1.
You create a login for User1.
Which permission should you grant to User1?
A. ALTER TRACE
B. VIEW SERVER STATE
C. VIEW DATABASE STATE
D. VIEW ANY DATABASE

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.