DAA-C01問題集、Snowflake実際の試験問題

質問 1

A Data Analyst needs to create a custom filter called state in a Snowflake dashboard using a SQL query.
Which query will include this custom filter?

A. select avg(total_income), state from taxpayer_wages group by state having state = state;

B. select avg(total_income), state from taxpayer_wages group by state having state = @state;

C. select avg(total_income), state from taxpayer_wages group by state having state = :state;

D. select avg(total_income), state from taxpayer_wages group by state having state = 'state';

正解: C

解説: (PassTest メンバーにのみ表示されます)

質問 2

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

A. APPROX_COUNT_DISTINCT

B. ROW_NUMBER

C. REGR_INTERCEPT

D. AVG

E. REGR_SLOPE

正解: A,D

解説: (PassTest メンバーにのみ表示されます)

質問 3

A Data Analyst is working with a table that has 1 record per day, with sales information. Which window function would calculate a 7-day moving average of sales, where SALES_DATE represents the date column?

A. SUM(SALES) OVER (ORDER BY SALES_DATE ROWS BETWEEN 7 PRECEDING AND
CURRENT ROW)

B. SUM(SALES) OVER (ORDER BY SALES_DATE ROWS BETWEEN 6 PRECEDING AND
CURRENT ROW)

C. AVG(SALES) OVER (ORDER BY SALES_DATE ROWS BETWEEN 7 PRECEDING AND
CURRENT ROW)

D. AVG(SALES) OVER (ORDER BY SALES_DATE ROWS BETWEEN 6 PRECEDING AND
CURRENT ROW)

正解: D

解説: (PassTest メンバーにのみ表示されます)

質問 4

When sharing views across accounts, which function should be used on the row access policy for the secure views to give users access to rows in a base table?

A. CURRENT_AVAILABLE_ROLES

B. CURRENT_ROLE

C. CURRENT_ACCOUNT

D. CURRENT_USER

正解: C

解説: (PassTest メンバーにのみ表示されます)

質問 5

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, SUM(ACTIVE_DRIVERS), AVG(AVERAGE_WAITING_TIME) FROM
RIDE_DATA GROUP BY CITY;

B. SELECT CITY, VARIANCE(ACTIVE_DRIVERS, AVERAGE_WAITING_TIME) FROM
RIDE_DATA GROUP BY CITY;

C. SELECT CITY, CORR(ACTIVE_DRIVERS, AVERAGE_WAITING_TIME) FROM RIDE_DATA GROUP BY CITY;

D. SELECT CITY, SUM(ACTIVE_DRIVERS), VARIANCE(AVERAGE_WAITING_TIME) FROM RIDE_DATA GROUP BY CITY;

正解: C

解説: (PassTest メンバーにのみ表示されます)

質問 6

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

A. Use INFER_SCHEMA together with the CREATE TABLE USING TEMPLATE command.

B. Use the INFER_SCHEMA together with the CREATE TABLE LIKE command.

C. Use the GENERATE_COLUMN_DESCRIPTION with the CREATE TABLE USING TEMPLATE command.

D. Use the GENERATE_COLUMN_DESCRIPTION with the CREATE TABLE LIKE command.

正解: A

解説: (PassTest メンバーにのみ表示されます)

質問 7

What is a benefit of using SQL queries that contain secure views?

A. Snowflake secure views are more performant than regular views.

B. Users will not be able to make observations about the quantity of underlying data.

C. The amount of data scanned, and the total data volume are obfuscated.

D. Only the number of scanned micro-partitions is exposed, not the number of bytes scanned.

正解: B

解説: (PassTest メンバーにのみ表示されます)

Snowflake SnowPro Advanced: Data Analyst Certification - DAA-C01 模擬練習