Optimize Warehouse and Query Performance ARA-C01 Practice Questions (Page 4)

Questions 16–20

1. 16foundation · easy

   What is the primary purpose of defining a clustering key on a large Snowflake table?

   • ATo create an index on the key column for faster lookups.
   • BTo improve query performance by co-locating data with similar values in the same micro-partitions.
   • CTo compress the data in the key column to save storage.
   • DTo enforce uniqueness of the key column values.
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   A user submits a query to a warehouse that is already running at full capacity with all slots occupied. What happens to the query by default?

   • AIt is automatically routed to another warehouse.
   • BIt is queued until a slot becomes available.
   • CIt is run on a separate, temporary warehouse.
   • DIt fails immediately with an error.
   Reveal Solution Discussion Select an answer first
4. 18expert · hard

   A company runs a mix of short, frequent queries and long, complex queries on the same warehouse. The short queries are often delayed by the long queries. The company wants to improve response time for the short queries without significantly increasing cost. What is the best approach?

   • ASet a resource monitor to limit the long queries.
   • BIncrease the warehouse size to a 2XL.
   • CCreate a separate warehouse for the short queries and a separate warehouse for the long queries.
   • DEnable multi-cluster with a maximum of 4 clusters.
   Reveal Solution Discussion Select an answer first
5. 19application · medium

   A team wants to proactively identify when a warehouse is experiencing high queue times so they can take action before users complain. They have access to Snowflake's monitoring views. What should they set up?

   • AA stored procedure that runs once a day to check the query history.
   • BA task that runs every minute and queries the WAREHOUSE_LOAD_HISTORY view, then sends an alert if queue time is high.
   • CA resource monitor that sends an alert when credit usage exceeds a threshold.
   • DAn alert on the QUERY_HISTORY view for any query that takes longer than 5 seconds.
   Reveal Solution Discussion Select an answer first
6. 20foundation · easy

   After a query completes, where can a user view detailed information about the query's execution, such as the amount of data scanned and the time spent in each operation?

   • AThe DESCRIBE QUERY command
   • BQuery Profile in the Snowflake web interface
   • CThe SHOW QUERIES command
   • DThe EXPLAIN output
   Reveal Solution Discussion Select an answer first