SnowPro-Core Free Practice Test

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

1. A. VARCHAR
2. B. RAW
3. C. LOB
4. D. VARIANT

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

- (Exam Topic 3)
What is the purpose of multi-cluster virtual warehouses?

1. A. To create separate data warehouses to increase query optimization
2. B. To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
3. C. To eliminate or reduce Queuing of concurrent queries
4. D. To allow the warehouse to resize automatically

Correct Answer: C
https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html#:~:text=Multi-cluster warehous

- (Exam Topic 1)
What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

1. A. Standard
2. B. Premier
3. C. Enterprise
4. D. Business Critical Edition

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

- (Exam Topic 3)
For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

1. A. CHECK_OPTION
2. B. IS_SECURE
3. C. IS_UPDATEABLE
4. D. TABLE_NAME

Correct Answer: B

- (Exam Topic 1)
Which statement best describes Snowflake tables?

1. A. Snowflake tables are logical representations of underlying physical data
2. B. Snowflake tables ate the physical instantiation of data loaded Into Snowflake
3. C. Snowflake tables require that clustering keys be defined to perform optimally
4. D. Snowflake tables are owned by a user

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