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 select, Multiple choice, 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:
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.
Correct Answer: B 🗳️
Explanation: Only visible for SurePassExams members. You can sign-up / login (it's free).
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.
Correct Answer: D 🗳️
Explanation: Only visible for SurePassExams members. You can sign-up / login (it's free).
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(*)
Correct Answer: D 🗳️
Explanation: Only visible for SurePassExams members. You can sign-up / login (it's free).
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);
Correct Answer: A 🗳️
Explanation: Only visible for SurePassExams members. You can sign-up / login (it's free).
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.
Correct Answer: B 🗳️
Explanation: Only visible for SurePassExams members. You can sign-up / login (it's free).
By Eileen
