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

Viewing Page 13 of 221

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

  1. Configure the Maximum Clusters setting to “Auto-Scale”
  2. Set the Warehouse type to “Auto”
  3. Set the Minimum Clusters and Maximum Clusters settings to the same value
  4. Set the Minimum Clusters and Maximum Clusters settings to the different values

Answer(s): D


Reference:

https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse



Which of the following terms best describes Snowflake's database architecture?

  1. Columnar shared nothing
  2. Shared disk
  3. Multi-cluster, shared data
  4. Cloud-native shared memory

Answer(s): C



Which of the following are options when creating a Virtual Warehouse? (Choose two.)

  1. Auto-drop
  2. Auto-resize
  3. Auto-resume
  4. Auto-suspend

Answer(s): C,D


Reference:

https://help.pentaho.com/Documentation/9.1/Products/Create_Snowflake_warehouse



A Virtual Warehouse's auto-suspend and auto-resume settings apply to:

  1. The primary cluster in the Virtual Warehouse
  2. The entire Virtual Warehouse
  3. The database the Virtual Warehouse resides in
  4. The queries currently being run by the Virtual Warehouse

Answer(s): B


Reference:

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



Fail-safe is unavailable on which table types? (Choose two.)

  1. Temporary
  2. Transient
  3. Provisional
  4. Permanent

Answer(s): A,B


Reference:

https://docs.snowflake.com/en/user-guide/tables-temp-transient.html



Viewing Page 13 of 221



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

Chandra 11/28/2024 7:17:38 AM

This is the best and only way of passing this exam as it is extremely hard. Good questions and valid dump.
INDIA


Sunak 1/25/2025 9:17:57 AM

Can I use this dumps when I am taking the exam? I mean does somebody look what tabs or windows I have opened ?
BULGARIA


Frank 2/15/2024 11:36:57 AM

Finally got a change to write this exam and pass it! Valid and accurate!
CANADA


Anonymous User 2/2/2024 6:42:12 PM

Upload this exam please!
Anonymous


Nicholas 2/2/2024 6:17:08 PM

Thank you for providing these questions. It helped me a lot with passing my exam.
Anonymous


Timi 8/19/2023 5:30:00 PM

my first attempt
UNITED KINGDOM


Blessious Phiri 8/13/2023 10:32:00 AM

very explainable
Anonymous


m7md ibrahim 5/26/2023 6:21:00 PM

i think answer of q 462 is variance analysis
Anonymous


Tehu 5/25/2023 12:25:00 PM

hi i need see questions
Anonymous


Ashfaq Nasir 1/17/2024 1:19:00 AM

best study material for exam
Anonymous


Roberto 11/27/2023 12:33:00 AM

very interesting repository
ITALY


Nale 9/18/2023 1:51:00 PM

american history 1
Anonymous


Tanvi 9/27/2023 4:02:00 AM

good level of questions
Anonymous


Boopathy 8/17/2023 1:03:00 AM

i need this dump kindly upload it
Anonymous


s_123 8/12/2023 4:28:00 PM

do we need c# coding to be az204 certified
Anonymous


Blessious Phiri 8/15/2023 3:38:00 PM

excellent topics covered
Anonymous


Manasa 12/5/2023 3:15:00 AM

are these really financial cloud questions and answers, seems these are basic admin question and answers
Anonymous


Not Robot 5/14/2023 5:33:00 PM

are these comments real
Anonymous


kriah 9/4/2023 10:44:00 PM

please upload the latest dumps
UNITED STATES


ed 12/17/2023 1:41:00 PM

a company runs its workloads on premises. the company wants to forecast the cost of running a large application on aws. which aws service or tool can the company use to obtain this information? pricing calculator ... the aws pricing calculator is primarily used for estimating future costs
UNITED STATES


Muru 12/29/2023 10:23:00 AM

looks interesting
Anonymous


Tech Lady 10/17/2023 12:36:00 PM

thanks! that’s amazing
Anonymous


Mike 8/20/2023 5:12:00 PM

the exam dumps are helping me get a solid foundation on the practical techniques and practices needed to be successful in the auditing world.
UNITED STATES


Nobody 9/18/2023 6:35:00 PM

q 14 should be dmz sever1 and notepad.exe why does note pad have a 443 connection
Anonymous


Muhammad Rawish Siddiqui 12/4/2023 12:17:00 PM

question # 108, correct answers are business growth and risk reduction.
SAUDI ARABIA


Emmah 7/29/2023 9:59:00 AM

are these valid chfi questions
KENYA


Mort 10/19/2023 7:09:00 PM

question: 162 should be dlp (b)
EUROPEAN UNION


Eknath 10/4/2023 1:21:00 AM

good exam questions
INDIA


Nizam 6/16/2023 7:29:00 AM

I have to say this is really close to real exam. Passed my exam with this.
EUROPEAN UNION


poran 11/20/2023 4:43:00 AM

good analytics question
Anonymous


Antony 11/23/2023 11:36:00 AM

this looks accurate
INDIA


Ethan 8/23/2023 12:52:00 AM

question 46, the answer should be data "virtualization" (not visualization).
Anonymous


nSiva 9/22/2023 5:58:00 AM

its useful.
UNITED STATES


Ranveer 7/26/2023 7:26:00 PM

Pass this exam 3 days ago. The PDF version and the Xengine App is quite useful.
SOUTH AFRICA