Free Snowflake ADA-C02 Exam Dumps Questions & Answers

What are benefits of creating and maintaining resource monitors in Snowflake? (Choose three.)

• A.  Multiple resource monitors can be applied to a single virtual warehouse.
• B.  The cost of running a resource monitor is only 10% of a credit, per day of operation.
• C.  Resource monitors add no additional load to virtual warehouse compute.
• D.  Multiple triggers can be configured across various virtual warehouse thresholds.
• E.  Resource monitor governance is tightly controlled and monitors can only be created by the ACCOUNTADMIN role or users with the CREATE MONITOR privilege.
• F.  Resource monitors can be applied to more than one virtual warehouse.

A virtual warehouse report_wh is configured with AUTO_RESUME=TRUE and AUTO_SUSPEND=300. A user has been granted the role accountant.
An application with the accountant role should use this warehouse to run financial reports, and should keep track of compute credits used by the warehouse.
What minimal privileges on the warehouse should be granted to the role to meet the requirements for the application? (Choose two.)

• A.  MONITOR
• B.  USAGE
• C.  OWNERSHIP
• D.  OPERATE
• E.  MODIFY

A Snowflake Administrator wants to create a virtual warehouse that supports several dashboards, issuing various queries on the same database.
For this warehouse, why should the Administrator consider setting AUTO_SUSPEND to 0 or NULL?

• A.  To save costs by running the warehouse as little as possible
• B.  To keep the query result cache warm for good performance on repeated queries
• C.  To save costs on warehouse shutdowns and startups for different queries
• D.  To keep the data cache warm to support good performance of similar queries

When adding secure views to a share in Snowflake, which function is needed to authorize users from another account to access rows in a base table?

• A.  CURRENT ACCOUNT
• B.  CURRENT CLIENT
• C.  CURRENT USER
• D.  CURRENT ROLE

A retailer uses a TRANSACTIONS table (100M rows, 1.2 TB) that has been clustered by the STORE_ID column (varchar(50)). The vast majority of analyses on this table are grouped by STORE_ID to look at store performance.
There are 1000 stores operated by the retailer but most sales come from only 20 stores. The Administrator notes that most queries are currently experiencing poor pruning, with large amounts of bytes processed by even simple queries.
Why is this occurring?

• A.  The table is not big enough to take advantage of the clustering key.
• B.  Sales across stores are not uniformly distributed.
• C.  The STORE_ID should be numeric.
• D.  The cardinality of the stores to transaction count ratio is too low to use the STORE_ID as a clustering key.