Which three SQL statements should you use?

Posted by: Pdfprep Category: 70-462 Tags: , ,

You are the lead database administrator (DBA) of a Microsoft SQL Server environment.

All DBAs are members of the DOMAINJrDBAs Active Directory group. You grant DOMAINJrDBAs access to the SQL Server.

You need to create a server role named SpecialDBARole that can perform the following functions:

– View all databases.

– View the server state.

– Assign GRANT, DENY, and REVOKE permissions on logins.

You need to add DOMAINJrDBAs to the server role. You also need to provide the least level of privileges necessary.

Which three SQL statements should you use? Each correct answer presents part of the solution.
A . GRANT VIEW ANY DATABASE TO [SpecialDBARole];
B . GRANT VIEW SERVER STATE, VIEW ANY DATABASE TO [SpecialDBARole];
C . CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION securityadmin;
D . CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION sysadmin;
E . ALTER SERVER ROLE [SpecialDBARole] ADD MEMBER [DOMAINJrDBAs];
F . CREATE SERVER ROLE [SpecialDBARole];

Answer: B,C,E

Leave a Reply

Your email address will not be published.