Redshift Access Control Quiz

Quiz covering Authorization

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

1. 1

   Which Redshift command is primarily used to grant permissions to a user or group on a specific database object?

2. 2

   When using Role-Based Access Control (RBAC) in Redshift, what happens when you grant a role to a user?

3. 3

   You need to ensure that a specific user can only view rows in the 'sales' table where the 'region' column equals 'North'. Which Redshift feature should you implement?

4. 4

   A data analyst needs to query data from a table, but you must prevent them from seeing the 'salary' column. How can you achieve this?

5. 5

   Your organization uses AWS Lake Formation for data governance. If you have a Redshift spectrum table pointing to S3, how are permissions handled if the table is registered in Lake Formation?