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 #8

A large, complicated query is used to generate a data set for a report on the most recent month. It is taking longer than expected. A review of the Query Profile shows excessive spilling. How can the performance of the query be improved WITHOUT increasing costs?

A. Create a materialized view clustered on a date column, on the table that is causing the spilling.

B. Split the query into multiple steps, replacing Common Table Expressions (CTEs) with temporary tables to process the data in smaller batches.

C. Change the source tables into external tables to establish and take advantage of custom partitioning.

D. Run the query against zero-copy clones of the source tables to avoid contention with other queries.

Discussion 0

Correct Answer: B Vote an answer

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

Question #9

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 0.012% probability of being included in the sample, with the seed set to 99992.

B. 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.

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 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.

Discussion 0

Correct Answer: A Vote an answer

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

Question #10

What functions should a Data Analyst use to run descriptive analytics on a data set? (Select TWO).

A. REGR_INTERCEPT

B. REGR_SLOPE

C. AVG

D. ROW_NUMBER

E. APPROX_COUNT_DISTINCT

Discussion 0

Correct Answer: C,E Vote an answer

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

Question #11

A single variant data column table RAW_SOURCE has the following JSON records:

A Data Analyst needs to get the value of the "f" field and have it in a consumable, tabular format. Which query should be used to meet this requirement?

A. select value:f::number from raw_source, lateral flatten( input => data:events );

B. select data:events:f::number from raw_source;

C. select value:f::number from raw_source, lateral flatten( input => data );

D. select src.events:f::number from raw_source src;

Discussion 0

Correct Answer: A Vote an answer

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

Question #12

A Data Analyst is given access to a table of inventory transfers which includes the product details, fulfillment warehouse location, and destination warehouse location. Which type of visualization should be used to illustrate the most active product transfer routes?

A. Heat grid

B. Scatterplot

C. Line chart

D. Scorecard

Discussion 0

Correct Answer: A Vote an answer

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

Question #13

When building a Snowsight dashboard that will allow users to filter data within a worksheet, which Snowflake system filters should be used?

A. Include the :datebucket system filter in a WHERE clause, and include the :daterange system filter in a SELECT clause.

B. Include the :daterange system filter in a WHERE clause, and include the :datebucket system filter in a GROUP BY clause.

C. Include the :datebucket system filter in a WHERE clause, and include the :daterange system filter in a GROUP BY clause.

D. Include the :daterange system filter in a SELECT clause, and include the :datebucket system filter in a GROUP BY clause.

Discussion 0

Correct Answer: B Vote an answer

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

Question #14

While loading data into Snowflake using named file formats, a file format defined in which location has precedence?

A. The COPY INTO statement

B. The schema definition

C. The stage definition

D. The table definition

Discussion 0

Correct Answer: A 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.