DAA-C01 by Snowflake Valid Free Exam Practice Test

Question 1

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. EXECUTE TASK STEP10 RETRY LAST; C. ALTER TASK STEP10 RESUME; D. ALTER TASK ETLDAILY RESUME;

Correct Answer: A

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

Question 2

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 GROUP BY clause. B. Include the :daterange system filter in a SELECT 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 SELECT clause. D. Include the :daterange system filter in a WHERE clause, and include the :datebucket system filter in a GROUP BY clause.

Correct Answer: D

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

Question 3

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. Go to Chart and select a bar chart that contains the two variables. B. Go to Chart and select a histogram that includes the two variables. C. Click on the column header in the results and review the histogram. D. Call the WIDTH_BUCKET function.

Correct Answer: C

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

Question 4

What functionalities are available when a Snowflake worksheet is shared with other users? (Select TWO).

A. Collaborators can share the worksheet across Snowflake accounts. B. If the worksheet is being edited, the collaborators will be able to see these edits in real-time. C. Users with edit permissions can view past versions of the worksheet. D. If multiple users edit and run a shared worksheet at the same time, each run of the worksheet will create a new version. E. Whenever a user with permissions runs a worksheet, the existing version history of the worksheet will be overwritten.

Correct Answer: B,D

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

Question 5

A Data Analyst creates and populates the following table:
create or replace table aggr(v int) as select * from values (1), (2), (3), (4); The Analyst then executes this query:
select percentile_disc(0.60) within group (order by v desc) from aggr;
What will be the result?

A. 3 B. 4 C. 2 D. 1

Correct Answer: C

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

Question 6

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

A. Materialized view B. Common Table Expressions (CTE) C. User-Defined Function (UDF) D. Stored procedure

Correct Answer: D

Question 7

Why would a Data Analyst use a dimensional model rather than a single flat table to meet BI requirements for a virtual warehouse? (Select TWO).

A. Combining facts and dimensions in a single flat table limits the scalability and flexibility. B. Snowflake generally performs better with dimensional modelling. C. Dimensional modelling will improve query performance over a single table. D. Dimensions and facts allow power users to run ad-hoc analyses. E. Dimensional modelling will save on storage space since it is denormalized.

Correct Answer: A,D

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

Snowflake SnowPro Advanced: Data Analyst Certification - DAA-C01 Exam Practice Test