We're so confident of our products that we provide no hassle product exchange.
Snowflake DAA-C01 Exam Overview:
| Certification Vendor: | Snowflake |
| Exam Name: | SnowPro® Advanced: Data Analyst Certification Exam |
| Exam Number: | DAA-C01 |
| Real Exam Qty: | 65 |
| Exam Format: | Multiple choice, Multiple select, Scenario-based items |
| Exam Duration: | 115 minutes |
| Exam Price: | $375 USD |
| Related Certifications: | SnowPro Core Certification |
| Available Languages: | English |
| Passing Score: | 750 (scaled score 0–1000) |
| Certificate Validity Period: | 2 years |
| Recommended Training: | Snowflake Data Analyst Learning Path SnowPro Advanced: Data Analyst Study Guide |
| Exam Registration: | Pearson VUE Registration |
| Sample Questions: | Snowflake DAA-C01 Sample Questions |
| Exam Way: | Online proctored (OnVUE) or onsite at Pearson VUE test centers |
| Pre Condition: | Active SnowPro Core Certification; 1+ year hands-on experience as Data Analyst in Snowflake environment; proficiency in advanced SQL |
| Official Syllabus URL: | https://learn.snowflake.com/en/certifications/snowpro-advanced-dataanalyst/ |
Snowflake DAA-C01 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Perform Predictive Analysis | 5–10% | - Using Snowflake ML and built-in analytics - Forecasting and predictive modeling |
| Topic 2: Prepare and Present Data | 10–15% | - Snowsight dashboards and sharing results - Align outputs with business requirements - Data visualization and reporting |
| Topic 3: Prepare and Load Data | 15–20% | - External tables and data validation - Data ingestion methods: COPY INTO, stages, Snowpipe - File formats: CSV, JSON, Parquet, Avro |
| Topic 4: Use Built-in Functions and Create UDFs | 10–15% | - User-Defined Functions (UDFs) - Scalar, aggregate, table, system functions |
| Topic 5: Perform Descriptive and Diagnostic Analysis | 10–15% | - Anomaly detection and root cause analysis - Statistical summarization and trend analysis - Exploratory and ad-hoc analysis |
| Topic 6: Build and Troubleshoot Advanced SQL Queries | 20–25% | - Query optimization and troubleshooting - Complex joins, subqueries, window functions - Semi-structured data processing |
| Topic 7: Perform Simple Data Transformations for Analysis | 15–20% | - Handling NULLs and structuring datasets - Data cleansing, standardization, type conversion - Views, materialized views, CTEs |
Snowflake SnowPro Advanced: Data Analyst Certification Sample Questions:
1. The image shows a table with a variant column that is storing a JSON record:
This SQL query is run:
What will be the result?
A) 
B) 
C) 
D) 
2. A Data Analyst created two tables that are related by a foreign key, using the following commands:
Then the Analyst renamed the referenced table using the following command: ALTER TABLE mother RENAME TO father; What happens to the foreign key after the referenced table is renamed?
A) The foreign key becomes invalid because the referenced table no longer exists.
B) The foreign key will not be used during the query rewrite.
C) The foreign key is dropped because the reference is no longer valid.
D) The foreign key is updated to reference the renamed table.
3. What option would allow a Data Analyst to efficiently estimate cardinality on a data set that contains trillions of rows?
A) Count(Distinct *)
B) SYSTEM$ESTIMATE
C) Count(Distinct *)/Count(*)
D) HLL(*)
4. A Data Analyst executes a complex query. Which query will allow the Analyst to access the results a second time?
A) SELECT * FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()));
B) DESC RESULT LAST_QUERY_ID();
C) SELECT * FROM TABLE(INFORMATION_SCHEMA.QUERY_HISTORY());
D) SELECT LAST_QUERY_ID(-1);
5. What will the following query return?
SELECT * FROM testtable SAMPLE BLOCK (0.012) REPEATABLE (99992);
A) A sample of a table in which each block of rows has a 1.2% probability of being included in the sample where repeated elements are allowed.
B) A sample of a table in which each block of rows has a 0.012% probability of being included in the sample, with the seed set to 99992.
C) A sample of a table in which each block of rows has a 1.2% probability of being included in the sample, with the seed set to 99992.
D) A sample containing 99992 records of a table in which each block of rows has a 0.012% probability of being included in the sample.
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: D | Question # 3 Answer: D | Question # 4 Answer: A | Question # 5 Answer: B |
By Charlotte
