If queries start to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately under what setting?
Correct Answer: A
In Snowflake, when queries begin to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately if the warehouse is set to auto-scale mode. This mode allowsSnowflake to automatically add or resume additional clusters as soon as the workload increases, and similarly, shut down or pause the additional clusters when the load decreases
Question 227
What AUTHENTICATION_METHODS value should be selected for the Single Sign-On, or SSO, login option to appear when creating a Snowflake authentication policy?
Correct Answer: C
The correct answer is C. SAML . In Snowflake, Single Sign-On is commonly implemented using federated authentication through a SAML 2.0 identity provider. When creating an authentication policy, including SAML in the allowed AUTHENTICATION_METHODS enables SSO-based login options. Why C is correct: SAML represents SAML-based federated authentication. This is the authentication method associated with SSO login in Snowflake. Example concept: CREATE AUTHENTICATION POLICY sso_policy AUTHENTICATION_METHODS = ( ' SAML ' ); Why the other options are incorrect: A). PASSWORD allows username and password authentication, not SSO. B). KEYPAIR allows key-pair authentication, commonly used for service accounts and applications. D). OAUTH allows OAuth-based authentication, but the SSO login option in this context is associated with SAML. Official Snowflake documentation reference: Snowflake documentation describes authentication policies as controlling allowed authentication methods, including password, SAML, OAuth, and key-pair authentication. SAML is used for federated SSO authentication. Reference: Snowflake Documentation - Authentication policies; Snowflake Documentation - Federated authentication and SSO; SnowPro Core Study Guide - Security and Access Control. ==
Question 228
A running virtual warehouse is suspended. What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?
Correct Answer: B
When a running virtual warehouse in Snowflake is suspended and then restarted, the minimum amount of time it will incur charges for is 60 seconds2.
Question 229
How does Snowflake recommend defining a clustering key on a high-cardinality column that includes a 15 digit ID numbered column ID_NUMER?
Correct Answer: D
Question 230
What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?
Correct Answer: D
The minimum edition of Snowflake required to use a SCIM security integration is the Enterprise Edition. SCIM integrations are used for automated management of user identities and groups, and this feature is available starting from the Enterprise Edition of Snowflake. References: [ COF-C03 ] SnowPro Core Certification Exam Study Guide
