Amazon
Avaya
Cisco
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL
Juniper
Microsoft
NVIDIA
Okta
Palo Alto Networks
Salesforce
SAP
ServiceNow
All Vendors
  1. Home
  2. Snowflake
  3. SnowPro Core

Snowflake SnowPro Core Exam (page: 8)
Snowflake SnowPro Core
Updated on: 10-Mar-2026

Viewing Page 8 of 139
SnowPro Core PDF 1300 Questions

Which of the following DML commands isn't supported by Snowflake?

  1. UPSERT
  2. MERGE
  3. UPDATE
  4. TRUNCATE TABLE

Answer(s): A


Reference:

https://docs.snowflake.com/en/sql-reference/sql-dml.html



Which of the following statements is true of zero-copy cloning?

  1. Zero-copy clones increase storage costs as cloning the table requires storing its data twice
  2. All zero-copy clone objects inherit the privileges of their original objects
  3. Zero-copy cloning is licensed as an additional Snowflake feature
  4. At the instance/instant a clone is created, all micro-partitions in the original table and the clone are fully shared

Answer(s): D


Reference:

https://community.snowflake.com/s/question/0D50Z00009D8VOd/zero-copy-cloning-base-data



True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.

  1. True
  2. False

Answer(s): B



The Query History in the Snowflake Web Interface (UI) is kept for approximately:

  1. 60 minutes
  2. 24 hours
  3. 14 days
  4. 30 days
  5. 1 year

Answer(s): C



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



Viewing Page 8 of 139



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

User-sfdc 12/29/2023 7:21:00 AM

sample questions seems good
Anonymous


Tamer dam 8/4/2023 10:21:00 AM

huawei is ok
UNITED STATES


YK 12/11/2023 1:10:00 AM

good one nice
JAPAN


de 8/28/2023 2:38:00 AM

please continue
GERMANY


DMZ 6/25/2023 11:56:00 PM

this exam dumps just did the job. i donot want to ruffle your feathers but your exam dumps and mock test engine is amazing.
UNITED KINGDOM


Jose 8/30/2023 6:14:00 AM

nice questions
PORTUGAL


Tar01 7/24/2023 7:07:00 PM

the explanation are really helpful
Anonymous


DaveG 12/15/2023 4:50:00 PM

just passed my exam yesterday on my first attempt. these dumps were extremely helpful in passing first time. the questions were very, very similar to these questions!
Anonymous


A.K. 6/30/2023 6:34:00 AM

cosmos db is paas not saas
Anonymous


S Roychowdhury 6/26/2023 5:27:00 PM

what is the percentage of common questions in gcp exam compared to 197 dump questions? are they 100% matching with real gcp exam?
Anonymous


Bella 7/22/2023 2:05:00 AM

not able to see questions
Anonymous


Scott 9/8/2023 7:19:00 AM

by far one of the best sites for free questions. i have pass 2 exams with the help of this website.
CANADA


donald 8/19/2023 11:05:00 AM

excellent question bank.
Anonymous


Ashwini 8/22/2023 5:13:00 AM

it really helped
Anonymous


sk 5/13/2023 2:07:00 AM

excelent material
INDIA


Christopher 9/5/2022 10:54:00 PM

the new versoin of this exam which i downloaded has all the latest questions from the exam. i only saw 3 new questions in the exam which was not in this dump.
CANADA


Sam 9/7/2023 6:51:00 AM

question 8 - can cloudtrail be used for storing jobs? based on aws - aws cloudtrail is used for governance, compliance and investigating api usage across all of our aws accounts. every action that is taken by a user or script is an api call so this is logged to [aws] cloudtrail. something seems incorrect here.
UNITED STATES


Tanvi Rajput 8/14/2023 10:55:00 AM

question 13 tda - c01 answer : quick table calculation -> percentage of total , compute using table down
UNITED KINGDOM


PMSAGAR 9/19/2023 2:48:00 AM

pls share teh dump
UNITED STATES


zazza 6/16/2023 10:47:00 AM

question 44 answer is user risk
ITALY


Prasana 6/23/2023 1:59:00 AM

please post the questions for preparation
Anonymous


test user 9/24/2023 3:15:00 AM

thanks for the questions
AUSTRALIA


Draco 7/19/2023 5:34:00 AM

please reopen it now ..its really urgent
UNITED STATES


Megan 4/14/2023 5:08:00 PM

these practice exam questions were exactly what i needed. the variety of questions and the realistic exam-like environment they created helped me assess my strengths and weaknesses. i felt more confident and well-prepared on exam day, and i owe it to this exam dumps!
UNITED KINGDOM


abdo casa 8/9/2023 6:10:00 PM

thank u it very instructuf
Anonymous


Danny 1/15/2024 9:10:00 AM

its helpful?
INDIA


hanaa 10/3/2023 6:57:00 PM

is this dump still valid???
Anonymous


Georgio 1/19/2024 8:15:00 AM

question 205 answer is b
Anonymous


Matthew Dievendorf 5/30/2023 9:37:00 PM

question 39, should be answer b, directions stated is being sudneted from /21 to a /23. a /23 has 512 ips so 510 hosts. and can make 4 subnets out of the /21
Anonymous


Adhithya 8/11/2022 12:27:00 AM

beautiful test engine software and very helpful. questions are same as in the real exam. i passed my paper.
UNITED ARAB EMIRATES


SuckerPumch88 4/25/2022 10:24:00 AM

the questions are exactly the same in real exam. just make sure not to answer all them correct or else they suspect you are cheating.
UNITED STATES


soheib 7/24/2023 7:05:00 PM

question: 78 the right answer i think is d not a
Anonymous


srija 8/14/2023 8:53:00 AM

very helpful
EUROPEAN UNION


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

i am writing this exam tomorrow and have dumps
Anonymous