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.

Which system-defined role is dedicated to user and role creation in Snowflake?

USERADMIN — USERADMIN is dedicated strictly to creating and managing users and roles. It holds the `CREATE USER` and `CREATE ROLE` privileges globally.

How does SECURITYADMIN relate to USERADMIN in Snowflake's default role hierarchy?

SECURITYADMIN inherits USERADMIN and holds MANAGE GRANTS privilege. — SECURITYADMIN inherits USERADMIN in the system hierarchy and holds the global `MANAGE GRANTS` privilege to grant/revoke any privilege on any object.

What is the primary operational scope of the `SYSADMIN` role in Snowflake?

Creating and managing virtual warehouses, databases, schemas, and other business data objects — SYSADMIN is the system administrator for business compute and storage objects (databases, schemas, tables, warehouses). Custom operational roles should roll up to SYSADMIN.

Domain: Account Management & Governance (Pro Study Module)

September 2026 · 514 words · 10 min read

User and Role Management

Overview

Role-Based Access Control (RBAC) is the core of Snowflake's security model. Understanding how users are created, properties assigned, and how roles interact in a hierarchy is a major part of the COF-C03 exam.

Key Concepts

Users and User Properties

Users are entities that connect to Snowflake. They can be individuals or service accounts.

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