Snowflake SnowPro Advanced: Data Analyst Certification - DAA-C01 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

A Data Analyst is creating a Snowsight dashboard from a shared worksheet. What happens to the access and permissions of the users who initially had sharing privileges on the worksheet?

A. The original users lose access to the worksheet, their permissions on the worksheet are revoked. B. The original users gain additional access to the worksheet. C. The original users temporarily lose access but regain it once the dashboard is created. D. The original users retain access and permissions on the worksheet.

Discussion 0

Correct Answer: A Vote an answer

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

Question 2

A Data Analyst wants to use pandas code they have previously written to process a column of text and return multiple rows of parsed output for each input value. The Analyst wants to be able to join these results with other tables in a single transaction. Which type of extensibility feature should the Analyst use?

A. User-Defined Function (UDF) B. Vectorized User-Defined Table Function (UDTF) C. Stored procedure D. External function

Discussion 0

Correct Answer: B Vote an answer

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

Question 3

A Data Analyst has a Parquet file stored in an Amazon S3 staging area. Which query will copy the data from the staged Parquet file into separate columns in the target table?

A. Option B B. Option A C. Option C D. Option D

Discussion 0

Correct Answer: C Vote an answer

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

Question 4

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. Duplicate B. Show/Hide C. Unplace D. Delete

Discussion 0

Correct Answer: C Vote an answer

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

Question 5

Which query will provide this data without incurring additional storage costs?

A. CREATE TABLE DEV.PUBLIC.TRANS_HIST AS (SELECT * FROM PROD.PUBLIC.
TRANS_HIST); B. CREATE TABLE DEV.PUBLIC.TRANS_HIST AS (SELECT * FROM PROD.PUBLIC.TRANS_HIST WHERE extract(year from (TRANS_DATE)) = 2019); C. CREATE TABLE DEV.PUBLIC.TRANS_HIST CLONE PROD.PUBLIC.TRANS_HIST; D. CREATE TABLE DEV.PUBLIC.TRANS_HIST LIKE PROD.PUBLIC.TRANS_HIST;

Discussion 0

Correct Answer: C Vote an answer

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

Question 6

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

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

Discussion 0

Correct Answer: C Vote an answer

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

Question 7

A Data Analyst created two functions and one procedures:
The Analyst then runs this query:

The Analyst then runs this query:

What will be the output?

A. 20 B. Null C. 10 D. 30

Discussion 0

Correct Answer: A Vote an answer

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