Snowflake SnowPro Advanced: Data Analyst Certification

QUESTION NO: 1
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 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. C. 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. 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.

Correct Answer: A

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

QUESTION NO: 2
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. Call the WIDTH_BUCKET function. D. Click on the column header in the results and review the histogram.

Correct Answer: D

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

QUESTION NO: 3
Consider the following chart.

What can be said about the correlation for sales over time between the two categories?

A. There is no correlation. (Selected) B. There is a negative correlation. C. There is a non-linear correlation. D. There is a positive correlation.

Correct Answer: A

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

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

Correct Answer: A,B

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

QUESTION NO: 5
A Data Analyst needs to rotate a table by transforming a wide table's columns into rows.

Which operator will be MOST beneficial for producing this output?

A. PIVOT B. INTERSECT C. UNPIVOT D. EXCEPT

Correct Answer: C

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

QUESTION NO: 6
A Data Analyst executes a complex query. Which query will allow the Analyst to access the results a second time?

A. SELECT LAST_QUERY_ID(-1); B. SELECT * FROM TABLE(INFORMATION_SCHEMA.QUERY_HISTORY()); C. DESC RESULT LAST_QUERY_ID(); D. SELECT * FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()));

Correct Answer: D

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

QUESTION NO: 7
A Data Analyst created a cost overview dashboard in Snowsight. Management has asked for a system date filter to easily change the time period and refresh the data in all dashboard tiles with a single filter selection.
The system date filter is shown below:

The Analyst wants to apply the filter onto individual dashboard components.
Adding which where clause to the queries will apply the filter as required?

A. Where start_time = :date_filter B. Where start_time >= dateadd('days', -7, CURRENT_TIMESTAMP()) C. Where start_time >= dateadd('days', -7, SYSDATE()) D. Where start_time = :daterange

Correct Answer: D

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

Snowflake SnowPro Advanced: Data Analyst Certification - DAA-C01 Exam Questions