Free Access Snowflake.DAA-C01.v2025-12-20.q172 Practice Test (Page 2)

Question 1

Which considerations are part of best practice for ensuring data integrity structures in Snowflake?
(Select all that apply)

A.Establishing parent-child table joins

B.Ensuring data normalization

C.Implementing redundant constraints

D.Using primary keys for tables

Question 2

You have developed a Snowsight dashboard for your marketing team that contains sensitive customer data'. You need to share this dashboard with a specific group of users, but ensure that they can only view the data and cannot modify the dashboard itself or the underlying queries. Which of the following steps should you take to securely share the dashboard?

A.Share the dashboard with the group using the 'Can edit' permission. Then, grant the users in the group the 'USAGE' privilege on the database and schema containing the data.

B.Share the dashboard with the group using the 'Can view' permission. Ensure the group has the 'SELECT' privilege on the tables/views used in the queries and the ' USAGE privilege on the database and schema. Also ensure that any intermediate tables created by the dashboard are also granted these privleges.

C.Share the dashboard with the group using the 'Can view' permission. Then, grant the users in the group the 'MONITOR privilege on the virtual warehouse used by Snowsight.

D.Create a scheduled task to export the dashboard as a PDF and email it to the group on a daily basis.

E.Share the dashboard with 'Can view' permission and no further action is required.

Question 3

A data analyst is building a dashboard in Tableau connected to Snowflake. The dashboard needs to display the average order value (AOV) for each product category over the last quarter. The Snowflake table 'ORDERS contains columns: 'ORDER ID' , 'ORDER DATE', 'PRODUCT CATEGORY' , and 'ORDER VALUE'. The analyst wants to minimize data transfer from Snowflake to Tableau and optimize dashboard performance. Which of the following approaches is MOST efficient?

A.Extract all data from the 'ORDERS' table into Tableau and calculate the AOV within Tableau.

B.Use Tableau's Custom SQL feature to execute a query that calculates the AOV directly in Snowflake and retrieves only the aggregated results.

C.Create a Snowflake view that calculates the AOV and connect Tableau to the view.

D.Schedule a daily task to export AOV data from Snowflake into a CSV file, and use Tableau to read from the CSV file.

E.Create a Snowflake stored procedure to calculate the AOV and call the stored procedure from Tableau using ODBC connection.

Question 4

How do stored procedures contribute to the efficiency of data analysis using SQL?

A.Stored procedures can't be used in conjunction with user-defined functions (UDFs).

B.Stored procedures enable the execution of repetitive tasks, enhancing efficiency.

C.They solely facilitate basic arithmetic operations.

D.They limit data accessibility, hindering analysis.

Question 5

You are working with a table 'ORDERS' containing order data, and a table 'CUSTOMER SEGMENTS containing customer segment information. The 'ORDERS' table has columns 'ORDER ID', 'CUSTOMER ID, and 'ORDER AMOUNT'. The 'CUSTOMER SEGMENTS' table has columns 'CUSTOMER ID', 'SEGMENT ID', and 'SEGMENT NAME'. You need to create a query that enriches the 'ORDERS' table with the customer segment information. However, a customer can belong to multiple segments. You want to include all segments a customer belongs to in the enriched data, resulting in potentially multiple rows per order if the customer is in multiple segments. The output should include 'ORDER ID, 'ORDER AMOUNT, 'SEGMENT ID', and 'SEGMENT NAMES. Which SQL statement would correctly enrich the ORDERS table without losing any order information, even if customers belong to multiple segments?