Snowflake SnowPro® Core Certification 2026 Exam (COF-C03) - COF-C03 Exam Questions

A. Nodes by execution time B. Operator tree C. Most expensive nodes D. Table pruning

A. True B. False

A. They are a type of User-defined Function (UDF). B. They contain their own SQL code. C. They can return multiple rows for each row received D. They call code that is stored inside of Snowflake.

A. Define listing access B. Publish a listing C. Create a listing D. Browse exchange listings E. Consume datasets

A. Avro B. JSON C. Parquet D. CSV

A. select * from ORDERS limit 10; B. select * from ORDERS fetch 10; C. select * from ORDERS tablesample (10 rows); D. select * from ORDERS sample (10);

A. DESCRIBE NETWORK POLICY B. SHOW SESSION POLICIES C. DESCRIBE SESSION POLICY D. SHOW NETWORK POLICIES

A. PUBLIC B. SYSADMIN C. USERADMIN D. ORGADMIN E. SECURITYADMIN

A. EVENT_USAGE_HISTORY B. QUERY_HISTORY C. ACCESS_HISTORY D. OBJECT_DEPENDENCIES

A. Partitions scanned and Partitions total B. Bytes read from result and Bytes written to result C. Number of rows inserted and Number of rows updated D. Bytes spilled to local storage and Bytes spilled to remote storage

A. Configuration file profiles B. Authentication delegation C. Environment variables D. OAuth with a refresh token

A. Auto-suspend B. Resource monitor C. Scaling policy D. Budgets