Snowflake SnowPro Core SnowPro Core Exam Questions in PDF

Free Snowflake SnowPro Core Dumps Questions (page: 13)

What is the lowest Snowflake edition that offers Time Travel up to 90 days?

  1. Standard Edition
  2. Premier Edition
  3. Enterprise Edition
  4. Business Critical Edition

Answer(s): C


Reference:

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



Which of the following statements are true about Schemas in Snowflake? (Choose two.)

  1. A Schema may contain one or more Databases
  2. A Database may contain one or more Schemas
  3. A Schema is a logical grouping of Database Objects
  4. Each Schema is contained within a Warehouse

Answer(s): B,C


Reference:

https://docs.snowflake.com/en/user-guide/data-sharing-mutiple-db.html



True or False: You can resize a Virtual Warehouse while queries are running.

  1. True
  2. False

Answer(s): A


Reference:

https://docs.snowflake.com/en/user-guide/warehouses-tasks.html



What is the most granular object that the Time Travel retention period can be defined on?

  1. Account
  2. Database
  3. Schema
  4. Table

Answer(s): D



Which of the following statements is true of Snowflake micro-partitioning?

  1. Micro-partitioning has been known to introduce data skew
  2. Micro-partitioning: requires a partitioning schema to be defined up front
  3. Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded
  4. Micro-partitioning can be disabled within a Snowflake account

Answer(s): C


Reference:

https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html



True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started.

  1. True
  2. False

Answer(s): B


Reference:

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



When scaling up Virtual Warehouses by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:

  1. Concurrency
  2. Performance

Answer(s): B


Reference:

https://docs.snowflake.com/en/user-guide/warehouses-considerations.html#warehouse-resizing-improves-performance



As a best practice, clustering keys should only be defined on tables of which minimum size?

  1. Multi-Kilobyte (KB) Range
  2. Multi-Megabyte (MB) Range
  3. Multi-Gigabyte (GB) Range
  4. Multi-Terabyte (TB) Range

Answer(s): D


Reference:

https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html



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

B
Boopathy
8/17/2023 1:03:00 AM

i need this dump kindly upload it

S
s_123
8/12/2023 4:28:00 PM

do we need c# coding to be az204 certified

B
Blessious Phiri
8/15/2023 3:38:00 PM

excellent topics covered

M
Manasa
12/5/2023 3:15:00 AM

are these really financial cloud questions and answers, seems these are basic admin question and answers

N
Not Robot
5/14/2023 5:33:00 PM

are these comments real

K
kriah
9/4/2023 10:44:00 PM

please upload the latest dumps

E
ed
12/17/2023 1:41:00 PM

a company runs its workloads on premises. the company wants to forecast the cost of running a large application on aws. which aws service or tool can the company use to obtain this information? pricing calculator ... the aws pricing calculator is primarily used for estimating future costs

M
Muru
12/29/2023 10:23:00 AM

looks interesting

T
Tech Lady
10/17/2023 12:36:00 PM

thanks! that’s amazing

M
Mike
8/20/2023 5:12:00 PM

the exam dumps are helping me get a solid foundation on the practical techniques and practices needed to be successful in the auditing world.

N
Nobody
9/18/2023 6:35:00 PM

q 14 should be dmz sever1 and notepad.exe why does note pad have a 443 connection

M
Muhammad Rawish Siddiqui
12/4/2023 12:17:00 PM

question # 108, correct answers are business growth and risk reduction.

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

are these valid chfi questions

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

question: 162 should be dlp (b)

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

good exam questions

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.

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

good analytics question

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

this looks accurate

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

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

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

its useful.

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.

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

informative for me.

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

question 134s answer shoule be "dlp"

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

in 72 the answer must be [sys_user_has_role] table.

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.

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

great to find this website, thanks

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

examination questions seem to be relevant.

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

planning to take psm test

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

please allow to download

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

please provide dumps

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

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

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

its getting more technical

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

i think these questions are what i need.

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

helpful assessment

AI Tutor 👋 I’m here to help!