Snowflake Quiz — Security, Roles & Governance

1. Which Snowflake feature implements role-based access control (RBAC)?

2. How do you create a custom role 'data_analyst' in Snowflake?

3. How do you grant SELECT privileges on a table to a role?

4. How do you create a masking policy to hide sensitive data?

5. How do you apply a masking policy to a column?

6. How do you enable secure data sharing with another Snowflake account?

7. How do you assign a role to a user?

8. How do you check the privileges granted to a role?

9. How do you revoke a privilege from a role?

10. How do you ensure only specific roles can view a column with sensitive data?