SnowPro Advanced: Architect — Question 164

A global retail company must ensure comprehensive data governance, security, and compliance with various international regulations while using Snowflake for its data warehousing and analytics.

What should an Architect do to meet these requirements? (Choose two.)

Answer options

• A. Create a network policy at the column level to secure the data.
• B. Use column-level security to restrict access to specific columns.
• C. Store encryption keys on an external server to manage encryption manually.
• D. Implement Role-Based Access Control (RBAC) to assign roles and permissions.
• E. Enable Secure Data Sharing with external partners for collaborative purposes.

Correct answer: B, D

Explanation

Option B is correct because column-level security specifically restricts access to certain columns, enhancing data security and compliance. Option D is also correct, as Role-Based Access Control (RBAC) effectively manages user permissions, aligning with governance and compliance requirements. Options A and C do not provide adequate data governance or security measures, and option E, while useful for collaboration, does not directly address the core requirements of governance and compliance.