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

Questions 6–10

1. 6foundation · easy

   Which Snowflake feature automatically maintains pre-computed results of a query and can be used to speed up queries that match its definition?

   • ASearch optimization service
   • BClustering key
   • CQuery result cache
   • DMaterialized view
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   An administrator notices that queries are frequently queued during peak hours, causing delays. Which warehouse configuration change would directly reduce query queuing by increasing the number of concurrent queries that can run?

   • AEnable multi-cluster scaling on the warehouse.
   • BSet auto-resume to false.
   • CDecrease the warehouse size.
   • DIncrease the auto-suspend timeout.
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A team frequently runs a query that filters on a column with high cardinality (e.g., ORDER_ID) and returns a small result set. The query is run many times a day, but the underlying data changes frequently. The team wants to reduce query latency. What is the best approach?

   • AAdd a clustering key on the ORDER_ID column.
   • BCreate a materialized view on the table.
   • CRely on the query result cache.
   • DEnable the SEARCH OPTIMIZATION SERVICE on the ORDER_ID column.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   A query performs a GROUP BY on a column that is not a clustering key. What is a potential performance issue?

   • AThe query will return incorrect results because the data is not clustered.
   • BThe query may need to shuffle data across nodes to group rows with the same key value.
   • CThe query will automatically use a larger warehouse to handle the aggregation.
   • DThe query will fail because GROUP BY requires a clustering key.
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   Which Snowflake view or table provides historical information about warehouse credit usage and query performance?

   • AINFORMATION_SCHEMA.WAREHOUSE_METERING_HISTORY
   • BINFORMATION_SCHEMA.USERS
   • CINFORMATION_SCHEMA.QUERY_HISTORY
   • DINFORMATION_SCHEMA.TABLES
   Reveal Solution Discussion Select an answer first