Valid 70-765 Dumps shared by ExamDiscuss.com for Helping Passing 70-765 Exam! ExamDiscuss.com now offer the newest 70-765 exam dumps, the ExamDiscuss.com 70-765 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-765 dumps with Test Engine here:
You administer a Windows Azure SQL Database database named Human_Resources. The database contains 2 tables named Employees and SalaryDetails. You add two Windows groups as logins for the server: CORP\Employees - All company employees CORP\HRAdmins - HR administrators only HR Administrators are also company employees. You need to grant users access according to the following requirements: CORP\Employees should have SELECT access to the Employees table. Only users in CORP \HRAdmins should have SELECT access to the SalaryDetails table. Logins are based only on Windows security groups. What should you do?
Correct Answer: D
Explanation/Reference: Explanation: Members of the db_datareader fixed database role can run a SELECT statement against any table or view in the database. References: https://technet.microsoft.com/en-us/library/ms188629(v=sql.90).aspx