SnowPro-Core Free Practice Test

- (Exam Topic 3)
When should a multi-cluster warehouse be used in auto-scaling mode?

1. A. When it is unknown how much compute power is needed
2. B. If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
3. C. If the runtime of the executed query is very slow
4. D. When a large number of concurrent queries are run on the same warehouse

Correct Answer: D

- (Exam Topic 3)
Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

1. A. Cloud services layer
2. B. Compute layer
3. C. Storage layer
4. D. Cloud agnostic layer

Correct Answer: B
Reference: https://www.projectpro.io/article/snowflake-architecture-what-does-snowflake-do/556

- (Exam Topic 1)
Increasing the size of a Virtual Warehouse from an X-Small to an X-Large is an example of:

1. A. Scaling rhythmically
2. B. Scaling max
3. C. Scaling out
4. D. Scaling up

Correct Answer: D

- (Exam Topic 3)
A user is preparing to load data from an external stage
Which practice will provide the MOST efficient loading performance?

1. A. Organize files into logical paths
2. B. Store the files on the external stage to ensure caching is maintained
3. C. Use pattern matching for regular expression execution
4. D. Load the data in one large file

Correct Answer: D

- (Exam Topic 1)
When should you consider disabling auto-suspend for a Virtual Warehouse? Choose 2 answers

1. A. When users will be using compute at different times throughout a 24/7 period
2. B. When managing a steady workload
3. C. When the compute must be available with no delay or lag time
4. D. When you don’t want to have to manually turn on the Warehouse each time a user needs it

Correct Answer: BC
Reference: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html