Study guide

3.3 Scenario Practice for Account Management and Data Governance

SnowPro Core Study Guide Exam

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: SnowPro Core Orientation and Exam Strategy

1.1 Current SnowPro Core Exam Facts 1.2 Eligibility, Registration, and Scheduling 1.3 Blueprint Domains and Weighting 1.4 Editions, Question Style, and Score Report Thinking 1.5 Study Calendar and Hands-On Practice Plan

2 Chapter 2: Snowflake AI Data Cloud Features and Architecture

2.1 Snowflake AI Data Cloud Features and Architecture Overview 2.2 Core Workflows and Decision Points 2.3 Scenario Practice for Snowflake AI Data Cloud Features and Architecture 2.4 Common Traps in Snowflake AI Data Cloud Features and Architecture 2.5 Practice Drills and Readiness Markers

3 Chapter 3: Account Management and Data Governance

3.1 Account Management and Data Governance Overview 3.2 Core Workflows and Decision Points 3.3 Scenario Practice for Account Management and Data Governance 3.4 Common Traps in Account Management and Data Governance 3.5 Practice Drills and Readiness Markers

4 Chapter 4: Data Loading, Unloading, and Connectivity

4.1 Data Loading, Unloading, and Connectivity Overview 4.2 Core Workflows and Decision Points 4.3 Snowpipe, External Tables, and Storage Integrations 4.4 Bulk Unloading and Semi-Structured Data 4.5 Connectors, Drivers, and Snowsight Loading

5 Chapter 5: Performance Optimization, Querying, and Transformation

5.1 Performance Optimization, Querying, and Transformation Overview 5.2 Core Workflows and Decision Points 5.3 Micro-Partitions, Pruning, Clustering, and the Query Profile 5.4 Search Optimization, Materialized Views, and Query Best Practices 5.5 Transformations: ELT, Streams & Tasks, and Semi-Structured Data

6 Chapter 6: Data Collaboration

6.1 Secure Data Sharing Architecture 6.2 Creating Shares, Granting Objects, and Reader Accounts 6.3 Snowflake Marketplace, Listings, and Data Exchange 6.4 Secure Views, Cross-Region Sharing, and Governance 6.5 Choosing the Right Sharing Method and Readiness Drills

7 Chapter 7: Final Review and Test Day

7.1 Timed Practice Strategy 7.2 Last-Week Review Map 7.3 Exam-Day Checklist 7.4 After the Exam and Next Steps

3.3 Scenario Practice for Account Management and Data Governance

Key Takeaways Explain This Topic AI

Snowflake supports MFA (passkey, authenticator app, or Duo), key-pair authentication for programmatic access, SSO via SAML 2.0 federation, and OAuth (Snowflake OAuth and External OAuth).

Network policies restrict access by IP using allowed and blocked lists; blocked ranges take precedence over allowed ranges.

Key-pair authentication uses an RSA key pair (often 2048-bit) and supports key rotation with RSA_PUBLIC_KEY and RSA_PUBLIC_KEY_2.

SCIM can be used with an identity provider to automatically provision and de-provision users and roles.

Always pick the least-privileged, policy-compliant authentication or access workflow the scenario actually requires.

Last updated: October 2026

Authentication Methods

Users and service accounts authenticate to Snowflake in several ways, and the exam tests which method fits which scenario.

Method Best for Key facts

Password + MFA Interactive human users MFA methods are passkeys (recommended), authenticator apps (TOTP), or Duo; enrolled per user; enforce for ACCOUNTADMIN.

Key-pair authentication Programmatic / service accounts, drivers Uses an RSA key pair ; public key stored on the user with RSA_PUBLIC_KEY .

SSO (federated) Enterprise users via an IdP Uses SAML 2.0 ; Snowflake is the service provider, the IdP (Okta, ADFS, etc.) authenticates.

OAuth Apps and BI tools Snowflake OAuth (built-in) or External OAuth (Azure AD, Ping, etc.) — token-based, no password.

Multi-factor authentication

MFA adds a second factor on top of the password and is enabled per user (self-enrollment in the web UI). It is strongly recommended for any user with ACCOUNTADMIN or SECURITYADMIN. MFA caching can reduce repeated prompts for connectors. A scenario that says "reduce risk of stolen passwords for admins" points to MFA.

