Snowflake - Data Engineering Topics

Targeted practice questions for specific topics:
- Dynamic Tables
- Streaming in Snowflake
- Performance 
- Storage

Focused Snowflake practice on dynamic tables, streaming and performance.

SnowPro Advanced: Data Scientist

The SnowPro® Advanced: Data Scientist Certification focuses on advanced data science applications within Snowflake. It covers:
- Understanding data science concepts.
- Implementing Snowflake-specific data science best practices.
- Data preparation and feature engineering in Snowflake.
- Training and utilizing machine learning models.
- Employing data visualization for presenting business cases, like model explainability.
- Managing the lifecycle of models.

Practice data science on Snowflake: data preparation, feature engineering, model development and deployment.

Azure Data Engineer Associate

As a candidate for this exam, you should have subject matter expertise in integrating, transforming, and consolidating data from various structured, unstructured, and streaming data systems into a suitable schema for building analytics solutions.

As an Azure data engineer, you help stakeholders understand the data through exploration, and build and maintain secure and compliant data processing pipelines by using different tools and techniques. You use various Azure data services and frameworks to store and produce cleansed and enhanced datasets for analysis. This data store can be designed with different architecture patterns based on business requirements, including:

- Modern data warehouse (MDW)
- Big data
- Lakehouse architecture

Practice batch and streaming data solutions on Azure, with ingestion, partitioning, security, monitoring and optimization.

Databricks Certified Data Engineer - Associate

The Databricks Certified Data Engineer Associate certification exam assesses an individual’s ability to use the Databricks Lakehouse Platform to complete introductory data engineering tasks. This includes an understanding of the Lakehouse Platform and its workspace, its architecture, and its capabilities. It also assesses the ability to perform multi-hop architecture ETL tasks using Apache Spark SQL and Python in both batch and incrementally processed paradigms. Finally, the exam assesses the tester’s ability to put basic ETL pipelines and Databricks SQL queries and dashboards into production while maintaining entity permissions. 

Practice the Databricks Lakehouse Platform, ELT with Spark SQL and Python, incremental processing, production pipelines and governance.

Databricks Certified Data Engineer - Professional - Tranche 3

Databricks Certified Data Engineer - Professional - Tranche 4

The Databricks Certified Data Engineer Professional certification exam assesses an individual’s ability to use Databricks to perform advanced data engineering tasks. This includes an understanding of the Databricks platform and developer tools like Apache Spark, Delta Lake, MLflow, and the Databricks CLI and REST API. It also assesses the ability to build optimized and cleaned ETL pipelines. Additionally, modeling data into a Lakehouse using knowledge of general data modeling concepts will also be assessed. Finally, ensuring that data pipelines are secure, reliable, monitored, and tested before deployment will also be included in this exam. Individuals who pass this certification exam can be expected to complete advanced data engineering tasks using Databricks and its associated tools.

Practice advanced Databricks data engineering: ingestion, modeling, Python and SQL pipelines, governance, security and cost tuning.

Databricks Certified Data Engineer - Professional

Databricks Certified Generative AI Engineer Associate

The Databricks Certified Generative AI Engineer Associate certification exam assesses an individual’s ability to design and implement LLM-enabled solutions using Databricks. This includes problem decomposition to break down complex requirements into manageable tasks as well as choosing appropriate models, tools and approaches from the current generative AI landscape for developing comprehensive solutions. It also assesses Databricks-specific tools such as Vector Search for semantic similarity searches, Model Serving for deploying models and solutions, MLflow for managing a solution lifecycle, and Unity Catalog for data governance. Individuals who pass this exam can be expected to build and deploy performant RAG applications and LLM chains that take full advantage of Databricks and its toolset.

Practice designing, building, deploying and evaluating generative AI applications on Databricks, including data preparation.

DBT Certified Developer Tranche 1

DBT Certified Developer Tranche 2

The Analytics Engineering Certification Exam assesses your proficiency in constructing, testing, and managing models for data accessibility, as well as utilizing dbt to implement engineering principles in analytics infrastructure.

Practice developing, testing, documenting and deploying dbt models, plus debugging, environments, governance and pipeline management.

dbt Analytics Engineering

Google Professional Data Engineer

A Professional Data Engineer makes data usable and valuable for others by collecting, transforming, and publishing data. This individual evaluates and selects products and services to meet business and regulatory requirements. A Professional Data Engineer creates and manages robust data processing systems. This includes the ability to design, build, deploy, monitor, maintain, and secure data processing workloads.

The Professional Data Engineer exam assesses your ability to:

- Design data processing systems
- Ingest and process the data
- Store the data
- Prepare and use data for analysis
- Maintain and automate data workloads

Practice designing, building and running data processing systems on Google Cloud, from ingestion and storage to analysis.

SnowPro Advanced: Administrator - Tranche 1

The SnowPro® Advanced: Administrator Certification Exam assesses advanced data cloud administrative skills using Snowflake. It covers managing Snowflake accounts, data security, and governance, maintaining database objects and virtual warehouses, database monitoring and tuning, data sharing through the Data Exchange and Snowflake Marketplace, and administering disaster recovery, backup, and data replication.

Practice Snowflake administration: security and RBAC, account management, governance, data sharing, replication and recovery.

SnowPro Advanced: Administrator

SnowPro Advanced: Data Architect

The SnowPro® Advanced: Architect certification assesses advanced skills in designing and implementing comprehensive solutions using Snowflake. Key competencies include:
- Creating end-to-end data flows on Snowflake's Platform.
- Developing data architectures aligned with business, security, and compliance needs.
- Choosing suitable Snowflake and third-party tools for optimized performance.
- Designing and deploying shared data sets through Snowflake Marketplace and Data Exchange.

Practice architecture-level Snowflake decisions across account security, data engineering and performance optimization.

SnowPro Advanced: Data Engineer - DEA-C02 1

SnowPro Advanced: Data Engineer - DEA-C02 2

The SnowPro Advanced: Data Engineer Certification Exam 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 DE workloads
- Evaluate performance metrics

Practice advanced Snowflake data engineering: data movement, transformation, performance optimization, storage and security.

SnowPro Advanced: Data Engineer

Snowflake SnowPro

The SnowPro Core Certification is designed for individuals who would like to demonstrate their knowledge of the Snowflake Cloud Data Platform. The candidate has a thorough knowledge of:

- Data Loading and Transformation in Snowflake
- Virtual Warehouse Performance and Concurrency
- DDL and DML Queries
- Using Semi-Structured and Unstructured Data
- Cloning and Time Travel
- Data Sharing
- Snowflake Account Structure and Management

Practice Snowflake architecture, account security, performance, data loading, transformations and data sharing.

SnowPro Core

Terraform Associate (003)

The Terraform Authoring and Operations Professional exam is a lab-based exam for Cloud Engineers focused on developing Terraform configuration and using it to manage infrastructure over time. You are well-qualified to take this exam if you hold the Terraform Associate Certification (or equivalent knowledge), have extensive production experience with Terraform Community Edition, Terraform Enterprise, or HCP Terraform, develop modules and organization standards to enable other users, and use Terraform to manage your own infrastructure resources, as well as enable others with varying levels of Terraform expertise to use Terraform effectively.

Practice Terraform basics, infrastructure as code concepts, the core workflow, state, and reading and writing configuration.