Microsoft
70-458 · Question #155
70-458 Question #155: Real Exam Question with Answer & Explanation
Sign in or unlock 70-458 to reveal the answer and full explanation for question #155. The question stem and answer options stay visible for context.
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.
Unlock 70-458 to see the answer
You've previewed enough free 70-458 questions. Unlock 70-458 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.