Chapter 4 of 5 · Snowflake DEA-C02
Data Governance
Tags, classification, lineage, data quality, Horizon Catalog, masking, row policies and Data Clean Rooms.
- 7topics
- 31 minfast track
- 1diagrams and exhibits
- 14%of the exam
Topics in this chapter
Take them in order, or jump to the one you need.
- 1Object Tagging and Data ClassificationMonitor data in Snowflake with object tags, tag inheritance and propagation, system classification tags, classification profiles…5 min
- 2Lineage, Dependencies and Data QualityMonitor Snowflake data with lineage graphs, ACCESS_HISTORY, OBJECT_DEPENDENCIES and data metric functions that run scheduled data…4 min
- 3Horizon Catalog and Data ProtectionSet a data protection baseline with Snowflake Horizon Catalog, then share and federate data outside Snowflake with Iceberg REST…4 min
- 4Column-level Security and MaskingProtect Snowflake columns with Dynamic Data Masking, external tokenization, projection policies and role based masking, and pick…5 min
- 5Row Access and Aggregation PoliciesSecure Snowflake rows with row access policies, mapping tables and secure views, and limit small group results with aggregation…Diagram4 min
- 6Managing Policies with DDL and Best PracticesManage Snowflake masking and row access policies with DDL: create, alter the body, attach, detach, drop, find references, and…5 min
- 7Snowflake Data Clean RoomsShare data with Snowflake Data Clean Rooms: collaborations, owner, provider and runner roles, templates, data offerings, the…4 min
About this chapter
What this chapter covers
This chapter tests how a data engineer finds, protects and shares sensitive data. It covers monitoring with tags, classification, lineage and data quality, then the policies that restrict columns and rows, and finally sharing with Horizon Catalog and Data Clean Rooms.
Questions are scenarios such as "A Data Engineer must let analysts filter on a column without seeing it". Most hinge on choosing the right policy type, knowing the edition requirement, and the order in which things happen.
How the topics fit together
Governance works as a loop. You discover and label data, protect it with policies, then share it safely.
- Tagging and classification find and label sensitive columns.
- Lineage, dependencies and data quality show where data flows and whether it is good.
- Horizon Catalog is the umbrella for protection and for sharing outside Snowflake.
- Column-level security covers masking, external tokenization and projection policies.
- Row access and aggregation policies limit which rows and which groups a user sees.
- Policy DDL and best practices cover the lifecycle of policies.
- Data Clean Rooms let parties analyze joint data without exposing raw rows.
Most of this chapter needs Enterprise edition or higher: tag based masking, masking, row access, projection and aggregation policies, classification, lineage and data quality monitoring.
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, SQL and comparison tables.
- Common mistakes: the classic traps.
- What to remember for the exam: the facts to memorize.
- Check yourself: three questions to test your understanding.
Read the pages in order the first time. The policy pages reuse tags and roles from the first two.
Ready for more practice?
The full Snowflake DEA-C02 question bank has 709 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.