SnowPro Advanced: Architect — Question 31

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?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C because it directly addresses the scenario where row level security is not feasible for isolating tenants, necessitating the creation of specific objects for each tenant. Options A and B do not adequately accommodate the multi-tenancy and legal isolation requirements under the specified conditions, while D suggests a multi-tenant table strategy, which may not meet the legal isolation needs.