Which approach will meet these requirements if Role-Based Access Policies (RBAC) is a viable option for isolating tenants?

A Snowflake Architect is designing an application and tenancy strategy for an organization where strong legal isolation rules as well as multi-tenancy are requirements.

Which approach will meet these requirements if Role-Based Access Policies (RBAC) is a viable option for isolating tenants?
A . Create accounts for each tenant in the Snowflake organization.
B . Create an object for each tenant strategy if row level security is viable for isolating tenants.
C . Create an object for each tenant strategy if row level security is not viable for isolating tenants.
D . Create a multi-tenant table strategy if row level security is not viable for isolating tenants.

View Answer

Answer: A

Explanation:

In a scenario where strong legal isolation is required alongside the need for multi-tenancy, the most effective approach is to create separate accounts for each tenant within the Snowflake organization. This approach ensures complete isolation of data, resources, and management, adhering to strict legal and compliance requirements. Role-Based Access Control (RBAC) further enhances security by allowing granular control over who can access what resources within each account. This solution leverages Snowflake’s capabilities for managing multiple accounts under a single organization umbrella, ensuring that each tenant’s data and operations are isolated from others.

Reference: Snowflake documentation on multi-tenancy and account management, part of the SnowPro Advanced: Architect learning path.