最新のDAA-C01問題集で試験を準備する

Snowflake DAA-C01 試験概要:

Snowflake DAA-C01 試験シラバストピック:

Snowflake SnowPro Advanced: Data Analyst Certification 認定 DAA-C01 試験問題：

1. Table TB_A with column COL_B contains an ARRAY. Which statement will select the last element of the ARRAY?

A) SELECT COL_B[-1] FROM TB_A;
B) SELECT GET(COL_B, ARRAY_SIZE(COL_B)-1) FROM TB_A;
C) SELECT LAST_VALUE(COL_B) FROM TB_A;
D) SELECT COL_B[ARRAY_SIZE(COL_B)] FROM TB_A;

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

3. This query is run:
SQL
SELECT
customer.id,
ANY_VALUE(customer.name),
SUM(orders.value)
FROM customer
JOIN orders ON customer.id = orders.customer_id
GROUP BY customer.id;
What is the effect of ANY_VALUE in this syntax?

A) It will return an equivalent NULL value when the expression is evaluated.
B) It will return the minimum value of those generated by the expression, with a deterministic result.
C) It will return a value equivalent to the median of those generated by the expression, which may be a non-deterministic result.
D) It will return some value of the expression from the group, with a non-deterministic result.

4. This command was executed:
SQL
SELECT seq4(), uniform(1, 10, RANDOM(12))
FROM TABLE(GENERATOR(TIMELIMIT => NULL))
ORDER BY 1;
How many rows will be generated?

A) An infinite number
B) 12
C) 0
D) 10

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

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

質問と回答：