How is the credit quota applied in a resource monitor?

It is applied over a defined time interval such as daily, weekly, or monthly

It is applied only when the warehouse is suspended

It is applied per query execution

A Snowflake administrator needs to determine the current credit usage of a specific warehouse to decide whether to increase its resource monitor's quota. Which Snowflake view should the administrator query?

INFORMATION_SCHEMA.QUERY_HISTORY

INFORMATION_SCHEMA.RESOURCE_MONITORS

ACCOUNT_USAGE.RESOURCE_MONITOR_USAGE

INFORMATION_SCHEMA.WAREHOUSE_METERING_HISTORY

A Snowflake administrator needs to set up a resource monitor that will send an email notification to two different teams when usage reaches 80% of the quota. The administrator has created the monitor and set the notify action at 80%. What is required to ensure both teams receive the email?

Create a notification integration and link it to the resource monitor.

Set up a distribution list email address and add it to the notification list.

Create two separate resource monitors, one for each team, with the same quota and threshold.

Add both teams' email addresses to the notification list of the resource monitor.

How can a resource monitor be associated with a virtual warehouse?

By setting the warehouse size in the resource monitor

By using the ALTER WAREHOUSE command with the RESOURCE_MONITOR parameter

By creating a new database and linking it to the warehouse

By granting the warehouse to the resource monitor

What is a best practice for using resource monitors to control costs?

Set up multiple resource monitors for different teams or workloads

Disable resource monitors after setting them up

Set quotas to unlimited to avoid interruptions

Use a single resource monitor for the entire account without exceptions

SnowPro® Core Certification

Domain 3Objective 2

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

Part of the Account Management and Data Governance domain, which accounts for 20% of the COF-C03 exam.

19questions here

4free pages

8concepts

20%of the exam

Questions 1–5

1foundation · easy
How is the credit quota applied in a resource monitor?
Select an answer first
2application · medium
A Snowflake administrator needs to determine the current credit usage of a specific warehouse to decide whether to increase its resource monitor's quota. Which Snowflake view should the administrator query?
Select an answer first
3expert · medium
A Snowflake administrator needs to set up a resource monitor that will send an email notification to two different teams when usage reaches 80% of the quota. The administrator has created the monitor and set the notify action at 80%. What is required to ensure both teams receive the email?
Select an answer first
4foundation · easy
How can a resource monitor be associated with a virtual warehouse?
Select an answer first
5foundation · easy
What is a best practice for using resource monitors to control costs?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to COF-C03

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Snowflake. “COF-C03” is a trademark of its owner, used for identification only.