What is the passing score for the Snowflake SnowPro Core exam?

The SnowPro Core (COF-C03) certification exam passing score is 750 or higher on a scaled score range of 0 to 1000.

Is CloudPrep affiliated with Snowflake Inc.?

No. Snowflake® and SnowPro® are registered trademarks of Snowflake Inc. CloudPrep is an independent educational platform and is not affiliated with, sponsored by, or endorsed by Snowflake Inc.

What is the primary purpose of Secondary Roles in Snowflake?

Allowing a user's session to combine privileges from all granted roles simultaneously for authorization (read/DML) without requiring manual role-switching — Secondary roles aggregate permissions from all roles granted to the user, allowing queries that join tables across disparate roles in a single SQL statement.

Which SQL statement activates all granted secondary roles in the current session?

`USE SECONDARY ROLES ALL;` — `USE SECONDARY ROLES ALL;` activates all roles granted to the current user as active secondary roles.

When `USE SECONDARY ROLES ALL;` is active and a user executes `CREATE TABLE my_table ...`, which role owns the newly created table?

Strictly the currently active Primary Role (`CURRENT_ROLE()`). — While secondary roles aggregate privileges for read and DML authorization, object creation and OWNERSHIP are strictly assigned to the Primary Role.

Domain: Account Management & Governance (Pro Study Module)

September 2026 · 787 words · 10 min read

Secondary Roles

Overview

Role-Based Access Control (RBAC) is central to Snowflake security. While users operate under a primary active role, Snowflake provides the concept of Secondary Roles. This feature allows users to perform SQL actions on objects that they have been granted privileges on via any of their granted roles, without needing to constantly switch their active role.

Key Concepts

Primary Role vs. Secondary Roles

Primary Role: When a user logs in, they have a single *current* or *primary* role (accessible via CURRENT_ROLE()). By default, all objects created during the session are owned by this primary role.

Unlock Full Deep-Dive Guide & 14 Practice MCQs

This complete architectural module, full checkpoint quiz, and unlimited mock exam simulations are included with the CloudPrep Pro Pass.

Unlock with Pro Pass