SnowPro Advanced: Architect — Question 192

Company A acquired Company B. Company B has clients that are direct competitors of Company A. Both companies need to continue to run independent data operations. An Architect has been asked to investigate if a shared Snowflake infrastructure is feasible.

Following Snowflake recommendations, which account design strategy would support this workload?

Answer options

• A. Use a single Snowflake account with separate databases, using Role-Based Access Control to isolate Company A’s data from Company B’s data.
• B. Use a single Snowflake account with separate virtual warehouses, using data masking policies for client-level data access.
• C. Use a separate Snowflake account for each company, using Secure Data Sharing to exchange data as needed.
• D. Use one primary account for Company A under a Snowflake Organization, and use a secondary replicated account for Company B.

Correct answer: C

Explanation

The correct answer is C because using separate Snowflake accounts for each company allows them to maintain independent data operations while still being able to share necessary data securely through Secure Data Sharing. The other options would not adequately isolate the data of the two companies or could potentially lead to compliance issues due to shared access.