SnowPro Core Practice Test

SnowPro Core Practice Test practice questions, page 16 of 54, with answer review and explanations.

Question 76

When should you consider disabling auto-suspend for a Virtual Warehouse? (Choose two.)

  1. When users will be using compute at different times throughout a 24/7 period
  2. When managing a steady workload
  3. When the compute must be available with no delay or lag time
  4. When you do not want to have to manually turn on the Warehouse each time a user needs it

Question 77

Which of the following are valid approaches to loading data into a Snowflake table? (Choose all that apply.)

  1. Bulk copy from an External Stage
  2. Continuous load using Snowpipe REST API
  3. The Snowflake Web Interface (UI) data loading wizard
  4. Bulk copy from an Internal Stage

Question 78

If auto-suspend is enabled for a Virtual Warehouse, the Warehouse is automatically suspended when:

  1. All Snowflakes sessions using the Warehouse are terminated.
  2. The last query using the Warehouse completes.
  3. There are no users logged into Snowflake.
  4. The Warehouse is inactive for a specified period of time.

Question 79

True or False: Multi-Factor Authentication (MFA) in Snowflake is only supported in conjunction with Single Sign-On (SSO).

  1. True
  2. False

Question 80

The number of queries that a Virtual Warehouse can concurrently process is determined by (Choose two.):

  1. The complexity of each query
  2. The CONCURRENT_QUERY_LIMIT parameter set on the Snowflake account
  3. The size of the data required for each query
  4. The tool that is executing the query