Snowflake SnowPro Advanced: Data Analyst (DAA-C01) Lessons
19 lessons, one per exam-guide subdomain, in the order the guide teaches them. Every claim is cited to the official documentation.
Domain 1: Data Ingestion and Data Preparation
7 lessons · 17% of the exam
1.1Retrieving CSV and Semi-Structured Data in Snowflake
Subdomain 1.1: Use a collection system to retrieve data.
2 pages · 25 min read
1.2Snowflake Data Discovery: Context, Metadata, Statistics and Granularity
Subdomain 1.2: Perform data discovery to identify what is needed from the available datasets.
2 pages · 22 min read
1.3Snowflake Marketplace: Find and Get Listings to Enrich Your Data
Subdomain 1.3: Enrich data by identifying and accessing relevant data from the Snowflake Marketplace.
2 pages · 22 min read
1.4Snowflake Primary Keys and Constraints: Declared vs Enforced
Subdomain 1.4: Use best practice considerations relating to data integrity structures.
2 pages · 19 min read
1.5Snowflake Pipeline Automation: Data Quality, Tasks and Task Graphs
Subdomain 1.5: Implement data processing solutions.
2 pages · 21 min read
1.6Loading Files into Snowflake: Snowsight, Stages and COPY INTO
Subdomain 1.6: Given a scenario, prepare data and load into Snowflake.
2 pages · 20 min read
1.7Snowflake Scalar, Aggregate, Window, Table and System Functions
Subdomain 1.7: Given a scenario, use Snowflake functions.
2 pages · 22 min read
Domain 2: Data Transformation and Data Modeling
5 lessons · 23% of the exam
2.1Querying JSON in Snowflake: VARIANT, Path Notation and FLATTEN
Subdomain 2.1: Prepare different data types into a consumable format.
2 pages · 20 min read
2.2Data Metric Functions: Finding Data Quality Issues in Snowflake
Subdomain 2.2: Given a dataset, clean the data.
2 pages · 26 min read
2.3Snowflake Aggregates, Window Functions, Ranking and Casting
Subdomain 2.3: Given a dataset or scenario, work with and query the data.
2 pages · 22 min read
2.4Star Schemas and Flattened Data Sets for BI in Snowflake
Subdomain 2.4: Use data modeling to manipulate the data to meet BI requirements.
2 pages · 22 min read
2.5Snowflake Query Profile, EXPLAIN, Partition Pruning and Clustering Keys
Subdomain 2.5: Optimize query performance.
2 pages · 23 min read
Domain 3: Data Analysis
4 lessons · 32% of the exam
3.1Snowflake UDFs, UDTFs and Stored Procedures
Subdomain 3.1: Use SQL extensibility features.
2 pages · 20 min read
3.2Snowsight Dashboards, Custom Filters, Worksheets and Notebooks for Descriptive Analysis
Subdomain 3.2: Perform descriptive analyses.
19 min read
3.3Diagnostic Analysis: Collecting Related Data, Trends and Correlation
Subdomain 3.3: Perform diagnostic analyses.
2 pages · 25 min read
3.4Snowflake ML FORECAST: Training Models and Reading Predictions
Subdomain 3.4: Perform forecasting.
2 pages · 20 min read
Domain 4: Data Presentation and Data Visualization
3 lessons · 28% of the exam
4.1Snowflake Dashboard Data: Context, Queries, Governance and BI Connections
Subdomain 4.1: Given a use case, create reports and dashboards to meet business requirements.
2 pages · 20 min read
4.2Managing and Sharing Snowsight Dashboards
Subdomain 4.2: Given a use case, maintain reports and dashboards to meet business requirements.
2 pages · 19 min read
4.3Snowsight Charts for Trends, Patterns and Correlations
Subdomain 4.3: Given a use case, incorporate visualizations for dashboards and reports.
2 pages · 20 min read