Redshift Access Control Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Authorization

What you'll be asked

  1. Which Redshift command is primarily used to grant permissions to a user or group on a specific database object?
  2. When using Role-Based Access Control (RBAC) in Redshift, what happens when you grant a role to a user?
  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. 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. 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?

Answers and explanations come after you submit.