70-764関連受験参考書質問157：You administer a Windows Azure SQL Database database named Human_Resources. The database contains 2 tables

有効的な70-764問題集はJPNTest.com提供され、70-764試験に合格することに役に立ちます！JPNTest.comは今最新70-764試験問題集を提供します。JPNTest.com 70-764試験問題集はもう更新されました。ここで70-764問題集のテストエンジンを手に入れます。

70-764問題集最新版のアクセス
「452問、３０％ディスカウント、特別な割引コード：JPNshiken」

<<前へ次へ>>

質問 157/194

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?

A. Create two database roles: Employees and HRAdmins.
Add all company employees to the Employees role.
Add HR administrators to the HRAdmins role.
Grant SELECT access to all tables except SalaryDetails to the Employees role.
Grant SELECT access to the SalaryDetails table to the HRAdmins role.
Deny SELECT access to the SalaryDetails table to the Employees role. B. Create a database role called Employees.
Add all HR administrators to the db_datareader role.
Add all company employees to the Employees role.
Grant SELECT access to all tables except the SalaryDetails table to the Employees role.
Deny SELECT access to the SalaryDetails table to the Employees role. C. Create a database role called HRAdmins.
Add all company employees except HR administrators to the db_datareader role, Add all HR administrators to the HRAdmins role.
Grant SELECT access to the SalaryDetails table to the HRAdmins role.
Deny SELECT access to the SalaryDetails table to the db_datareader role. D. Create a database role called Employees.
Add CORP\Employees to the db_datareader role.
Add all company employees except HR administrators to the Employees role.
Deny SELECT access to the SalaryDetails table to the Employees role.

質問 157/194

コメントを発表する

Download PDF File