SnowPro-Core Snowflake Exam Questions and Free Practice Test

- (Exam Topic 1)
What are the three things customers want most from their enterprise data warehouse solution? Choose 3 answers

A. On-premise availability

B. Simplicity

C. Open source based

D. Concurrency

E. Performance

Correct Answer:BDE

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

A. @

B. &

C. $

D. #

Correct Answer:C

- (Exam Topic 2)
Will data cached in a warehouse be lost when the warehouse is resized?

A. Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

B. Ye

C. because the compute resource is replaced in its entirety with a new compute resource.

D. N

E. because the size of the cache is independent from the warehouse size

F. Ye

G. became the new compute resource will no longer have access to the cache encryption key

Correct Answer:A

- (Exam Topic 1)
What is the recommended Snowflake data type to store semi-structured data like JSON?

A. VARCHAR

B. RAW

C. LOB

D. VARIANT

Correct Answer:D
Reference: https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html

- (Exam Topic 1)
True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

A. True

B. False

Correct Answer:A
Reference: https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html

- (Exam Topic 3)
Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

A. Bytes sent over network

B. Percentage scanned from cache

C. Partitions total

D. Bytes spilled to local storage

E. Partitions scanned

Correct Answer:BE

START SnowPro-Core EXAM