Microsoft
70-459 · Question #118
70-459 Question #118: Real Exam Question with Answer & Explanation
The correct answer is B. ALTER SERVER ROLE [SpecialDBARole] ADD MEMBER [DOMAIN\JrDBAs]; C. CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION securityadmin; F. GRANT VIEW SERVER STATE, VIEW ANY DATABASE TO [SpecialDBARole];. See the full explanation below for the reasoning.
Question
You are the lead database administrator (DBA) of a Microsoft SQL Server 2012 environment. All DBAs are members of the DOMAIN\JrDBAs Active Directory group. You grant DOMAIN\JrDBAs 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 DOMAIN\JrDBAs 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.
Options
- ACREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION setupadmin;
- BALTER SERVER ROLE [SpecialDBARole] ADD MEMBER [DOMAIN\JrDBAs];
- CCREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION securityadmin;
- DGRANT VIEW DEFINITION TO [SpecialDBARole];
- ECREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION serveradmin;
- FGRANT VIEW SERVER STATE, VIEW ANY DATABASE TO [SpecialDBARole];
Community Discussion
No community discussion yet for this question.