SnowPro Advanced: Architect — Question 105

A company needs to have the following features available in its Snowflake account:

1. Support for Multi-Factor Authentication (MFA)
2. A minimum of 2 months of Time Travel availability
3. Database replication in between different regions
4. Native support for JDBC and ODBC
5. Customer-managed encryption keys using Tri-Secret Secure
6. Support for Payment Card Industry Data Security Standards (PCI DSS)

In order to provide all the listed services, what is the MINIMUM Snowflake edition that should be selected during account creation?

Answer options

• A. Standard
• B. Enterprise
• C. Business Critical
• D. Virtual Private Snowflake (VPS)

Correct answer: C

Explanation

The Business Critical edition of Snowflake provides all the required features, including Multi-Factor Authentication, extended Time Travel, cross-region database replication, JDBC and ODBC support, customer-managed encryption keys, and compliance with PCI DSS. The Standard and Enterprise editions do not include all of these features, while Virtual Private Snowflake (VPS) is a more specialized offering that is not necessary for these requirements.