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 two access control models are combined in Snowflake's security architecture?

Discretionary Access Control (DAC) and Role-Based Access Control (RBAC) — Snowflake combines DAC (where each object has an owner who can grant privileges) and RBAC (where privileges are assigned to roles, and roles to users).

To query a table (`my_db.my_schema.orders`), what minimum privileges are required by the querying role?

`USAGE` on `my_db`, `USAGE` on `my_schema`, and `SELECT` on `orders` — Snowflake requires USAGE privilege on all container objects (database and schema) in addition to the specific object privilege (SELECT on the table).

What is the primary difference between a Standard Schema and a Managed Access Schema (`WITH MANAGED ACCESS`)?

In a standard schema, object owners can grant privileges on their objects. In a managed access schema, only the schema owner role can grant privileges. — Managed access schemas centralize privilege management with the schema owner, preventing object owners from creating unmanaged access grants.

Domain: Account Management & Governance (Pro Study Module)

September 2026 · 511 words · 10 min read

RBAC and DAC Access Control

Overview

Snowflake utilizes a hybrid security model that combines Role-Based Access Control (RBAC) and Discretionary Access Control (DAC). Understanding how privileges are granted, inherited, and managed is essential for the exam.

Key Concepts

Role-Based Access Control (RBAC)

In RBAC, privileges are granted to roles, and roles are granted to users. Users inherit the privileges of the roles they are assigned.

Discretionary Access Control (DAC)

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