DAA-C01無料問題集「Snowflake SnowPro Advanced: Data Analyst Certification」

質問 1

A Data Analyst needs to rotate a table by transforming a wide table's columns into rows.

Which operator will be MOST beneficial for producing this output?

（A）PIVOT

（B）UNPIVOT

（C）EXCEPT

（D）INTERSECT

正解：B 解答を投票する

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

質問 2

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_ACCOUNT

（B）CURRENT_USER

（C）CURRENT_AVAILABLE_ROLES

（D）CURRENT_ROLE

正解：A 解答を投票する

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

質問 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 the minimum value of those generated by the expression, with a deterministic result.

（B）It will return an equivalent NULL value when the expression is evaluated.

（C）It will return some value of the expression from the group, with a non-deterministic result.

（D）It will return a value equivalent to the median of those generated by the expression, which may be a non-deterministic result.

正解：C 解答を投票する

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

質問 4

There are two similarly-structured and sized tables, Table_a and Table_b, in a schema with data populated in both tables. A Data Analyst is running queries as part of a preliminary analysis of the data to check the MAX value of a numeric column named num which is present in both the tables:
* Query 1: SELECT MAX(num) FROM Table_a;
* Query 2: SELECT MAX(num) FROM Table_b;
After running the queries, the Analyst observed that Query 2 ran significantly slower than Query 1. Why is this occurring?

（A）Table_b has more rows than Table_a.

（B）The USE_CACHED_RESULT was set to FALSE before running Query 2.

（C）A multi-cluster warehouse was used to run Query 1.

（D）Table_b has a row-access policy defined.

正解：D 解答を投票する

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

質問 5

What option would allow a Data Analyst to efficiently estimate cardinality on a data set that contains trillions of rows?

（A）HLL(*)

（B）SYSTEM$ESTIMATE

（C）Count(Distinct *)

（D）Count(Distinct *)/Count(*)

正解：A 解答を投票する

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

質問 6

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 temporarily lose access but regain it once the dashboard is created.

（B）The original users lose access to the worksheet, their permissions on the worksheet are revoked.

（C）The original users gain additional access to the worksheet.

（D）The original users retain access and permissions on the worksheet.

正解：B 解答を投票する

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

質問 7

What are the PRIMARY reasons for using integrity constraints on Snowflake tables? (Select TWO).

（A）To enable team members to see how tables relate to one another.

（B）To enforce that records with a NOT NULL column must have values in that column.

（C）To enforce that records with a UNIQUE column must have all distinct values in that column.

（D）To allow for clustering on the primary and foreign keys by specifying them as clustering keys.

（E）To enforce that a value in a foreign key must match the value of a primary or unique key in a parent table.

正解：A、B 解答を投票する

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

DAA-C01 無料問題集「Snowflake SnowPro Advanced: Data Analyst Certification」

弊社を連絡する

関連リンク

トップ試験