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: C

Explanation:

This approach meets the requirements of strong legal isolation and multi-tenancy. By creating separate accounts for each tenant, the application can ensure that each tenant has its own dedicated storage, compute, and metadata resources, as well as its own encryption keys and security policies.

This provides the highest level of isolation and data protection among the tenancy models.

Furthermore, by creating the accounts within the same Snowflake organization, the application can leverage the features of Snowflake Organizations, such as centralized billing, account management, and cross-account data sharing.

Reference: Snowflake Organizations Overview | Snowflake Documentation Design Patterns for Building Multi-Tenant Applications on Snowflake