Monitor and Tune Workloads ARA-C01 Practice Questions (Page 3)

Questions 11–15

1. 11foundation · easy

   A team runs a mix of short, frequent queries and occasional long-running reports. They want to minimize cost while keeping the short queries responsive. Which warehouse configuration is most appropriate?

   • AA multi-cluster warehouse with a high max cluster count.
   • BA single small warehouse for all queries to minimize cost.
   • CA single large warehouse with auto-suspend set to 10 minutes.
   • DTwo warehouses: a small one for short queries and a larger one for reports, each with appropriate auto-suspend settings.
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   What is the main trade-off when enabling the Search Optimization Service on a table?

   • AIt requires the table to be replicated to another region.
   • BIt increases storage costs and adds overhead to DML operations.
   • CIt reduces the maximum number of columns allowed in the table.
   • DIt prevents the table from being clustered.
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A data engineering team reports that a nightly ETL job's final INSERT INTO ... SELECT query has been running 3x longer over the past week. Reviewing the Query Profile, you see the 'TableScan' node shows 85% of the total execution time, with 2.1 TB scanned and 1.8 TB spilled to local storage. The warehouse is a Medium (X-Small) with multi-cluster enabled (max 2). The source table is 4 TB and has no clustering key. Which action will most directly address the bottleneck shown in the profile?

   • ACreate a materialized view on the source table for the columns used in the SELECT list.
   • BIncrease the warehouse to Large and set multi-cluster max to 4.
   • CReview the query's WHERE clause and ensure it is selective; if not, add a filter to reduce the scanned partitions.
   • DAdd a clustering key on the source table's date column and run a manual re-cluster.
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   A table is frequently queried with filters on the 'order_date' column and the 'customer_id' column. Which clustering key would be most appropriate for these queries?

   • AA composite clustering key on ('order_date', 'customer_id').
   • BA single clustering key on 'order_date' only.
   • CNo clustering key, because clustering is automatic.
   • DA clustering key on 'customer_id' only.
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   What is the primary purpose of Automatic Clustering in Snowflake?

   • ATo continuously maintain the clustering of a table that has a clustering key, without manual intervention.
   • BTo automatically scale warehouses based on query load.
   • CTo automatically optimize query execution plans.
   • DTo automatically create clustering keys on tables based on query patterns.
   Reveal Solution Discussion Select an answer first