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: 18)
Snowflake SnowPro Core
Updated on: 10-Mar-2026

Viewing Page 18 of 139
SnowPro Core PDF 1300 Questions

What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

  1. Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.
  2. Scaling out adds clusters of varying sizes to a virtual warehouse.
  3. Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.
  4. Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.
  5. Scaling up resizes a virtual warehouse so it can handle more complex workloads.
  6. Scaling up adds additional database servers to an existing running cluster to handle larger workloads.

Answer(s): A,E



What is the minimum Snowflake edition that has column-level security enabled?

  1. Standard
  2. Enterprise
  3. Business Critical
  4. Virtual Private Snowflake

Answer(s): B



What parameter controls if the Virtual Warehouse starts immediately after the CREATE WAREHOUSE statement?

  1. INITIALLY_SUSPENDED = TRUE/FALSE
  2. START_AFTER_CREATE = TRUE/FALSE
  3. START_THE = 60 // (seconds from now)
  4. START_TIME = CURRENT_DATE()

Answer(s): A



When cloning a database, what is cloned with the database? (Choose two.)

  1. Privileges on the database
  2. Existing child objects within the database
  3. Future child objects within the database
  4. Privileges on the schemas within the database
  5. Only schemas and tables within the database

Answer(s): B,D



Which of the following describes the Snowflake Cloud Services layer?

  1. Coordinates activities in the Snowflake account
  2. Executes queries submitted by the Snowflake account users
  3. Manages quotas on the Snowflake account storage
  4. Manages the virtual warehouse cache to speed up queries

Answer(s): A



What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

  1. 30 days
  2. 7 days
  3. 48 hours
  4. 24 hours

Answer(s): D



When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

  1. A single join node uses more than 50% of the query time
  2. Partitions scanned is equal to partitions total
  3. An AggregateOperator node is present
  4. The query is spilling to remote storage

Answer(s): D



What type of query benefits the MOST from search optimization?

  1. A query that uses only disjunction (i.e., OR) predicates
  2. A query that includes analytical expressions
  3. A query that uses equality predicates or predicates that use IN
  4. A query that filters on semi-structured data types

Answer(s): C


Reference:

https://community.snowflake.com/s/article/Search-Optimization-When-How-To-Use



Viewing Page 18 of 139



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

Vani 8/10/2023 8:11:00 PM

good questions
NEW ZEALAND


Fares 9/11/2023 5:00:00 AM

good one nice revision
Anonymous


Lingaraj 10/26/2023 1:27:00 AM

i love this thank you i need
Anonymous


Muhammad Rawish Siddiqui 12/5/2023 12:38:00 PM

question # 142: data governance is not one of the deliverables in the document and content management context diagram.
SAUDI ARABIA


al 6/7/2023 10:25:00 AM

most answers not correct here
Anonymous


Bano 1/19/2024 2:29:00 AM

what % of questions do we get in the real exam?
UNITED STATES


Oliviajames 10/25/2023 5:31:00 AM

i just want to tell you. i took my microsoft az-104 exam and passed it. your program was awesome. i especially liked your detailed questions and answers and practice tests that made me well-prepared for the exam. thanks to this website!!!
UNITED STATES


Divya 8/27/2023 12:31:00 PM

all the best
UNITED STATES


KY 1/1/2024 11:01:00 PM

very usefull document
Anonymous


Arun 9/20/2023 4:52:00 PM

nice and helpful questions
INDIA


Joseph J 7/11/2023 2:53:00 PM

i found the questions helpful
UNITED STATES


Meg 10/12/2023 8:02:00 AM

q 105 . ans is d
INDIA


Navaneeth S 7/14/2023 7:57:00 AM

i have interest to get a sybase iq dba certification
UNITED STATES


Aish 10/11/2023 5:27:00 AM

want to pass exm.
INDIA


Anonymous 6/12/2023 7:23:00 AM

are the answers correct?
INDIA


Kris 7/7/2023 9:43:00 AM

good morning, could you please upload this exam again, i need it to test my knowledge in sd-wan with version 7.0.
Anonymous


Meghraj mali 10/7/2023 1:47:00 PM

very nice question
CANADA


Noel 11/1/2022 9:14:00 PM

i have learning disability and this exam dumps allowed me to focus on the actual questions and not worry about notes and the those other study materials.
SOUTH AFRICA


Jas 10/25/2023 6:01:00 PM

165 should be apt
UNITED STATES


Neetu 6/22/2023 8:41:00 AM

please upload the dumps, real need of them
Anonymous


Mark 10/24/2023 1:34:00 AM

any recent feeedback?
UNITED STATES


Gopinadh 8/9/2023 4:05:00 AM

question number 2 is indicating you are giving proper questions. observe and change properly.
Anonymous


Santhi 1/1/2024 8:23:00 AM

passed today.40% questions were new.litwere case study,lots of new questions on afd,ratelimit,tm,lb,app gatway.got 2 set series of questions which are not present here.questions on azure cyclecloud, no.of vnet/vms required for implimentation,blueprints assignment/management group etc
INDIA


Raviraj Magadum 1/12/2024 11:39:00 AM

practice test
INDIA


sivaramakrishnan 7/27/2023 8:12:00 AM

want the dumps for emc content management server programming(cmsp)
Anonymous


Aderonke 10/23/2023 1:52:00 PM

brilliant and helpful
UNITED KINGDOM


Az 9/16/2023 2:43:00 PM

q75. azure files is pass
SWITZERLAND


ketty 11/9/2023 8:10:00 AM

very helpful
Anonymous


Sonail 5/2/2022 1:36:00 PM

thank you for these questions. it helped a lot.
UNITED STATES


Shariq 7/28/2023 8:00:00 AM

how do i get the h12-724 dumps
Anonymous


adi 10/30/2023 11:51:00 PM

nice data dumps
Anonymous


EDITH NCUBE 7/25/2023 7:28:00 AM

answers are correct
SOUTH AFRICA


Raja 6/20/2023 4:38:00 AM

good explanation
UNITED STATES


BigMouthDog 1/22/2022 8:17:00 PM

hi team just want to know if there is any update version of the exam 350-401
AUSTRALIA