Study with DAA-C01 Actual Test Questions

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 a value equivalent to the median of those generated by the expression, which may be a non-deterministic result.
• C. It will return an equivalent NULL value when the expression is evaluated.
• D. It will return some value of the expression from the group, with a non-deterministic result.

A scorecard tile on a Snowsight dashboard shows a comparison between the industry average employee age (which is 34) and a company's average employee age (which is 38). The scorecard tile looks like this:
Comparison with industry average

How should this tile be interpreted?

• A. 38 is the comparison and 12% is the average age change in the last year.
• B. 38 is the comparison and 12% is the projected industry growth.
• C. 38 is the value and 12% is the percent difference from the comparison.
• D. 38 is the value and 12% is the standard deviation.

A Data Analyst needs to add address details based on a customer's latitude and longitude to a customer sales database. The Analyst found a free Worldwide Address Data listing on the Snowflake Marketplace. The ACCOUNTADMIN placed the data set into a new database called ADDRESS_DATA. The Data Analyst needs to join the ADDRESS_DATA.OPENADDRESS table with the ORDERS table which is stored in the GLOBAL_DWH database. The combined data set needs to be created as a view. How can this be achieved?

• A. Create a view in the ADDRESS_DATA database.
• B. Ask the ACCOUNTADMIN to grant the Data Analyst the IMPORTED_PRIVILEGES on the ADDRESS_DATA database and then create a view in the ADDRESS_DATA database.
• C. Create a view in the GLOBAL_DWH database.
• D. Create a new schema called ENRICHED in the ADDRESS_DATA database and create this view in the ENRICHED schema.

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. INTERSECT
• B. PIVOT
• C. UNPIVOT
• D. EXCEPT

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

• A. To enforce that a value in a foreign key must match the value of a primary or unique key in a parent table.
• B. To allow for clustering on the primary and foreign keys by specifying them as clustering keys.
• C. To enforce that records with a UNIQUE column must have all distinct values in that column.
• D. To enforce that records with a NOT NULL column must have values in that column.
• E. To enable team members to see how tables relate to one another.