Online Access Free DAA-C01 Practice Test

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.Stored procedure
• B.External function
• C.User-Defined Function (UDF)
• D.Vectorized User-Defined Table Function (UDTF)

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

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

• A.ROW_NUMBER
• B.APPROX_COUNT_DISTINCT
• C.REGR_INTERCEPT
• D.AVG
• E.REGR_SLOPE

A company is looking for new headquarters and wants to minimize the distances employees have to commute.
The company has geographic data on employees' residences. Through the Snowflake Marketplace, the company obtained geographic data for possible locations of the new headquarters. How can the distance between an employee's residence and potential headquarters locations be calculated in meters with the LEAST operational overhead?

• A.ST_HAUSDORFFDISTANCE
• B.HAVERSINE
• C.ST_LENGTH
• D.ST_DISTANCE

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.Stored procedure
• C.Common Table Expressions (CTE)
• D.User-Defined Function (UDF)