Free SnowPro-Core Exam Dumps

Question 21

- (Exam Topic 1)
True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

A. True
B. False

Correct Answer:A
Reference: https://blog.ippon.tech/innovative-snowflake-features-caching/

Question 22

- (Exam Topic 1)
How many shares can be consumed by single Data Consumer?

A. 1
B. 10
C. 100, but can be increased by contacting support
D. Unlimited

Correct Answer:D
Reference: https://docs.snowflake.com/en/user-guide/data-sharing-intro.html

Question 23

- (Exam Topic 2)
What features does Snowflake Time Travel enable?

A. Querying data-related objects that were created within the past 365 days
B. Restoring data-related objects that have been deleted within the past 90 days
C. Conducting point-in-time analysis for Bl reporting
D. Analyzing data usage/manipulation over all periods of time

Correct Answer:B
Snowflake Time Travel enables accessing historical data (i.e. data that has been changed or deleted) at any point within a defined period. It serves as a powerful tool for performing the following tasks:
SnowPro-Core dumps exhibit Restoring data-related objects (tables, schemas, and databases) that might have been accidentally or intentionally deleted.
Duplicating and backing up data from key points in the past.
Analyzing data usage/manipulation over specified periods of time.
https://docs.snowflake.com/en/user-guide/data-time-travel.html

Question 24

- (Exam Topic 3)
Using variables in Snowflake is denoted by using which SQL character?

A. @
B. &
C. $
D. #

Correct Answer:C

Question 25

- (Exam Topic 3)
Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

A. Configure the user to be initially disabled.
B. Force an immediate password change.
C. Set a default role for the user.
D. Set the number of minutes to unlock to 15 minutes.
E. Set the user's access to expire within a specified timeframe.

Correct Answer:AE