Snowflake

SnowPro Advanced: Security Engineer Complete Guide

2026-03-26
Updated: 2026-10-15
NicheeLab Editorial Team
Table of contents
  1. Exam Overview
  2. Exam Domains and Weighting
  3. Network Security
  4. Access Control
  5. Encryption and Key Management
  6. Auditing and Monitoring
  7. Compliance
  8. Check Your Understanding
  9. Frequently Asked Questions

The SnowPro Advanced: Security Engineer Certification (SEA-C01) validates expert-level knowledge of designing, implementing, and operating security in a Snowflake environment. The exam comprehensively covers the features a security engineer designs and manages day to day, including network isolation, encryption architecture, RBAC/DAC, data masking, auditing, and compliance. Note, however, that the exam retires on December 1, 2026, and every scheduled exam must be completed by that date.

Exam Overview

ItemDetails
Exam CodeSEA-C01
Questions65 questions (multiple choice and multiple select)
Duration115 minutes
Passing Score750 out of 1000
Cost$375 USD
PrerequisitesActive SnowPro Core certification
DeliveryPearson VUE (test center or online)
Validity2 years
Recommended Experience2+ years of hands-on Snowflake security design and operations
LanguageEnglish only
RetirementRetires on December 1, 2026 (every scheduled exam must be completed by that date)

Snowflake has announced that the SnowPro Advanced: Security Engineer exam (SEA-C01) retires on December 1, 2026. If your appointment is later than that, you must reschedule it to a date on or before December 1, 2026. According to the official retirement FAQ, a new security-focused certification aligned with Snowflake's evolving security capabilities is in development and will be announced in early 2027. A certification you have already earned stays valid for 2 years from the date you earned it.

Exam Domains and Weighting

These are the five domains listed on the official exam page and in the Study Guide (SEA-C01, last updated November 6, 2025).

DomainWeightKey Topics
1.0 Access Control and Identity Management22%RBAC and custom role design (least privilege), SCIM, MFA, passkeys and SSO (SAML/OAuth), key-pair authentication and programmatic access tokens, session policies, network policies, network rules and private connectivity, external access integrations and secrets
2.0 Data Protection, Data Privacy, and Data Governance30%Tri-Secret Secure; masking policies, external tokenization and tag-based masking; row access, projection and aggregation policies; Data Clean Rooms; preventing data exfiltration; Time Travel, Fail-safe and data retention; tagging and data classification; securing replication and failover
3.0 Auditing, Monitoring, and Compliance18%Monitoring with QUERY_HISTORY, ACCESS_HISTORY and LOGIN_HISTORY; Trust Center; security alerts; spotting anomalous credit consumption; supporting regulatory requirements such as GDPR, HIPAA, CCPA and PCI DSS
4.0 Threats, Risk Assessment, Incident Response, and Forensics18%Threat modeling, risk assessment with Horizon Catalog, detecting, containing and recovering from incidents, forensic analysis with logs
5.0 Securing Snowflake Services and Features for AI/ML and Applications12%Snowpark Container Services security; using Cortex AI to strengthen security (COMPLETE/TRY_COMPLETE, CLASSIFY_TEXT/AI_CLASSIFY, Cortex Analyst, Cortex Agents); Native Apps security

Network Security

Network Policies

SettingDescription
ALLOWED_IP_LISTList of IP addresses/CIDRs that are allowed to connect
BLOCKED_IP_LISTIPs to exclude from the ALLOWED_IP_LIST
ScopeAccount level or user level (user level takes precedence)
CautionIf a misconfiguration locks you out, you must contact Snowflake Support

Private Connectivity

  • AWS PrivateLink: private connection to Snowflake from inside a VPC, bypassing the internet
  • Azure Private Link: private connection from inside a VNet
  • GCP Private Service Connect: private connection from inside a VPC
  • Available on Business Critical Edition or higher
  • Access to Internal Stages (PUT/GET), Snowsight, and Snowpipe can also be protected over PrivateLink

Access Control

The Combined RBAC / DAC Model

Snowflake uses an access control model that combines RBAC (Role-Based Access Control) and DAC (Discretionary Access Control).

