DAA-C01 무료 덤프문제 온라인 액세스

How can a Data Analyst automatically create a table structure for loading a Parquet file?

• A.Use the GENERATE_COLUMN_DESCRIPTION with the CREATE TABLE LIKE command.
• B.Use the GENERATE_COLUMN_DESCRIPTION with the CREATE TABLE USING TEMPLATE command.
• C.Use the INFER_SCHEMA together with the CREATE TABLE LIKE command.
• D.Use INFER_SCHEMA together with the CREATE TABLE USING TEMPLATE command.

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)

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, CORR(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, SUM(ACTIVE_DRIVERS), AVG(AVERAGE_WAITING_TIME) FROM
  RIDE_DATA GROUP BY CITY;
• D.SELECT CITY, VARIANCE(ACTIVE_DRIVERS, AVERAGE_WAITING_TIME) FROM
  RIDE_DATA GROUP BY CITY;

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

What scheme is used by Snowflake to estimate the approximate similarity between two or more data sets?

• A.MINHASH
• B.HyperLogLog
• C.APPROX_PERCENTILE
• D.APPROX_TOP_K