SnowPro Advanced: Data Engineer Practice Exam
The SnowPro® Advanced: Data Engineer Certification assesses advanced proficiency in applying extensive data engineering principles with Snowflake. It evaluates the candidate's capability to:
- Extract data from Data Lakes, APIs, and on-premises sources.
- Transform, replicate, and distribute data across cloud platforms.
- Architect end-to-end near real-time data streams.
- Devise scalable computing solutions for Data Engineer tasks.
- Analyze performance metrics.
Exam Requirements:
- A minimum of 2 years of practical experience as a Snowflake Practitioner in a Data Engineering position with SnowPro Core Certified.
Who should take the exam?
The exam is for:
- Data Engineers
- Software Engineers
Exam Details
- Exam Name: SnowPro Advanced: Data Engineer
- Exam Version: DEA-C01
- Total Number of Questions: 65
- Question Types: Multiple Select, Multiple Choice
- Time Limit: 115 minutes
- Language: English
- Passing Score: 750 + Scaled Scoring from 0 - 1000
Course Outline
The Exam covers the given topics -
Domain 1.0: Data Movement 25-30%
- Given a data set, load data into Snowflake.
- Ingest data of various formats through the mechanics of Snowflake.
- Troubleshoot data ingestion.
- Design, build, and troubleshoot continuous data pipelines.
- Analyze and differentiate types of data pipelines.
- Install, configure, and use connectors to connect to Snowflake.
- Design and build data sharing solutions.
- Outline when to use external tables and define how they work.
Domain 2.0: Performance Optimization 20-25%
- Troubleshoot underperforming queries.
- Given a scenario, configure a solution for the best performance.
- Outline and use caching features.
- Monitor continuous data pipelines.
Domain 3.0: Storage and Data Protection 10-15%
- Implement data recovery features in Snowflake.
- Outline the impact of streams on Time Travel.
- Use system functions to analyze micro-partitions.
- Use Time Travel and cloning to create new development environments.
Domain 4.0: Security 10-15%
- Outline Snowflake security principles.
- Outline the system defined roles and when they should be applied.
- Manage data governance.
Domain 5.0: Data Transformation 25-30%
- Define User-Defined Functions (UDFs) and outline how to use them.
- Define and create external functions.
- Design, build, and leverage stored procedures.
- Handle and transform semi-structured data.
- Use Snowpark for data transformation.