CertSafari

    Snowflake SnowPro Advanced: Data Engineer (DEA-C02) Lessons

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

    Domain 1: Data Movement

    7 lessons · 28% of the exam

    1. 1.1Snowflake Data Loading Features: Stages, COPY, Snowpipe and Snowpipe Streaming

      Subdomain 1.1: Given a data set, load data into Snowflake.

      2 pages · 23 min read

    2. 1.2Snowflake Stages, Storage Integrations and Stage Encryption

      Subdomain 1.2: Ingest data of various formats through the mechanics of Snowflake.

      2 pages · 23 min read

    3. 1.3Troubleshooting COPY INTO and Snowpipe Load Errors

      Subdomain 1.3: Troubleshoot data ingestion.

      2 pages · 23 min read

    4. 1.4Snowpipe, Snowpipe Streaming and Openflow for continuous ingestion

      Subdomain 1.4: Design, build, and troubleshoot continuous data pipelines.

      2 pages · 31 min read

    5. 1.5Snowflake Kafka Connector: Configure, Map Topics, and Shape Tables

      Subdomain 1.5: Install, configure, and use connectors for Snowflake integration.

      2 pages · 25 min read

    6. 1.6Snowflake Secure Data Sharing: Shares, Secure Views and Row-Level Filtering

      Subdomain 1.6: Design and build data sharing and data consumption solutions.

      2 pages · 21 min read

    7. 1.7Snowflake Table Types: External, Iceberg, Hybrid Tables, Schema Evolution and Unloading

      Subdomain 1.7: Manage different types of tables and data operations.

      23 min read

    Domain 2: Performance Optimization

    3 lessons · 19% of the exam

    1. 2.1Finding Slow Snowflake Queries with Query History Telemetry

      Subdomain 2.1: Troubleshoot underperforming queries.

      2 pages · 23 min read

    2. 2.2Snowflake Warehouse Sizing, Multi-Cluster Scaling and Credit Control

      Subdomain 2.2: Given a scenario, configure a solution for optimal performance.

      2 pages · 25 min read

    3. 2.3Monitoring Snowflake Pipelines: Tasks, Alerts, Dynamic Tables, Streaming and Data Quality

      Subdomain 2.3: Monitor continuous data pipelines.

      23 min read

    Domain 3: Storage & Data Protection

    3 lessons · 14% of the exam

    1. 3.1Snowflake Time Travel, UNDROP and Fail-safe

      Subdomain 3.1: Implement and manage data recovery features in Snowflake.

      2 pages · 23 min read

    2. 3.2Clustering Depth and the SYSTEM$CLUSTERING Functions

      Subdomain 3.2: Use system functions to analyze micro-partitions.

      2 pages · 21 min read

    3. 3.3Zero-Copy Cloning in Snowflake: Clone Objects and Inherit Permissions

      Subdomain 3.3: Use Time Travel and cloning to create new development environments.

      2 pages · 22 min read

    Domain 4: Data Governance

    2 lessons · 14% of the exam

    1. 4.1Snowflake Object Tagging and Sensitive Data Classification

      Subdomain 4.1: Monitor data.

      2 pages · 19 min read

    2. 4.2Column-Level Security: Masking Policies, External Tokenization and Projection Policies

      Subdomain 4.2: Establish and maintain data protection.

      2 pages · 27 min read

    Domain 5: Data Transformation

    7 lessons · 25% of the exam

    1. 5.1Snowflake UDFs: Scalar, SQL, JavaScript and Secure Functions

      Subdomain 5.1: Define User-Defined Functions (UDFs) and outline how to use them.

      2 pages · 21 min read

    2. 5.2Snowflake External Functions: How They Work and CREATE EXTERNAL FUNCTION

      Subdomain 5.2: Define and create external functions.

      2 pages · 19 min read

    3. 5.3Snowflake Stored Procedures: SQL Scripting, JavaScript and Snowpark Handlers

      Subdomain 5.3: Design, build, and leverage stored procedures.

      2 pages · 23 min read

    4. 5.4Snowflake VARIANT Traversal and FLATTEN: Semi-Structured to Relational

      Subdomain 5.4: Handle and transform semi- structured data.

      2 pages · 19 min read

    5. 5.5Unstructured Files in Snowflake: Stages, URL Types, Directory Tables and the REST API

      Subdomain 5.5: Handle and process unstructured data.

      2 pages · 25 min read

    6. 5.6Snowsight Workspaces, Notebooks and Git Integration

      Subdomain 5.6: Implement and manage development workflows and code management.

      2 pages · 20 min read

    7. 5.7Snowpark Architecture and Lazy DataFrames

      Subdomain 5.7: Use Snowpark for data trans- formations.

      2 pages · 18 min read

    Practice Snowflake SnowPro Advanced: Data Engineer (DEA-C02) in quiz mode