Chapter 2 of 5 · Snowflake SnowPro Core COF-C03
Account Management and Data Governance
Access control, roles, authentication, policies, replication, monitoring and credit usage.
- 8topics
- 40 minfast track
- 3diagrams and exhibits
- 20%of the exam
Topics in this chapter
Take them in order, or jump to the one you need.
- 1Security Model, RBAC and the Securable Object HierarchyHow Snowflake combines discretionary and role-based access control, how ownership and grants work, and how the securable object…5 min
- 2System-Defined, Functional and Secondary RolesKnow what ACCOUNTADMIN, SECURITYADMIN, USERADMIN, SYSADMIN and PUBLIC do, how account, database and custom roles differ, and how…Diagram5 min
- 3Authentication MethodsCompare Snowflake authentication options: passwords with MFA, federated authentication and SSO through SAML, Snowflake and…5 min
- 4Network Policies, Trust Center and Encryption KeysRestrict sign-ins with network rules and policies, find risks with Trust Center scanners, and know Snowflake key rotation…Diagram5 min
- 5Account Identifiers, Replication and FailoverRead Snowflake account identifiers and locators, replicate databases and account objects across regions, and plan failover groups…Diagram5 min
- 6Data Masking, Row Access, Tagging and Privacy PoliciesUse masking policies for column-level security, row access policies for row-level security, object tags to classify data and…5 min
- 7Logging, Tracing, Alerts, Notifications and LineageCapture logs and traces in event tables, run alerts on a schedule, send email, webhook and queue notifications, and follow data…5 min
- 8Resource Monitors, Credit Usage and ACCOUNT_USAGECap warehouse spend with resource monitors, track serverless cost with budgets, calculate warehouse credits per second and query…5 min
About this chapter
What this chapter covers
This chapter is 20% of the SnowPro Core COF-C03 exam. It tests whether you can secure a Snowflake account, govern the data inside it and keep its spend under control.
Expect short scenarios about "a Snowflake Practitioner" who must grant access, block a sign-in, hide a column, recover from a regional outage or stop a warehouse from overspending. Questions are single answer or multiple select, and multiple select questions tell you how many to pick.
How the topics fit together
Security comes first: who can get in, from where, and what they may touch. Governance then controls what the data shows to each role, and monitoring keeps the whole account visible and affordable.
- Security model and RBAC decide who owns objects and how privileges flow through roles.
- Roles separate system administration from job functions and from per-database access.
- Authentication proves identity with passwords plus MFA, SSO, OAuth or key pairs.
- Network policies, the Trust Center and encryption harden the account itself.
- Account identifiers and replication name accounts and keep data available across regions.
- Governance policies mask columns, filter rows, tag sensitive data and add privacy protection.
- Logging, alerts, notifications and lineage show what happened and who should know.
- Monitoring and cost cover resource monitors, credit math and the ACCOUNT_USAGE schema.
Many questions turn on edition. Masking, row access policies, tagging, ACCESS_HISTORY and lineage need Enterprise Edition or higher; failover and Tri-Secret Secure need Business Critical.
How to use these pages
Each topic page has the same shape, so you can skim for what you need.
- What it is: the idea in plain words.
- How it works: the mechanism, with diagrams, tables and examples.
- Common mistakes: the classic traps.
- What to remember for the exam: the facts to memorize.
- Check yourself: three questions to test your understanding.
Learn the defaults and the "who can do this" rules. The exam often asks which role, which edition or which view, and the wrong options are real features in the wrong place.
Ready for more practice?
The full Snowflake SnowPro Core COF-C03 question bank has 845 questions, with timed practice exams and an explanation for every answer.
This study guide is independent and is not affiliated with, endorsed by, or sponsored by Snowflake. Vendor names, certification names and exam codes are trademarks of their respective owners and are used for identification only.