Snowflake SnowPro Core SnowPro Core Dumps in PDF

Free Snowflake SnowPro Core Real Questions (page: 22)

Network policies can be set at which Snowflake levels? (Choose two.)

  1. Role
  2. Schema
  3. User
  4. Database
  5. Account
  6. Tables

Answer(s): C,E


Reference:

https://docs.snowflake.com/en/user-guide/network-policies.html#creating-network-policies



What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

  1. Default Time Travel Retention is set to 0 days.
    Maximum Time Travel Retention is 30 days.
    Fail Safe retention time is 1 day.
  2. Default Time Travel Retention is set to 1 day.
    Maximum Time Travel Retention is 365 days.
    Fail Safe retention time is 7 days.
  3. Default Time Travel Retention is set to 0 days.
    Maximum Time Travel Retention is 90 days.
    Fail Safe retention time is 7 days.
  4. Default Time Travel Retention is set to 1 day.
    Maximum Time Travel Retention is 90 days.
    Fail Safe retention time is 7 days.
  5. Default Time Travel Retention is set to 7 days.
    Maximum Time Travel Retention is 1 day.
    Fail Safe retention time is 90 days.
  6. Default Time Travel Retention is set to 90 days.
    Maximum Time Travel Retention is 7 days.
    Fail Safe retention time is 356 days.

Answer(s): D



Which of the following objects are contained within a schema? (Choose two.)

  1. Role
  2. Stream
  3. Warehouse
  4. External table
  5. User
  6. Share

Answer(s): B,D



Which of the following statements describe features of Snowflake data caching? (Choose two.)

  1. When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
  2. When the data cache is full, the least-recently used data will be cleared to make room.
  3. A user can only access their own queries from the query result cache.
  4. A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
  5. The RESULT_SCAN table function can access and filter the contents of the query result cache.

Answer(s): B,E



A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size S is being used. The following COPY INTO command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)

The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.

How can this issue be resolved?

  1. Compress the file and load the compressed file.
  2. Split the file into multiple files in the recommended size range (100 MB - 250 MB).
  3. Use a larger-sized warehouse.
  4. Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.

Answer(s): D



What is a feature of a stored procedure in Snowflake?

  1. They can be created as secure and hide the underlying metadata from all users.
  2. They can access tables from a single database.
  3. They can only contain a single SQL statement.
  4. They can be created to run with a caller's rights or an owner's rights.

Answer(s): A


Reference:

https://docs.snowflake.com/en/sql-reference/stored-procedures-overview.html



Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

  1. CONTENT
  2. PATH
  3. BYTE_SIZE
  4. INDEX
  5. DATATYPE

Answer(s): B,D



What is the minimum Snowflake edition required to create a materialized view?

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

Answer(s): B



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

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

P
PC
7/28/2023 3:49:00 PM

where is dump

Y
YoloStar Yoloing
10/22/2023 9:58:00 PM

q. 289 - the correct answer should be b not d, since the question asks for the most secure way to provide access to a s3 bucket (a single one), and by principle of the least privilege you should not be giving access to all buckets.

AI Tutor 👋 I’m here to help!