DAA-C01 試験問題を無料オンラインアクセス

A Data Analyst runs a query in a Snowflake worksheet, and selects a numeric column from the result grid.
What automatically-generated contextual statistic can be visualized?

• A.A key distribution
• B.A frequency distribution, displayed for all numeric columns
• C.MIN/MAX values for the column
• D.A histogram, displayed for all numeric, date, and time columns

A Data Analyst is given access to a table of inventory transfers which includes the product details, fulfillment warehouse location, and destination warehouse location. Which type of visualization should be used to illustrate the most active product transfer routes?

• A.Scorecard
• B.Scatterplot
• C.Line chart
• D.Heat grid

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 new schema called ENRICHED in the ADDRESS_DATA database and create this view in the ENRICHED schema.
• B.Create a view in the ADDRESS_DATA database.
• C.Create a view in the GLOBAL_DWH database.
• D.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.

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

A Data Analyst created a model called modelX using SNOWFLAKE.ML.FORECAST. The Analyst needs to predict the next few values and save the result directly into tableX. What step does the Analyst need to take after calling the modelX!FORECAST function?

• A.List the cache content, then use the data saved in the RESULT_SCAN for tableX.
• B.Load the function call results directly INTO tableX.
• C.Create the table by querying the RESULT_SCAN.
• D.Pass the new table as a function argument.