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

Viewing Page 27 of 139
SnowPro Core PDF 1300 Questions

When should a multi-cluster warehouse be used in auto-scaling mode?

  1. When it is unknown how much compute power is needed
  2. If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
  3. If the runtime of the executed query is very slow
  4. When a large number of concurrent queries are run on the same warehouse

Answer(s): D



What happens when a cloned table is replicated to a secondary database? (Choose two.)

  1. A read-only copy of the cloned tables is stored.
  2. The replication will not be successful.
  3. The physical data is replicated.
  4. Additional costs for storage are charged to a secondary account.
  5. Metadata pointers to cloned tables are replicated.

Answer(s): C,D



Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

  1. Amazon Web Services
  2. Docker
  3. IBM Cloud
  4. Microsoft Azure Cloud
  5. Google Cloud Platform
  6. Oracle Cloud

Answer(s): A,D,E



What is a limitation of a Materialized View?

  1. A Materialized View cannot support any aggregate functions
  2. A Materialized View can only reference up to two tables
  3. A Materialized View cannot be joined with other tables
  4. A Materialized View cannot be defined with a JOIN

Answer(s): D



In the Snowflake access control model, which entity owns an object by default?

  1. The user who created the object
  2. The SYSADMIN role
  3. Ownership depends on the type of object
  4. The role used to create the object

Answer(s): D



What is the minimum Snowflake edition required to use Dynamic Data Masking?

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

Answer(s): B



Which services does the Snowflake Cloud Services layer manage? (Choose two.)

  1. Compute resources
  2. Query execution
  3. Authentication
  4. Data storage
  5. Metadata

Answer(s): C,E



A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.

Which Snowflake feature will support this?

  1. Row access policies
  2. Data masking policies
  3. Data encryption
  4. Role based access control

Answer(s): B



Viewing Page 27 of 139



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

Lakshmi 10/2/2023 5:26:00 AM

just started to view all questions for the exam
NETHERLANDS


rani 1/19/2024 11:52:00 AM

helpful material
Anonymous


Greg 11/16/2023 6:59:00 AM

hope for the best
UNITED STATES


hi 10/5/2023 4:00:00 AM

will post exam has finished
UNITED STATES


Vmotu 8/24/2023 11:14:00 AM

really correct and good analyze!
AZERBAIJAN


hicham 5/30/2023 8:57:00 AM

excellent thanks a lot
FRANCE


Suman C 7/7/2023 8:13:00 AM

will post once pass the cka exam
INDIA


Ram 11/3/2023 5:10:00 AM

good content
Anonymous


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

q:32 answer has to be option c
INDIA


Tamer Barakat 12/7/2023 5:17:00 PM

nice questions
Anonymous


Daryl 8/1/2022 11:33:00 PM

i really like the support team in this website. they are fast in communication and very helpful.
UNITED KINGDOM


Curtis Nakawaki 6/29/2023 9:13:00 PM

a good contemporary exam review
UNITED STATES


x-men 5/23/2023 1:02:00 AM

q23, its an array, isnt it? starts with [ and end with ]. its an array of objects, not object.
UNITED STATES


abuti 7/21/2023 6:24:00 PM

cool very helpfull
Anonymous


Krishneel 3/17/2023 10:34:00 AM

i just passed. this exam dumps is the same one from prepaway and examcollection. it has all the real test questions.
INDIA


Regor 12/4/2023 2:01:00 PM

is this a valid prince2 practitioner dumps?
UNITED KINGDOM


asl 9/14/2023 3:59:00 PM

all are relatable questions
CANADA


Siyya 1/19/2024 8:30:00 PM

might help me to prepare for the exam
Anonymous


Ted 6/21/2023 11:11:00 PM

just paid and downlaod the 2 exams using the 50% sale discount. so far i was able to download the pdf and the test engine. all looks good.
GERMANY


Paul K 11/27/2023 2:28:00 AM

i think it should be a,c. option d goes against the principle of building anything custom unless there are no work arounds available
INDIA


ph 6/16/2023 12:41:00 AM

very legible
Anonymous


sephs2001 7/31/2023 10:42:00 PM

is this exam accurate or helpful?
Anonymous


ash 7/11/2023 3:00:00 AM

please upload dump, i have exam in 2 days
INDIA


Sneha 8/17/2023 6:29:00 PM

this is useful
CANADA


sachin 12/27/2023 2:45:00 PM

question 232 answer should be perimeter not netowrk layer. wrong answer selected
Anonymous


tomAws 7/18/2023 5:05:00 AM

nice questions
BRAZIL


Rahul 6/11/2023 2:07:00 AM

hi team, could you please provide this dump ?
INDIA


TeamOraTech 12/5/2023 9:49:00 AM

very helpful to clear the exam and understand the concept.
Anonymous


Curtis 7/12/2023 8:20:00 PM

i think it is great that you are helping people when they need it. thanks.
UNITED STATES


sam 7/17/2023 6:22:00 PM

cannot evaluate yet
Anonymous


nutz 7/20/2023 1:54:00 AM

a laptops wireless antenna is most likely located in the bezel of the lid
UNITED STATES


rajesh soni 1/17/2024 6:53:00 AM

good examplae to learn basic
INDIA


Tanya 10/25/2023 7:07:00 AM

this is useful information
Anonymous


Nasir Mahmood 12/11/2023 7:32:00 AM

looks usefull
Anonymous