SnowPro Core Virtual Warehouse Management

1. A warehouse with 4 credits/hour runs 3 concurrent queries. How many credits does each query consume per hour?

1.33 credits

2 credits

4 credits

12 credits

2. What is the primary advantage of setting auto-suspend to a short interval for development environments?

Improves query performance

Reduces unnecessary credit consumption

Increases warehouse capacity

Prevents query queuing

Submit

4. Which of the following best describes aggressive scaling in warehouse management?

Scales up quickly, scales down slowly

Scales up slowly, scales down quickly

Scales up and down at the same rate

Disables auto-scaling entirely

5. True or False: You can use resource monitors to set credit quotas and suspend warehouses when limits are exceeded.

True

False

Submit

7. What occurs when you resize a warehouse to a larger size while it is running?

Current queries are paused

New size applies only to future queries

All connections are dropped

Warehouse restarts automatically

8. Which warehouse size is recommended for light exploratory queries and ad-hoc analysis?

XSmall (1 credit/hour)

Small (2 credits/hour)

Medium (4 credits/hour)

Large (8 credits/hour)

9. True or False: A suspended warehouse consumes credits when no queries are running.

True

False

Submit

11. What is the minimum number of credits consumed per second when a virtual warehouse is running?

0.5 credits

1 credit

2 credits

5 credits

12. What is the primary benefit of using economy scaling over standard scaling?

Faster query execution

Lower credit consumption

Higher warehouse capacity

Reduced latency

13. Which feature allows you to define rules for automatically scaling warehouse resources based on query queue depth?

Auto-scaling policy

Dynamic warehouse resizing

Compute pool management

Resource monitors

14. True or False: Resizing a warehouse requires all active sessions to be terminated first.

True

False

15. What is the default auto-suspend time for a virtual warehouse in Snowflake?

5 minutes

10 minutes

30 minutes

60 minutes

16. Which scaling policy is best for predictable, steady workloads with consistent query patterns?

Economy scaling

Standard scaling

Aggressive scaling

Manual scaling

Submit

18. What happens when a query exceeds the warehouse's memory capacity during execution?

Query automatically scales up the warehouse

Query is terminated immediately

Query spills to disk storage

Warehouse automatically increases credits

19. A virtual warehouse with 8 credits per hour is running for 15 minutes. How many credits are consumed?

1 credit

2 credits

3 credits

4 credits

20. Which auto-scaling policy automatically suspends the warehouse after a period of inactivity?

Economy scaling

Standard scaling

Auto-suspend policy

Aggressive scaling

SnowPro Core Virtual Warehouse Management Quiz

1. A warehouse with 4 credits/hour runs 3 concurrent queries. How many credits does each query consume per hour?

2.

What first name or nickname would you like us to use?

2. What is the primary advantage of setting auto-suspend to a short interval for development environments?

3. A 6XL warehouse (48 credits/hour) runs for 45 minutes. Total credits consumed equals ____.

4. Which of the following best describes aggressive scaling in warehouse management?

5. True or False: You can use resource monitors to set credit quotas and suspend warehouses when limits are exceeded.

6. The maximum number of scaling actions per hour for auto-scaling is limited to prevent ____ spikes.

7. What occurs when you resize a warehouse to a larger size while it is running?

8. Which warehouse size is recommended for light exploratory queries and ad-hoc analysis?

9. True or False: A suspended warehouse consumes credits when no queries are running.

10. The ____ parameter controls the maximum number of seconds a warehouse waits before auto-suspending.

11. What is the minimum number of credits consumed per second when a virtual warehouse is running?

12. What is the primary benefit of using economy scaling over standard scaling?

13. Which feature allows you to define rules for automatically scaling warehouse resources based on query queue depth?

14. True or False: Resizing a warehouse requires all active sessions to be terminated first.

15. What is the default auto-suspend time for a virtual warehouse in Snowflake?

16. Which scaling policy is best for predictable, steady workloads with consistent query patterns?

17. In Snowflake, the maximum number of warehouse sizes available is ____.

18. What happens when a query exceeds the warehouse's memory capacity during execution?

19. A virtual warehouse with 8 credits per hour is running for 15 minutes. How many credits are consumed?

20. Which auto-scaling policy automatically suspends the warehouse after a period of inactivity?