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: 15)

SnowPro Core PDF — 1300 Questions

Which formats are supported for unloading data from Snowflake? (Choose two.)

  1. Delimited (CSV, TSV, etc.)
  2. Avro
  3. JSON
  4. ORC

Answer(s): A,C


Reference:

https://docs.snowflake.com/en/user-guide/data-unload-prepare.html



True or False: Data Providers can share data with only the Data Consumer.

  1. True
  2. False

Answer(s): B



The fail-safe retention period is how many days?

  1. 1 day
  2. 7 days
  3. 45 days
  4. 90 days

Answer(s): B


Reference:

https://docs.snowflake.com/en/user-guide/data-failsafe.html



True or False: Once created, a micro-partition will never be changed.

  1. True
  2. False

Answer(s): A


Reference:

https://interworks.com/blog/kbridges/2019/03/12/time-travel-with-snowflake/



What services does Snowflake automatically provide for customers that they may have been responsible for with their on-premise system? (Choose all that apply.)

  1. Installing and configuring hardware
  2. Patching software
  3. Physical security
  4. Maintaining metadata and statistics

Answer(s): A,B,D



Which of the following statements would be used to export/unload data from Snowflake?

  1. COPY INTO @stage
  2. EXPORT TO @stage
  3. INSERT INTO @stage
  4. EXPORT_TO_STAGE(stage => @stage, select => 'select * from t1');

Answer(s): A


Reference:

https://docs.snowflake.com/en/user-guide/data-unload-considerations.html



True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

  1. True
  2. False

Answer(s): A



How would you determine the size of the virtual warehouse used for a task?

  1. Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
  2. Querying (SELECT) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size
  3. If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first
  4. Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

Answer(s): C



Viewing page 15 of 139

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

E
Emmah
7/29/2023 9:59:00 AM

are these valid chfi questions

KENYA
M
Mort
10/19/2023 7:09:00 PM

question: 162 should be dlp (b)

EUROPEAN UNION
E
Eknath
10/4/2023 1:21:00 AM

good exam questions

INDIA
N
Nizam
6/16/2023 7:29:00 AM

I have to say this is really close to real exam. Passed my exam with this.

EUROPEAN UNION
P
poran
11/20/2023 4:43:00 AM

good analytics question

Anonymous
A
Antony
11/23/2023 11:36:00 AM

this looks accurate

INDIA
E
Ethan
8/23/2023 12:52:00 AM

question 46, the answer should be data "virtualization" (not visualization).

Anonymous
N
nSiva
9/22/2023 5:58:00 AM

its useful.

UNITED STATES
R
Ranveer
7/26/2023 7:26:00 PM

Pass this exam 3 days ago. The PDF version and the Xengine App is quite useful.

SOUTH AFRICA
S
Sanjay
8/15/2023 10:22:00 AM

informative for me.

UNITED STATES
T
Tom
12/12/2023 8:53:00 PM

question 134s answer shoule be "dlp"

JAPAN
A
Alex
11/7/2023 11:02:00 AM

in 72 the answer must be [sys_user_has_role] table.

Anonymous
F
Finn
5/4/2023 10:21:00 PM

i appreciated the mix of multiple-choice and short answer questions. i passed my exam this morning.

IRLAND
A
AJ
7/13/2023 8:33:00 AM

great to find this website, thanks

UNITED ARAB EMIRATES
C
Curtis Nakawaki
6/29/2023 9:11:00 PM

examination questions seem to be relevant.

UNITED STATES
U
Umashankar Sharma
10/22/2023 9:39:00 AM

planning to take psm test

Anonymous
E
ED SHAW
7/31/2023 10:34:00 AM

please allow to download

UNITED STATES
A
AD
7/22/2023 11:29:00 AM

please provide dumps

UNITED STATES
A
Ayyjayy
11/6/2023 7:29:00 AM

is the answer to question 15 correct ? i feel like the answer should be b

BAHRAIN
B
Blessious Phiri
8/12/2023 11:56:00 AM

its getting more technical

Anonymous
J
Jeanine J
7/11/2023 3:04:00 PM

i think these questions are what i need.

UNITED STATES
A
Aderonke
10/23/2023 2:13:00 PM

helpful assessment

UNITED KINGDOM
T
Tom
1/5/2024 2:32:00 AM

i am confused about the answers to the questions. do you know if the answers are correct?

KOREA REPUBLIC OF
V
Vinit N.
8/28/2023 2:33:00 AM

hi, please make the dumps available for my upcoming examination.

UNITED STATES
S
Sanyog Deshpande
9/14/2023 7:05:00 AM

good practice

UNITED STATES
T
Tyron
9/8/2023 12:12:00 AM

so far it is really informative

Anonymous
B
beast
7/30/2023 2:22:00 PM

hi i want it please please upload it

Anonymous
M
Mirex
5/26/2023 3:45:00 AM

am preparing for exam ,just nice questions

Anonymous
E
exampei
8/7/2023 8:05:00 AM

please upload c_tadm_23 exam

TURKEY
A
Anonymous
9/12/2023 12:50:00 PM

can we get tdvan4 vantage data engineering pdf?

UNITED STATES
A
Aish
10/11/2023 5:51:00 AM

want to clear the exam.

INDIA
S
Smaranika
6/22/2023 8:42:00 AM

could you please upload the dumps of sap c_sac_2302

INDIA
B
Blessious Phiri
8/15/2023 1:56:00 PM

asm management configuration is about storage

Anonymous
L
Lewis
7/6/2023 8:49:00 PM

kool thumb up

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