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

SnowPro Core PDF — 1300 Questions

Which semi-structured file formats are supported when unloading data from a table? (Choose two.)

  1. ORC
  2. XML
  3. Avro
  4. Parquet
  5. JSON

Answer(s): D,E


Reference:

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



A running virtual warehouse is suspended.
What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

  1. 1 second
  2. 60 seconds
  3. 5 minutes
  4. 60 minutes

Answer(s): B



What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

  1. Authentication
  2. Resource management
  3. Virtual warehouse caching
  4. Query parsing and optimization
  5. Query execution
  6. Physical storage of micro-partitions

Answer(s): A,B,D



How long is the Fail-safe period for temporary and transient tables?

  1. There is no Fail-safe period for these tables.
  2. 1 day
  3. 7 days
  4. 31 days
  5. 90 days

Answer(s): A


Reference:

https://docs.snowflake.com/en/user-guide/tables-temp-transient.html



Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

  1. PUT
  2. GET
  3. COPY
  4. SELECT

Answer(s): B


Reference:

https://docs.snowflake.com/en/sql-reference/sql/get.html



How does Snowflake Fail-safe protect data in a permanent table?

  1. Fail-safe makes data available up to 1 day, recoverable by user operations.
  2. Fail-safe makes data available for 7 days, recoverable by user operations.
  3. Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.
  4. Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.

Answer(s): C



A virtual warehouse is created using the following command:

Create warehouse my_WH with -
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;

The image below is a graphical representation of the warehouse utilization across two days.


What action should be taken to address this situation?

  1. Increase the warehouse size from Medium to 2XL.
  2. Increase the value for the parameter MAX_CONCURRENCY_LEVEL.
  3. Configure the warehouse to a multi-cluster warehouse.
  4. Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

Answer(s): C



Which minimum Snowflake edition allows for a dedicated metadata store?

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

Answer(s): D


Reference:

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



Viewing page 21 of 139

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

R
Rohan Limaye
12/30/2023 8:52:00 AM

best to practice

Anonymous
A
Aparajeeta
10/13/2023 2:42:00 PM

so far it is good

Anonymous
V
Vgf
7/20/2023 3:59:00 PM

please provide me the dump

Anonymous
D
Deno
10/25/2023 1:14:00 AM

i failed the cisa exam today. but i have found all the questions that were on the exam to be on this site.

Anonymous
C
CiscoStudent
11/15/2023 5:29:00 AM

in question 272 the right answer states that an autonomous acces point is "configured and managed by the wlc" but this is not what i have learned in my ccna course. is this a mistake? i understand that lightweight aps are managed by wlc while autonomous work as standalones on the wlan.

Anonymous
P
pankaj
9/28/2023 4:36:00 AM

it was helpful

Anonymous
U
User123
10/8/2023 9:59:00 AM

good question

UNITED STATES
V
vinay
9/4/2023 10:23:00 AM

really nice

Anonymous
U
Usman
8/28/2023 10:07:00 AM

please i need dumps for isc2 cybersecuity

Anonymous
Q
Q44
7/30/2023 11:50:00 AM

ans is coldline i think

UNITED STATES
A
Anuj
12/21/2023 1:30:00 PM

very helpful

Anonymous
G
Giri
9/13/2023 10:31:00 PM

can you please provide dumps so that it helps me more

UNITED STATES
A
Aaron
2/8/2023 12:10:00 AM

thank you for providing me with the updated question and answers. this version has all the questions from the exam. i just saw them in my exam this morning. i passed my exam today.

SOUTH AFRICA
S
Sarwar
12/21/2023 4:54:00 PM

how i can see exam questions?

CANADA
C
Chengchaone
9/11/2023 10:22:00 AM

can you please upload please?

Anonymous
M
Mouli
9/2/2023 7:02:00 AM

question 75: option c is correct answer

Anonymous
J
JugHead
9/27/2023 2:40:00 PM

please add this exam

Anonymous
S
sushant
6/28/2023 4:38:00 AM

please upoad

EUROPEAN UNION
J
John
8/7/2023 12:09:00 AM

has anyone recently attended safe 6.0 certification? is it the samq question from here.

Anonymous
B
Blessious Phiri
8/14/2023 3:49:00 PM

expository experience

Anonymous
C
concerned citizen
12/29/2023 11:31:00 AM

52 should be b&c. controller failure has nothing to do with this type of issue. degraded state tells us its a raid issue, and if the os is missing then the bootable device isnt found. the only other consideration could be data loss but thats somewhat broad whereas b&c show understanding of the specific issues the question is asking about.

UNITED STATES
D
deedee
12/23/2023 5:10:00 PM

great help!!!

UNITED STATES
S
Samir
8/1/2023 3:07:00 PM

very useful tools

UNITED STATES
S
Saeed
11/7/2023 3:14:00 AM

looks a good platform to prepare az-104

Anonymous
M
Matiullah
6/24/2023 7:37:00 AM

want to pass the exam

Anonymous
S
SN
9/5/2023 2:25:00 PM

good resource

UNITED STATES
Z
Zoubeyr
9/8/2023 5:56:00 AM

question 11 : d

FRANCE
U
User
8/29/2023 3:24:00 AM

only the free dumps will be enough for pass, or have to purchase the premium one. please suggest.

Anonymous
C
CW
7/6/2023 7:37:00 PM

good questions. thanks.

Anonymous
F
Farooqi
11/21/2023 1:37:00 AM

good for practice.

INDIA
I
Isaac
10/28/2023 2:30:00 PM

great case study

UNITED STATES
M
Malviya
2/3/2023 9:10:00 AM

the questions in this exam dumps is valid. i passed my test last monday. i only whish they had their pricing in inr instead of usd. but it is still worth it.

INDIA
R
rsmyth
5/18/2023 12:44:00 PM

q40 the answer is not d, why are you giving incorrect answers? snapshot consolidation is used to merge the snapshot delta disk files to the vm base disk

IRELAND
K
Keny
6/23/2023 9:00:00 PM

thanks, very relevant

PERU
AI Tutor 👋 I’m here to help!