SnowPro® Advanced Data Engineer

Duration: Hours

Enquiry


    Category:

    Training Mode: Online

    Description

    The SnowPro Advanced: Data Engineer Certification will test advanced knowledge and skills used to apply comprehensive data engineering principles using Snowflake.

    SNOWPRO® ADVANCED: DATA ENGINEER OVERVIEW

    The SnowPro® Advanced: Data Engineer Certification will test advanced knowledge and skills used to apply comprehensive data engineering principles using Snowflake. This certification will test the ability to:

    • Source data from Data Lakes, APIs, and on-premises
    • Transform, replicate, and share data across cloud platforms
    • Design end-to-end near real-time streams
    • Design scalable compute solutions for Data Engineer workloads
    • Evaluate performance metrics

    SNOWPRO ADVANCED: DATA ENGINEER CANDIDATE

    2 + years of hands-on Snowflake Practitioner experience in a Data Engineering role.

    Target Audience:

    • Data Engineers
    • Software Engineers

    EXAM FORMAT

    Exam Version: DEA-C01
    Total Number of Questions: 65
    Question Types: Multiple Select, Multiple Choice
    Time Limits: 115 minutes
    Language: English
    Registration fee: $375 USD
    Passing Score: 750 + Scaled Scoring from 0 – 1000
    Unscored Content: Exams may include unscored items to gather statistical information for future use. These items are not identified on the form and do not impact your score, and additional time is factored into account for this content.
    Prerequisites: SnowPro Core Certified
    Delivery Options:

    Online Proctoring

    Onsite Testing Centers

    EXAM DOMAIN BREAKDOWN

    This exam guide includes test domains, weightings, and objectives. It is not a comprehensive listing of all the content that will be presented on this examination. The table below lists the main content domains and their weightings.

    DomainDomain Weightings on Exams
    1.0 Data Movement25-30%
    2.0 Performance Optimization20-25%
    3.0 Storage and Data Protection10-15%
    4.0 Security10-15%
    5.0 Data Transformation25-30%

    EXAM TOPICS

    Outlined below are the Domains & Objectives measured on the exam. To view subtopics, download the exam study guide.

    Domain 1.0: Data Movement

    1.1 Given a data set, load data into Snowflake.
    1.2 Ingest data of various formats through the mechanics of Snowflake.
    1.3 Troubleshoot data ingestion.
    1.4 Design, build, and troubleshoot continuous data pipelines.
    1.5 Analyze and differentiate types of data pipelines.
    1.6 Install, configure, and use connectors to connect to Snowflake.
    1.7 Design and build data sharing solutions.
    1.8 Outline when to use external tables and define how they work.

    Domain 2.0: Performance Optimization

    2.1 Troubleshoot underperforming queries.
    2.2 Given a scenario, configure a solution for the best performance.
    2.3 Outline and use caching features.
    2.4 Monitor continuous data pipelines.

    Domain 3.0: Storage and Data Protection

    3.1 Implement data recovery features in Snowflake.
    3.2 Outline the impact of streams on Time Travel.
    3.3 Use system functions to analyze micro-partitions.
    3.4 Use Time Travel and cloning to create new development environments.

    Domain 4.0: Security

    4.1 Outline Snowflake security principles.
    4.2 Outline the system defined roles and when they should be applied.
    4.3 Manage data governance.

    Domain 5.0: Data Transformation

    5.1 Define User-Defined Functions (UDFs) and outline how to use them.
    5.2 Define and create external functions.
    5.3 Design, build, and leverage stored procedures.
    5.4 Handle and transform semi-structured data.
    5.5 Use Snowpark for data transformation.

     

    Reviews

    There are no reviews yet.

    Be the first to review “SnowPro® Advanced Data Engineer”

    Your email address will not be published. Required fields are marked *

    Enquiry


      Category: