COF-C03 Practice Question: Snowflake AI Data Cloud Features and Architecture
A Snowflake administrator needs to grant USAGE on a virtual warehouse named ANALYTICS_WH to a role named ANALYST_ROLE. Which SQL command accomplishes this?
⚠ Common exam trap
Watch out — candidates often confuse the USAGE privilege on a warehouse with privileges on databases or schemas, or assuming that OPERATE privilege is sufficient for query execution.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
GRANT USAGE ON WAREHOUSE ANALYTICS_WH TO ROLE ANALYST_ROLE;
To allow a role to use a virtual warehouse, you must grant the USAGE privilege on that warehouse to the role. The correct syntax uses GRANT USAGE ON WAREHOUSE <name> TO ROLE <role>. This enables the role to start the warehouse and execute queries. Other privileges like OPERATE or MODIFY are for administrative control, not query usage. The database and ALTER WAREHOUSE approaches are incorrect object types or commands.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
ALTER WAREHOUSE ANALYTICS_WH SET ROLE ANALYST_ROLE;
Why it's wrong here
ALTER WAREHOUSE is used to modify warehouse properties such as size, auto-suspend, or auto-resume. It cannot assign a role to a warehouse. Roles are granted privileges on warehouses, not set as properties. This command is syntactically invalid and would produce an error. It does not grant any access to the role.
- ✗
GRANT USAGE ON DATABASE ANALYTICS_WH TO ROLE ANALYST_ROLE;
Why it's wrong here
This command attempts to grant USAGE on a database named ANALYTICS_WH, but ANALYTICS_WH is a virtual warehouse, not a database. The object type DATABASE does not match the actual object. Snowflake would return an error because the database does not exist. Virtual warehouse privileges are granted using ON WAREHOUSE, not ON DATABASE.
- ✗
GRANT OPERATE ON WAREHOUSE ANALYTICS_WH TO ROLE ANALYST_ROLE;
Why it's wrong here
OPERATE privilege allows starting, stopping, and resizing a warehouse, but it does not permit running queries. The analyst role needs to execute queries, which requires USAGE privilege. OPERATE is typically granted to administrators. Without USAGE, the role cannot use the warehouse for query execution. Thus OPERATE alone does not fulfill the requirement.
- ✓
GRANT USAGE ON WAREHOUSE ANALYTICS_WH TO ROLE ANALYST_ROLE;
Why this is correct
This command grants the USAGE privilege on the virtual warehouse ANALYTICS_WH to the role ANALYST_ROLE. In Snowflake, roles require USAGE privilege on a warehouse to start it and run queries. The syntax GRANT privilege ON object_type object_name TO ROLE role_name is correct for virtual warehouses. This is the standard way to allow a role to use compute resources.
About these practice questions
Courseiva writes every COF-C03 question from scratch — 280 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Snowflake exam blueprint
This COF-C03 practice question is part of Courseiva's free Snowflake certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the COF-C03 exam.