Snowflake DAA-C01 Actual Free Exam Questions & Community Discussion

Exam Code/Number: DAA-C01
Exam Name/Title: SnowPro Advanced: Data Analyst Certification Exam
Certification Provider: Snowflake
Corresponding Certification: SnowPro Advanced

Exam Questions: 67
Updated On: Jun 03, 2026

Question #29

A Data Analyst executes a query in a Snowflake worksheet that returns the total number of daily sales, and the total amount for each sale. How can the Analyst check the distribution of the total amount, without running the query again?

A. Click on the column header in the results and review the histogram.

B. Go to Chart and select a histogram that includes the two variables.

C. Call the WIDTH_BUCKET function.

D. Go to Chart and select a bar chart that contains the two variables.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #30

What potential problem can be identified in the Query profile below?

A. The query is not using a foreign Key.

B. There is an exploding join

C. There is query spilling.

D. There Is inefficient pruning.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #31

What is a benefit of using SQL queries that contain secure views?

A. Users will not be able to make observations about the quantity of underlying data.

B. Only the number of scanned micro-partitions is exposed, not the number of bytes scanned.

C. The amount of data scanned, and the total data volume are obfuscated.

D. Snowflake secure views are more performant than regular views.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #32

Which Snowflake feature allows users to encapsulate a series of SQL statements into a reusable database object, facilitating modular code development?

A. Stored procedure

B. Common Table Expressions (CTE)

C. User-Defined Function (UDF)

D. Materialized view

Discussion 0

Correct Answer: A Vote an answer

Question #33

A Directed Acyclic Graph (DAG) of 12 tasks (ETLDAILY) failed because one of the tasks failed (STEP10), therefore the dependent tasks (STEP11 and STEP12) did not run. Which command is needed to re-run task STEP10 and the two dependent tasks?

A. EXECUTE TASK ETLDAILY RETRY LAST;

B. ALTER TASK ETLDAILY RESUME;

C. ALTER TASK STEP10 RESUME;

D. EXECUTE TASK STEP10 RETRY LAST;

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #34

What scheme is used by Snowflake to estimate the approximate similarity between two or more data sets?

A. APPROX_TOP_K

B. HyperLogLog

C. APPROX_PERCENTILE

D. MINHASH

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #35

A Data Analyst created a model called modelX using SNOWFLAKE.ML.FORECAST. The Analyst needs to predict the next few values and save the result directly into tableX. What step does the Analyst need to take after calling the modelX!FORECAST function?

A. List the cache content, then use the data saved in the RESULT_SCAN for tableX.

B. Load the function call results directly INTO tableX.

C. Pass the new table as a function argument.

D. Create the table by querying the RESULT_SCAN.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Download Free Snowflake DAA-C01 Demo

Simply submit your e-mail address below to get started with our free demo of your Snowflake DAA-C01 exam.