SnowPro-Core Free Practice Test

- (Exam Topic 1)
True or False: When data share is established between a Data Provider and a data Consumer, the Data Consumer can extend that data share to other Data Consumers.

1. A. True
2. B. False

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

- (Exam Topic 3)
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

1. A. 4
2. B. 8
3. C. 16
4. D. 32

Correct Answer: B
Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:

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

- (Exam Topic 1)
Which of the following statement is true of Snowflake? Select one.

1. A. It was built specifically for the cloud
2. B. it was built as an on-premises solution and then potted to the cloud
3. C. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
4. D. It was built for Hadoop architecture
5. E. It's based on an Oracle Architecture

Correct Answer: A

- (Exam Topic 1)
Which statements are true of micro-partitions? Choose 2 answers

1. A. They are approximately 16MB in size
2. B. They are stored compressed only if COMPRESS=TRUE on Table
3. C. They are Immutable
4. D. They are only encrypted in the Enterprise edition and above

Correct Answer: AC
Reference: https://medium.com/weareservian/seeing-snow-for-the-first-time-snowflake-adventures-part-1- 731ddc983c69

- (Exam Topic 3)
Which data types are supported by Snowflake when using semi-structured data? (Choose two.)

1. A. VARIANT
2. B. VARRAY
3. C. STRUCT
4. D. ARRAY
5. E. QUEUE

Correct Answer: AD