Key-Pair, SSO, and OAuth Scenarios

Key-pair authentication replaces a password with an RSA key for non-interactive connections (Python connector, JDBC, SnowSQL automation). You generate a 2048-bit (or larger) RSA key pair, assign the public key to the user with ALTER USER svc SET RSA_PUBLIC_KEY='...' , and the client signs with the private key. For rotation , Snowflake supports two slots — RSA_PUBLIC_KEY and RSA_PUBLIC_KEY_2 — so you can roll keys with no downtime. When a stem describes a service account or ETL job that should not use a password, key-pair is the answer.

Single sign-on (SSO) uses SAML 2.0 federated authentication. Snowflake acts as the service provider and delegates authentication to an identity provider such as Okta, Microsoft Entra ID/ADFS, or PingFederate. SSO is configured through a security integration . When a stem mentions "corporate identity provider" or "users should log in with their existing company credentials," choose SSO/SAML.

OAuth is token-based and avoids storing Snowflake credentials in the client. Snowflake OAuth is built in for partner BI tools (Tableau, Looker); External OAuth lets an external authorization server (Azure AD, Ping) issue tokens that Snowflake validates. Choose OAuth when an application needs delegated, password-less access on behalf of a user.

Provisioning with SCIM

SCIM (System for Cross-domain Identity Management) integrations with Okta or Entra ID can automatically create, update, and deactivate users and roles in Snowflake when they change in the IdP. A scenario about onboarding/offboarding employees automatically points to SCIM.

Network Policies

A network policy restricts which IP addresses can connect. It is built from an allowed IP list and a blocked IP list using CIDR notation. The critical rule the exam tests: blocked ranges take precedence — if an address appears in both lists, it is denied. A network policy can be applied at the account level or to individual users ; a user-level policy overrides the account-level policy for that user. CREATE NETWORK POLICY corp_only

  • ALLOWED_IP_LIST = ('192.168.1.0/24', '203.0.113.0/24')
  • BLOCKED_IP_LIST = ('192.168.1.99');
  • ALTER ACCOUNT SET NETWORK_POLICY = corp_only;
  • Working a scenario

Approach each identity scenario the same way: identify who is connecting (human vs. service), from where (corporate network vs. anywhere), and what the security requirement is (no stored passwords, existing corporate login, automatic deactivation). Then map: human + admin → MFA; service/ETL → key-pair; corporate login → SSO/SAML; BI app token → OAuth; lifecycle automation → SCIM; restrict by IP → network policy. Distractors usually offer a method that works technically but ignores the specific requirement in the stem — for example, suggesting a shared password where the stem clearly wants password-less automation.

Worked Scenarios

Scenario A — locked-down admin. "Your security team requires that all ACCOUNTADMIN logins use a second factor." The requirement is a second factor on an interactive login , so the answer is enforce MFA on the ACCOUNTADMIN users — not a network policy (which limits IPs, not factors) and not key-pair (which is for service accounts).

Scenario B — partner BI tool. "Tableau users must connect without storing Snowflake passwords, authenticating on each user's behalf." Token-based delegated access points to Snowflake OAuth . SSO would also use the IdP, but the cue "BI tool connecting on the user's behalf with tokens" is the classic OAuth signal.

Scenario C — restrict to the office network. "Only connections from the corporate office IP range should be allowed." That is a network policy with an ALLOWED_IP_LIST. If the stem adds "but one compromised machine in that range must be blocked," remember the blocked list wins .

Scenario D — automatic offboarding. "When HR deactivates an employee in Okta, their Snowflake access must disappear automatically." Lifecycle automation from the IdP is SCIM provisioning.

Combining controls

These controls stack . A production account commonly enforces SSO for humans, MFA for privileged roles, key-pair for service accounts, an account-level network policy, and SCIM for lifecycle. The exam may present a stem where two controls are both reasonable; choose the one that addresses the specific risk named (stolen password → MFA; untrusted location → network policy; orphaned accounts → SCIM). Reading the named risk, not just the actors, is the discipline that separates a correct answer from a plausible distractor.