Snowflake SnowPro Core Exam (page: 16)
Snowflake SnowPro Core
Updated on: 25-Dec-2025

Viewing Page 16 of 221

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

Answer(s): B,C


Reference:

https://docs.snowflake.com/en/user-guide/warehouses-considerations.html



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

Answer(s): A,B,C


Reference:

https://docs.snowflake.com/en/user-guide/data-load-overview.html



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.

Answer(s): D


Reference:

https://docs.snowflake.com/en/user-guide/warehouses-overview.html



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

  1. True
  2. False

Answer(s): B


Reference:

https://docs.snowflake.com/en/user-guide/admin-security-fed-auth-use.html



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

Answer(s): A,C


Reference:

https://docs.snowflake.com/en/user-guide/warehouses-overview.html



Viewing Page 16 of 221



Share your comments for Snowflake SnowPro Core exam with other users:

Jorn 7/13/2023 5:05:00 AM

relevant questions
UNITED KINGDOM


AM 6/20/2023 7:54:00 PM

please post
UNITED STATES


Nagendra Pedipina 7/13/2023 2:22:00 AM

q:42 there has to be a image in the question to choose what does it mean from the options
INDIA


BrainDumpee 11/18/2023 1:36:00 PM

looking for cphq dumps, where can i find these for free? please and thank you.
UNITED STATES


sheik 10/14/2023 11:37:00 AM

@aarun , thanks for the information. it would be great help if you share your email
Anonymous


Random user 12/11/2023 1:34:00 AM

1z0-1078-23 need this dumps
Anonymous


labuschanka 11/16/2023 6:06:00 PM

i gave the microsoft azure az-500 tests and prepared from this site as it has latest mock tests available which helped me evaluate my performance and score 919/1000
Anonymous


Marianne 10/22/2023 11:57:00 PM

i cannot see the button to go to the questions
Anonymous


sushant 6/28/2023 4:52:00 AM

good questions
EUROPEAN UNION


A\MAM 6/27/2023 5:17:00 PM

q-6 ans-b correct. https://docs.paloaltonetworks.com/pan-os/9-1/pan-os-cli-quick-start/use-the-cli/commit-configuration-changes
UNITED STATES


unanimous 12/15/2023 6:38:00 AM

very nice very nice
Anonymous


akminocha 9/28/2023 10:36:00 AM

please help us with 1z0-1107-2 dumps
INDIA


Jefi 9/4/2023 8:15:00 AM

please upload the practice questions
Anonymous


Thembelani 5/30/2023 2:45:00 AM

need this dumps
Anonymous


Abduraimov 4/19/2023 12:43:00 AM

preparing for this exam is overwhelming. you cannot pass without the help of these exam dumps.
UNITED KINGDOM


Puneeth 10/5/2023 2:06:00 AM

new to this site but i feel it is good
EUROPEAN UNION


Ashok Kumar 1/2/2024 6:53:00 AM

the correct answer to q8 is b. explanation since the mule app has a dependency, it is necessary to include project modules and dependencies to make sure the app will run successfully on the runtime on any other machine. source code of the component that the mule app is dependent of does not need to be included in the exported jar file, because the source code is not being used while executing an app. compiled code is being used instead.
Anonymous


Merry 7/30/2023 6:57:00 AM

good questions
Anonymous


VoiceofMidnight 12/17/2023 4:07:00 PM

Delayed the exam until December 29th.
UNITED STATES


Umar Ali 8/29/2023 2:59:00 PM

A and D are True
Anonymous


vel 8/28/2023 9:17:09 AM

good one with explanation
Anonymous


Gurdeep 1/18/2024 4:00:15 PM

This is one of the most useful study guides I have ever used.
CANADA