Access ControlHow It WorksHow to Manage
RBACGrant privileges to roles and assign roles to usersGRANT ROLE / GRANT PRIVILEGE
DACThe object creator (owning role) grants privileges to other rolesGRANT ... ON ... TO ROLE

Role Hierarchy Design Best Practices

  • Place every custom role under SYSADMIN (to prevent gaps in the role tree)
  • Do not use ACCOUNTADMIN for routine work; switch to it only when needed
  • Combine functional roles (DATA_READER / DATA_WRITER / ANALYST) with environment roles (DEV / STG / PROD)
  • Use MANAGED ACCESS schemas to centralize privilege management with the schema owner

Data Masking

Masking TypeDescriptionHow to Apply
Dynamic Data MaskingMasks column values at query time based on the roleALTER COLUMN ... SET MASKING POLICY
External TokenizationTokenizes values via an external serviceExternal Function + masking policy
Tag-Based MaskingApplies a masking policy in bulk via a tagALTER TAG ... SET MASKING POLICY

Row Access Policies

  • Use a mapping table to define which data each role can access
  • Use CURRENT_ROLE() and IS_ROLE_IN_SESSION() to evaluate roles inside the policy
  • Combining with masking policies gives you column-level plus row-level double protection
  • Available on Enterprise Edition or higher

Encryption and Key Management

Encryption Architecture

LayerEncryption MethodManaged By
Data filesEncrypted with an AES-256 file keyAuto-managed by Snowflake
Table master keyKey that encrypts file keysAuto-managed by Snowflake (rotated automatically once more than 30 days old)
Account master keyKey that encrypts table master keysSnowflake-managed (rotated automatically once more than 30 days old)
Root keyTop-level key that encrypts account master keysSnowflake-managed
Composed master key (Tri-Secret Secure)Customer key + Snowflake key -> composed keyJointly managed by the customer and Snowflake

All data is automatically encrypted on write (Encryption at Rest), and network traffic is protected with TLS 1.2 (Encryption in Transit). There is no setting for users to toggle encryption on or off; it is always on.

Key Rotation

  • Automatic rotation: keys in the Snowflake-managed key hierarchy are automatically rotated once they are more than 30 days old
  • Periodic rekeying: data protected by a retired key that is more than one year old is re-encrypted with a new key (Periodic Rekeying, Enterprise Edition or higher)
  • Customer-managed keys: with Tri-Secret Secure, the customer creates and manages the key in the cloud provider's KMS; to rotate it, the customer registers the new key for use with Tri-Secret Secure

Auditing and Monitoring

ViewContentsLatency
LOGIN_HISTORYLogin success/failure, authentication method, and IP addressUp to 120 minutes
ACCESS_HISTORYRead/write access history against objectsUp to 3 hours
QUERY_HISTORYDetails of every executed queryUp to 45 minutes
SESSIONSActive session informationUp to 3 hours
GRANTS_TO_USERSHistory of role grants to usersUp to 120 minutes

For security audits, it's important to detect suspicious login attempts in LOGIN_HISTORY (large numbers of failures in a short window, access from unknown IPs) and analyze unexpected data access patterns in ACCESS_HISTORY.

Compliance

StandardSupported EditionRequired Configuration
SOC 1 / SOC 2 Type IIAll editionsSupported by default
HIPAABusiness Critical or higherBAA execution, encryption, access control, audit logs
PCI DSSBusiness Critical or higherNetwork isolation, encryption, access control, log monitoring
FedRAMP ModerateBusiness Critical or higherOperate in a FedRAMP-authorized region
GDPRAll editionsData retention policy, data masking, deletion handling
  • For HIPAA compliance, you must execute a BAA (Business Associate Agreement) with Snowflake
  • PCI DSS requires encryption of cardholder data, access restrictions, log recording, and periodic vulnerability scans
  • GDPR requires you to design a personal data deletion process to honor the right to be forgotten

Check Your Understanding

SnowPro Advanced: Security Engineer

Question 1

Which Snowflake encryption scheme uses a customer-managed key such that, when the customer disables the key, Snowflake itself can no longer access the data?

  1. End-to-End Encryption (E2EE)
  2. Tri-Secret Secure
  3. Client-Side Encryption
  4. Transparent Data Encryption (TDE)

