Managers in a company need access to the human resources database that runs on Amazon Redshift, to run reports about their employees. Managers must only see information about their direct reports.
Which technique should be used to address this requirement with Amazon Redshift?

Question

Managers in a company need access to the human resources database that runs on Amazon Redshift, to run reports about their employees. Managers must only see information about their direct reports.

Which technique should be used to address this requirement with Amazon Redshift?

evalson martin laplap · Accepted Answer

Define an IAM group for each manager with each employee as an IAM user in that group, and use that to limit the access.

evalson martin laplap · Answer

Use Amazon Redshift snapshot to create one cluster per manager. Allow the managers to access only their designated clusters.

evalson martin laplap · Answer

Define a key for each manager in AWS KMS and encrypt the data for their employees with their private keys.

evalson martin laplap · Answer

Define a view that uses the employee's manager name to filter the records based on current user names.

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 37 - BDS-C00 discussion

Suggested answer: A

0 comments