Free Snowflake DAA-C01 Practice Test & Real Exam Questions

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: Oct 04, 2026

Question #15

A Data Analyst needs to create a custom filter called state in a Snowflake dashboard using a SQL query.
Which query will include this custom filter?

A. select avg(total_income), state from taxpayer_wages group by state having state = 'state';

B. select avg(total_income), state from taxpayer_wages group by state having state = @state;

C. select avg(total_income), state from taxpayer_wages group by state having state = :state;

D. select avg(total_income), state from taxpayer_wages group by state having state = state;

Discussion 0

Correct Answer: C Vote an answer

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

Question #16

A Data Analyst creates a dashboard showing the total credit consumption for each virtual warehouse as follows:

Why is the query failing?

A. DB1 must be authorized to have SELECT access to ACCOUNT_USAGE.

B. INFORMATION_SCHEMA should be used instead of ACCOUNT_USAGE.

C. The current database context must be changed to SNOWFLAKE.

D. The query must be executed by a user with the ACCOUNTADMIN role.

Discussion 0

Correct Answer: C Vote an answer

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

Question #17

A Data Analyst runs a query in a Snowflake worksheet, and selects a numeric column from the result grid.
What automatically-generated contextual statistic can be visualized?

A. A frequency distribution, displayed for all numeric columns

B. A histogram, displayed for all numeric, date, and time columns

C. A key distribution

D. MIN/MAX values for the column

Discussion 0

Correct Answer: B Vote an answer

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

Question #18

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. Create the table by querying the RESULT_SCAN.

B. Load the function call results directly INTO tableX.

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

D. Pass the new table as a function argument.

Discussion 0

Correct Answer: A Vote an answer

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

Question #19

A Data Analyst needs to temporarily hide a tile in a dashboard. The data will need to be available in the future, and additional data may be added. Which tile should be used?

A. Unplace

B. Show/Hide

C. Delete

D. Duplicate

Discussion 0

Correct Answer: A Vote an answer

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

Question #20

Which Snowflake feature or object can be used to dynamically create and execute SQL statements?

A. System-defined functions

B. Tasks

C. User-Defined Functions (UDFs)

D. Stored procedures

Discussion 0

Correct Answer: D Vote an answer

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

Question #21

What does the "SQL keyword" refer to in the context of adding filters to a worksheet?

A. The name of the function used to generate the filter

B. The table name containing the static filter "key" values

C. The name of a User-Defined Function (UDF) used to define the filter "key" values

D. The filter name to be inserted into queries

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Pass4Leader 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.