Snowflake SnowPro Core SnowPro Core Dumps in PDF

Free Snowflake SnowPro Core Real Questions (page: 28)

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



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

C
Chere
9/15/2023 4:21:00 AM

found it good

T
Thembelani
5/30/2023 2:47:00 AM

excellent material

V
vinesh phale
9/11/2023 2:51:00 AM

very helpfull

B
Bhagiii
11/4/2023 7:04:00 AM

well explained.

R
Rahul
8/8/2023 9:40:00 PM

i need the pdf, please.

C
CW
7/11/2023 2:51:00 PM

a good source for exam preparation

A
Anchal
10/23/2023 4:01:00 PM

nice questions

J
J Nunes
9/29/2023 8:19:00 AM

i need ielts general training audio guide questions

A
Ananya
9/14/2023 5:16:00 AM

please make this content available

S
Swathi
6/4/2023 2:18:00 PM

content is good

L
Leo
7/29/2023 8:45:00 AM

latest dumps please

L
Laolu
2/15/2023 11:04:00 PM

aside from pdf the test engine software is helpful. the interface is user-friendly and intuitive, making it easy to navigate and find the questions.

Z
Zaynik
9/17/2023 5:36:00 AM

questions and options are correct, but the answers are wrong sometimes. so please check twice or refer some other platform for the right answer

M
Massam
6/11/2022 5:55:00 PM

90% of questions was there but i failed the exam, i marked the answers as per the guide but looks like they are not accurate , if not i would have passed the exam given that i saw about 45 of 50 questions from dump

A
Anonymous
12/27/2023 12:47:00 AM

answer to this question "what administrative safeguards should be implemented to protect the collected data while in use by manasa and her product management team? " it should be (c) for the following reasons: this administrative safeguard involves controlling access to collected data by ensuring that only individuals who need the data for their job responsibilities have access to it. this helps minimize the risk of unauthorized access and potential misuse of sensitive information. while other options such as (a) documenting data flows and (b) conducting a privacy impact assessment (pia) are important steps in data protection, implementing a "need to know" access policy directly addresses the issue of protecting data while in use by limiting access to those who require it for legitimate purposes. (d) is not directly related to safeguarding data during use; it focuses on data transfers and location.

J
Japles
5/23/2023 9:46:00 PM

password lockout being the correct answer for question 37 does not make sense. it should be geofencing.

F
Faritha
8/10/2023 6:00:00 PM

for question 4, the righr answer is :recover automatically from failures

A
Anonymous
9/14/2023 4:27:00 AM

question number 4s answer is 3, option c. i

P
p das
12/7/2023 11:41:00 PM

very good questions

A
Anna
1/5/2024 1:12:00 AM

i am confused about the answers to the questions. are the answers correct?

B
Bhavya
9/13/2023 10:15:00 AM

very usefull

R
Rahul Kumar
8/31/2023 12:30:00 PM

need certification.

D
Diran Ole
9/17/2023 5:15:00 PM

great exam prep

V
Venkata Subbarao Bandaru
6/24/2023 8:45:00 AM

i require dump

D
D
7/15/2023 1:38:00 AM

good morning, could you please upload this exam again,

A
Ann
9/15/2023 5:39:00 PM

hi can you please upload the dumps for sap contingent module. thanks

S
Sridhar
1/16/2024 9:19:00 PM

good questions

S
Summer
10/4/2023 9:57:00 PM

looking forward to the real exam

V
vv
12/2/2023 2:45:00 PM

good ones for exam preparation

D
Danny Zas
9/15/2023 4:45:00 AM

this is a good experience

S
SM 1211
10/12/2023 10:06:00 PM

hi everyone

A
A
10/2/2023 6:08:00 PM

waiting for the dump. please upload.

A
Anonymous
7/16/2023 11:05:00 AM

upload cks exam questions

J
Johan
12/13/2023 8:16:00 AM

awesome training material

AI Tutor 👋 I’m here to help!