SnowPro Advanced: Data Analyst Certification Exam (DAA-C01) Free Practice Test

Question 1

A Data Analyst is working with three tables:

Which query would return a list of all brokers, a count of the customers each broker has. and the total order amount of their customers (as shown below)?

A.

B.

C.

D.

Correct Answer: D

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

Question 2

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

A. System-defined functions

B. Tasks

C. Stored procedures

D. User-Defined Functions (UDFs)

Correct Answer: C

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

Question 3

A Data Analyst for a ride-sharing company needs to assess the relationship between the number of active drivers in a city, and the average waiting time for passengers. Which query will determine if an increase in the number of active drivers is associated with a decrease in the average waiting time?

A. SELECT CITY, VARIANCE(ACTIVE_DRIVERS, AVERAGE_WAITING_TIME) FROM
RIDE_DATA GROUP BY CITY;

B. SELECT CITY, SUM(ACTIVE_DRIVERS), VARIANCE(AVERAGE_WAITING_TIME) FROM RIDE_DATA GROUP BY CITY;

C. SELECT CITY, CORR(ACTIVE_DRIVERS, AVERAGE_WAITING_TIME) FROM RIDE_DATA GROUP BY CITY;

D. SELECT CITY, SUM(ACTIVE_DRIVERS), AVG(AVERAGE_WAITING_TIME) FROM
RIDE_DATA GROUP BY CITY;

Correct Answer: C

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

Question 4

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. Change the source tables into external tables to establish and take advantage of custom partitioning.

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

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

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

Correct Answer: C

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

Question 5

A Data Analyst runs this query:

The Analyst men runs this query:

What will be the output?

A.

B.

C.

D.

Correct Answer: D

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

Question 6

A Data Analyst has been analyzing customer data in several worksheets. Each worksheet contains a complex query that provides clean and prepared data for visualizations. The Analyst has also created a Customer Overview dashboard in Snowsight. How should the Analyst add the worksheets in the Customer Analysis database to the dashboard, using the LEAST amount of operational overhead?

A. Query the QUERY_HISTORY view to find those queries, then add the queries into the dashboard.

B. Move the worksheets into the dashboard.

C. Open each worksheet, copy the query, then paste the query into the dashboard.

D. Copy and paste the worksheets into the dashboard.

Correct Answer: B

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

Question 7

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

C. Scatterplot

D. Scorecard

Correct Answer: A

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

Welcome to TestSimulate

Snowflake SnowPro Advanced: Data Analyst Certification (DAA-C01) Free Practice Test