Valid 70-462 Dumps shared by ExamDiscuss.com for Helping Passing 70-462 Exam! ExamDiscuss.com now offer the newest 70-462 exam dumps, the ExamDiscuss.com 70-462 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-462 dumps with Test Engine here:
You are the lead database administrator (DBA) of a Microsoft SQL Server 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 three SQL statements should you use? Each correct answer presents part of the solution.
Correct Answer: A,B,C
Explanation/Reference: Explanation: A: View all databases. View the server state. B: Assign GRANT, DENY, and REVOKE permissions on logins. Members of the securityadmin fixed server role manage logins and their properties. They can GRANT, DENY, and REVOKE server-level permissions. They can also GRANT, DENY, and REVOKE database- level permissions if they have access to a database. Additionally, they can reset passwords for SQL Server logins. C: You need to add DOMAIN\JrDBAs to the server role. References: https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/server-level-roles References: https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms175892(v=sql.105)