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 SnowPro Core Exam Questions in PDF

Free Snowflake SnowPro Core Dumps Questions (page: 22)

SnowPro Core PDF — 1300 Questions

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



Viewing page 22 of 139

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

A
Anonymus
11/9/2023 5:41:00 AM

anyone who wrote this exam recently?

SOUTH AFRICA
K
Khalid Javid
11/17/2023 3:46:00 PM

kindly share the dump

Anonymous
N
Na
8/9/2023 8:39:00 AM

could you please upload cfe fraud prevention and deterrence questions? it will be very much helpful.

Anonymous
S
shime
10/23/2023 10:03:00 AM

this is really very very helpful for mcd level 1

ETHIOPIA
V
Vnu
6/3/2023 2:39:00 AM

very helpful!

Anonymous
S
Steve
8/17/2023 2:19:00 PM

question #18s answer should be a, not d. this should be corrected. it should be minvalidityperiod

CANADA
R
RITEISH
12/24/2023 4:33:00 AM

thanks for the exact solution

Anonymous
S
SB
10/15/2023 7:58:00 AM

need to refer the questions and have to give the exam

INDIA
M
Mike Derfalem
7/16/2023 7:59:00 PM

i need it right now if it was possible please

Anonymous
I
Isak
7/6/2023 3:21:00 AM

i need it very much please share it in the fastest time.

Anonymous
M
Maria
6/23/2023 11:40:00 AM

correct answer is d for student.java program

IRELAND
N
Nagendra Pedipina
7/12/2023 9:10:00 AM

q:37 c is correct

INDIA
J
John
9/16/2023 9:37:00 PM

q6 exam topic: terramearth, c: correct answer: copy 1petabyte to encrypted usb device ???

GERMANY
S
SAM
12/4/2023 12:56:00 AM

explained answers

INDIA
A
Andy
12/26/2023 9:35:00 PM

plan to take theaws certified developer - associate dva-c02 in the next few weeks

SINGAPORE
S
siva
5/17/2023 12:32:00 AM

very helpfull

Anonymous
M
mouna
9/27/2023 8:53:00 AM

good questions

Anonymous
B
Bhavya
9/12/2023 7:18:00 AM

help to practice csa exam

Anonymous
M
Malik
9/28/2023 1:09:00 PM

nice tip and well documented

Anonymous
R
rodrigo
6/22/2023 7:55:00 AM

i need the exam

Anonymous
D
Dan
6/29/2023 1:53:00 PM

please upload

Anonymous
A
Ale M
11/22/2023 6:38:00 PM

prepping for fsc exam

AUSTRALIA
A
ahmad hassan
9/6/2023 3:26:00 AM

pd1 with great experience

Anonymous
Ž
Žarko
9/5/2023 3:35:00 AM

@t it seems like azure service bus message quesues could be the best solution

UNITED KINGDOM
S
Shiji
10/15/2023 1:08:00 PM

helpful to check your understanding.

INDIA
D
Da Costa
8/27/2023 11:43:00 AM

question 128 the answer should be static not auto

Anonymous
B
bot
7/26/2023 6:45:00 PM

more comments here

UNITED STATES
K
Kaleemullah
12/31/2023 1:35:00 AM

great support to appear for exams

Anonymous
B
Bsmaind
8/20/2023 9:26:00 AM

useful dumps

Anonymous
B
Blessious Phiri
8/13/2023 8:37:00 AM

making progress

Anonymous
N
Nabla
9/17/2023 10:20:00 AM

q31 answer should be d i think

FRANCE
V
vladputin
7/20/2023 5:00:00 AM

is this real?

UNITED STATES
N
Nick W
9/29/2023 7:32:00 AM

q10: c and f are also true. q11: this is outdated. you no longer need ownership on a pipe to operate it

Anonymous
N
Naveed
8/28/2023 2:48:00 AM

good questions with simple explanation

UNITED STATES
AI Tutor 👋 I’m here to help!