Configure Resource Monitors and Cost Controls COF-C03 Practice Questions (Page 4)

Questions 16–19

1. 16foundation · easy

   What does the 'suspend immediately' action do in a resource monitor?

   • ASends an email notification without suspending the warehouse
   • BDrops the warehouse permanently
   • CSuspends the warehouse after all running queries complete
   • DSuspends the warehouse as soon as the threshold is reached, even if queries are running
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   What is the purpose of alert thresholds in a resource monitor?

   • ATo increase the warehouse size automatically
   • BTo manage user access to warehouses
   • CTo monitor query performance metrics
   • DTo trigger actions when credit usage reaches a specified percentage of the quota
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   Why is scheduling important when configuring resource monitors?

   • ATo automatically scale warehouses up and down
   • BTo increase warehouse performance during peak hours
   • CTo schedule backups of the warehouse data
   • DTo align quota resets with business cycles such as monthly billing
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   Which SQL command is used to create a resource monitor in Snowflake?

   • ACREATE POLICY
   • BCREATE NOTIFICATION
   • CCREATE WAREHOUSE
   • DCREATE RESOURCE MONITOR
   Reveal Solution Discussion Select an answer first