Which SQL statement or statements should you use?

You are the lead database administrator (DBA) of a Microsoft SQL Server 2012 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 SQL statement or statements should you use? Choose all that apply.
A . CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION setupadmin;
B . ALTER SERVER ROLE [SpecialDBARole] ADD MEMBER [DOMAINJrDBAs];
C . CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION securityadmin;
D . GRANT VIEW DEFINITION TO [SpecialDBARole];
E . CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION serveradmin;
F . GRANT VIEW SERVER STATE, VIEW ANY DATABASE TO [SpecialDBARole];

Answer: B, C, F

Latest 70-462 Dumps Valid Version with 301 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments