Chapter 2 of 6 · Snowflake ADA-C02

Account Management and Data Governance

Organizations, accounts, encryption, policies, tags and the Trust Center.

  • 9topics
  • 44 minfast track
  • 2diagrams and exhibits
  • 18%of the exam

Topics in this chapter

Take them in order, or jump to the one you need.

  1. 1Organizations and the Organization AccountLearn what a Snowflake organization gives you, how it is named, account types, the organization account and GLOBALORGADMIN, and…5 min
  2. 2Accounts, Names and Account IdentifiersCreate, list and rename accounts, and choose the right account name, locator, region ID and region group for connections, sharing…4 min
  3. 3Encryption, Key Management and Tri-Secret SecureHow Snowflake encrypts data by default, the key hierarchy, key rotation and periodic rekeying, and customer managed keys with…Diagram5 min
  4. 4Account Parameters and Enabling Cortex AISet and check account parameters with ALTER ACCOUNT, know the override order, and enable Snowflake Cortex AI features and cross…5 min
  5. 5Data Masking and External TokenizationProtect sensitive columns with Dynamic Data Masking and external tokenization, and decide which to use based on business needs…5 min
  6. 6Row Access Policies and Secure ViewsConfigure a row access policy, compare it with secure views, and predict its effect on queries, masking, cloning, replication and…5 min
  7. 7Access History, Tagging and Tag-Based MaskingAudit who read or changed data with ACCESS_HISTORY, classify objects with tags, and use tag-based masking policies so protection…Diagram5 min
  8. 8Data Classification and Governance in SnowsightDetect sensitive columns with data classification, apply category tags, and manage and monitor governance and tags in the…5 min
  9. 9Trust Center, Horizon Catalog, Universal Search and LineageEnable Trust Center scanner packages and roles, and use Horizon Catalog, Universal Search and data lineage to find, govern and…5 min

About this chapter

What this chapter covers

Account Management and Data Governance is the chapter on how an administrator runs the accounts of an organization and protects the data inside them. For the SnowPro Advanced: Administrator ADA-C02 exam it tests decisions: which identifier, which key arrangement, which policy, which tool, and why.

Questions are scenarios that start with "An administrator needs to ...". They are single answer, multiple select or interactive, and the right answer usually hinges on one fact such as an edition requirement, a default value or which role owns the task.

How the topics fit together

The chapter moves from the outside in: the organization, the account, the keys that protect it, and the policies and tools that govern the data.

Organizationaccounts and regionscontainsAccountnames and identifiersprotected byEncryptionkeys and Tri Secret Secureconfigured byParametersand Cortex AIgoverned byPoliciesmasking and row accessdescribed byTags and classificationwatched byTrust Centerand lineage
  • Organizations and accounts cover the organization account, GLOBALORGADMIN, account creation, renaming and identifiers.
  • Encryption covers the key hierarchy, rotation, rekeying and customer managed keys.
  • Parameters set account behavior, and Cortex AI is enabled through privileges, roles and a cross region setting.
  • Policies protect columns and rows; most need Enterprise Edition or higher.
  • Tags and classification describe data so policies can follow it.
  • Trust Center, Horizon Catalog and lineage monitor and explain the account.
Exam tip

Edition is the most common hidden clue. Masking, row access, tag propagation, classification, access history and lineage need Enterprise Edition or higher, and Tri-Secret Secure needs 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, 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.

Ready for more practice?

The full Snowflake ADA-C02 question bank has 814 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.