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