Free Snowflake DAA-C01 Exam Dumps Questions & Answers

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 lose access to the worksheet, their permissions on the worksheet are revoked.
• B.The original users gain additional access to the worksheet.
• C.The original users temporarily lose access but regain it once the dashboard is created.
• D.The original users retain access and permissions on the worksheet.

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.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.
• D.Create a view in the GLOBAL_DWH database.

A Data Analyst needs to temporarily hide a tile in a dashboard. The data will need to be available in the future, and additional data may be added. Which tile should be used?

• A.Delete
• B.Unplace
• C.Show/Hide
• D.Duplicate

A Data Analyst executes a query in a Snowflake worksheet that returns the total number of daily sales, and the total amount for each sale. How can the Analyst check the distribution of the total amount, without running the query again?

• A.Go to Chart and select a histogram that includes the two variables.
• B.Call the WIDTH_BUCKET function.
• C.Click on the column header in the results and review the histogram.
• D.Go to Chart and select a bar chart that contains the two variables.

A Data Analyst creates and populates the following table:
create or replace table aggr(v int) as select * from values (1), (2), (3), (4); The Analyst then executes this query:
select percentile_disc(0.60) within group (order by v desc) from aggr;
What will be the result?

• A.4
• B.2
• C.3
• D.1