Microsoft
70-458 · Question #155
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…
The correct answer is D. Create a database role called Employees. See the full explanation below for the reasoning.
Question
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?
Options
- ACreate a database role called Employees.
- BCreate a database role called HRAdmins.
- CCreate two database roles:
- DCreate a database role called Employees.
How the community answered
(31 responses)- A19% (6)
- B3% (1)
- C6% (2)
- D71% (22)
Community Discussion
No community discussion yet for this question.