SnowPro® Advanced: Data Engineer — Information & Free Practice
US · Examination information
200 free questions · Answer explanations · No signup required
SnowPro® Advanced: Data Engineer
- Provider
- Pearson Vue
- Format
- Multiple Select, Multiple Choice, Interactive; online proctoring or onsite testing centers
- Exam questions
- Total questions: 65.
- Time limit
- 115 minutes
- Passing score
- 750 + Scaled Scoring from 0 - 1000
- Exam fee
- $375 USD; India registration fee $300 USD
Examination outline
Data Movement (28%)
- 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.
- Install, configure, and use connectors for Snowflake integration.
- Design and build data sharing and data consumption solutions.
- Manage different types of tables and data operations.
Performance Optimization (19%)
- Troubleshoot underperforming queries.
- Given a scenario, configure a solution for optimal performance.
- Monitor continuous data pipelines.
Storage and Data Protection (14%)
- Implement and manage data recovery features in Snowflake.
- Use system functions to analyze micro-partitions.
- Use Time Travel and cloning to create new development environments.
Data Governance (14%)
- Monitor data.
- Establish and maintain data protection.
Data Transformation (25%)
- 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.
- Handle and process unstructured data.
- Implement and manage development workflows and code management.
- Use Snowpark for data transformations.
Examination sources
- DEA-C02 Exam Study Guide
PDF page 3, printed page 2, recommendations
- DEA-C02 Exam Study Guide
PDF page 5, printed page 4, full subject area table
- DEA-C02 Exam Study Guide
PDF page 1, cover examination version
- DEA-C02 official page content data
result.data.templateCertificationModel.examBreakdown.plaintext, EXAM FORMAT
- DEA-C02 official page content data
result.data.templateCertificationModel.examBreakdown.plaintext, passing score
- SnowPro Registration Instructions
Steps to register, opening paragraph
- DEA-C02 official page content data
result.data.templateCertificationModel.examBreakdown.plaintext, prerequisites and delivery
Related license preparation
This examination may be required or accepted as an alternative, depending on the license and application pathway.