CertSafari

    Snowflake SnowPro Advanced: Administrator (ADA-C02) Lessons

    24 lessons, one per exam-guide subdomain, in the order the guide teaches them. Every claim is cited to the official documentation.

    Domain 1: Snowflake Security, Role-Based Access Control (RBAC), and User Administration

    7 lessons · 31% of the exam

    1. 1.1ORGADMIN, GLOBALORGADMIN and ACCOUNTADMIN: Use Cases and Best Practices

      Subdomain 1.1: Manage administrative roles

      2 pages · 23 min read

    2. 1.2Snowflake Access Control Models and System-Defined Roles

      Subdomain 1.2: Given a set of business requirements, design access control framework

      2 pages · 20 min read

    3. 1.3Snowflake Privileges by Object Type and SHOW Commands for Roles, Users and Grants

      Subdomain 1.3: Given a scenario, create and manage access control.

      2 pages · 17 min read

    4. 1.4Securing ACCOUNTADMIN and Designing Custom, Database and Secondary Roles

      Subdomain 1.4: Given a scenario, fine-tune access controls.

      2 pages · 19 min read

    5. 1.5Snowflake SSO, User Types, Passwords and MFA

      Subdomain 1.5: Set up and manage Snowflake authentication.

      3 pages · 34 min read

    6. 1.6Snowflake Network Rules and Network Policy Precedence

      Subdomain 1.6: Set up and manage network and private connectivity.

      2 pages · 22 min read

    7. 1.7SCIM Provisioning in Snowflake: Integrations, Provisioner Roles and Monitoring

      Subdomain 1.7: Set up and manage security administration and authorization.

      2 pages · 21 min read

    Domain 2: Account Management and Data Governance

    3 lessons · 18% of the exam

    1. 2.1Snowflake Organizations and Account Management

      Subdomain 2.1: Manage organizations and accounts.

      2 pages · 23 min read

    2. 2.2Snowflake Masking, External Tokenization and Row Access Policies

      Subdomain 2.2: Implement and manage data governance in Snowflake.

      2 pages · 30 min read

    3. 2.3Snowflake Account Identifiers: Account Names, Locators, Region IDs and Region Groups

      Subdomain 2.3: Given a scenario, manage account identifiers.

      18 min read

    Domain 3: Data and Object Management

    5 lessons · 15% of the exam

    1. 3.1Snowflake Warehouse Sizing, Auto-Suspend and Session Warehouses

      Subdomain 3.1: Given business requirements, design, manage, and maintain virtual warehouses.

      2 pages · 24 min read

    2. 3.2Snowflake Table Types, Table Design, and Cloning

      Subdomain 3.2: Given a scenario, manage databases, tables, and views.

      2 pages · 21 min read

    3. 3.3Snowflake Storage Integrations, External Stages and Exfiltration Controls

      Subdomain 3.3: Given a scenario, stage data in Snowflake.

      2 pages · 21 min read

    4. 3.4Snowflake Tasks: Serverless vs User-Managed, Configuring and Scheduling

      Subdomain 3.4: Given a scenario, manage tasks.

      2 pages · 25 min read

    5. 3.5Snowflake Sequences, Persisted Query Results, and Cancelling Statements

      Subdomain 3.5: Perform queries in Snowflake .

      2 pages · 24 min read

    Domain 4: Performance Monitoring and Tuning

    5 lessons · 20% of the exam

    1. 4.1Snowflake Query Profile, EXPLAIN Plans and Troubleshooting Slow Queries

      Subdomain 4.1: Monitor and analyze Snowflake performance.

      2 pages · 37 min read

    2. 4.2Snowflake DML Locking, Transactions and Concurrency

      Subdomain 4.2: Manage DML locking and concurrency in Snowflake.

      2 pages · 25 min read

    3. 4.3Snowflake Resource Monitors and Cost Dashboards

      Subdomain 4.3: Given a scenario, implement resource monitors.

      19 min read

    4. 4.4Snowflake Event Tables and Telemetry Levels

      Subdomain 4.4: Enable and manage logging and tracing.

      2 pages · 23 min read

    5. 4.5Snowflake Cost Visibility: Usage Views, Storage, Serverless and AI Credits

      Subdomain 4.5: Manage and optimize costs.

      2 pages · 28 min read

    Domain 5: Data Sharing and Snowflake Marketplace

    2 lessons · 7% of the exam

    1. 5.1Snowflake Secure Data Sharing: Outbound Shares, Secure Objects and Cross-Region Delivery

      Subdomain 5.1: Implement and manage data sharing.

      2 pages · 25 min read

    2. 5.2Snowflake Marketplace Providers: Access, Requirements and Provider Profiles

      Subdomain 5.2: Implement and manage the Snowflake Marketplace

      2 pages · 19 min read

    Domain 6: Disaster Recovery, Backup, and Data Replication

    2 lessons · 9% of the exam

    1. 6.1Snowflake Replication Groups and Failover Groups: Editions, Objects, and Access Control

      Subdomain 6.1: Manage data replication.

      2 pages · 23 min read

    2. 6.2Time Travel Retention Periods, Editions and Fail-safe

      Subdomain 6.2: Given a scenario, manage Snowflake Time Travel and Fail-safe.

      2 pages · 21 min read

    Practice Snowflake SnowPro Advanced: Administrator (ADA-C02) in quiz mode