SnowPro Advanced: Architect — Question 93

A Snowflake Architect is designing a multiple-account design strategy.

This strategy will be MOST cost-effective with which scenarios? (Choose two.)

Answer options

• A. The company wants to clone a production database that resides on AWS to a development database that resides on Azure.
• B. The company needs to share data between two databases, where one must support Payment Card Industry Data Security Standard (PCI DSS) compliance but the other one does not.
• C. The company needs to support different role-based access control features for the development, test, and production environments.
• D. The company security policy mandates the use of different Active Directory instances for the development, test, and production environments.
• E. The company must use a specific network policy for certain users to allow and block given IP addresses.

Correct answer: B, D

Explanation

Option B is correct because sharing data between databases with differing compliance needs can be effectively managed within a multiple-account strategy. Option D is also correct since having separate Active Directory instances for different environments aligns with maintaining security and operational segregation. The other options do not focus on cost-effectiveness in the same way or involve scenarios that do not optimize the multi-account architecture.