Correct answer: B

Tri-Secret Secure is an encryption scheme that generates a composed master key by combining a customer-managed key (AWS KMS/Azure Key Vault/GCP Cloud KMS) with a Snowflake-managed key. If the customer disables the key in their own KMS, the composed key can no longer be derived, and Snowflake can no longer decrypt the data either. It is available on Business Critical Edition or higher.

Frequently Asked Questions

Until when can I take the SnowPro Advanced: Security Engineer exam?

Snowflake has announced that the Security Engineer exam (SEA-C01) retires on December 1, 2026. Every scheduled exam must be completed by that date, and if your appointment is later, you must reschedule it to a date on or before December 1, 2026. According to the official retirement FAQ, a new security-focused certification is in development and will be announced in early 2027; in the meantime, Snowflake encourages candidates to explore the broader SnowPro certification portfolio for a path that fits their career goals. A certification you have already earned stays valid for 2 years from the date you earned it.

How does the SnowPro Advanced Security Engineer exam differ from the Administrator exam?

The Administrator exam broadly covers overall account operations including security (performance, cost management, data governance, and more), while the Security Engineer exam tests deep knowledge focused specifically on security. Its official scope covers Tri-Secret Secure, network controls (network policies, network rules, PrivateLink), regulatory compliance (GDPR, HIPAA, CCPA, PCI DSS), and audit log analysis (ACCESS_HISTORY, LOGIN_HISTORY), plus two domains the Administrator exam does not have: threat modeling, incident response, and forensics (Domain 4.0, 18%), and securing Snowpark Container Services and Native Apps and using Cortex AI to strengthen security (Domain 5.0, 12%).

What is Tri-Secret Secure, and how is it tested on the exam?

Tri-Secret Secure is three levels of data protection: a dual-key encryption model that combines a Snowflake-maintained key with a customer-managed key to create a composite master key, together with Snowflake's built-in user authentication. Combining the customer's key managed in AWS KMS/Azure Key Vault/GCP Cloud KMS with Snowflake's key means that if the customer disables their key, Snowflake can no longer access the data either. The exam tests that it is available on Business Critical Edition or higher, the behavior when a customer revokes their key, and the setup procedure.

How heavily are compliance topics (GDPR/HIPAA/PCI DSS) weighted on the Security Engineer exam?

Compliance falls under Domain 3.0, Auditing, Monitoring, and Compliance (18%). That domain also covers auditing and monitoring, so the share for compliance alone is not published. The official Study Guide lists explaining how encryption, access controls, masking, and auditing support regulatory requirements such as GDPR, HIPAA, CCPA, and PCI DSS; audit policies for compliance reporting; and using Trust Center resources (the Compliance Center, security certifications, and compliance reports). Also know which edition each standard requires (HIPAA/PCI DSS need Business Critical or higher). Rather than memorizing clauses, understand which Snowflake feature satisfies which requirement of which standard.

Check what you learned with practice questions

Practice with certification-focused question sets

Try free questions
Author

NicheeLab Editorial Team

NicheeLab editorial team focused on data engineering and cloud certification learning. Content is structured around practical study needs and official exam domains.


Related articles
Snowflake

Snowflake Certifications: All 11 Exams Explained (2026)

Every SnowPro certification on Snowflake's official list — C...

Snowflake

Snowflake Exam Difficulty Ranking: All 11 Certs Compared (2026)

All 11 SnowPro exams compared by difficulty in a ranking and...

Snowflake

Snowflake Study Guide: Fastest Pass Route by Exam (2026)

How to pass SnowPro certifications efficiently — official ma...

Snowflake

SnowPro Core (COF-C03): Complete Exam Guide (2026)

Pass the SnowPro Core exam — five domains, scope, sample que...

Snowflake

SnowPro Associate Platform (SOL-C01): Current Status & What to Take Next (2026)

As of October 2026, SnowPro Associate: Platform (SOL-C01) is...

Browse all Snowflake articles (103)
© 2026 NicheeLab All rights reserved.