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

Questions 26–30

1. 26foundation · easy

   A team has a variable workload with unpredictable spikes in concurrent query demand. They want to ensure that queries are not queued during peak times without manually resizing the warehouse. Which scaling strategy should they use?

   • ASet the warehouse to a larger size, such as L, to handle the peak demand.
   • BCreate multiple warehouses and route queries to them manually.
   • CEnable multi-cluster scaling with a minimum and maximum cluster count.
   • DUse auto-suspend and auto-resume to handle the spikes.
   Reveal Solution Discussion Select an answer first
2. 27foundation · easy

   A data engineer needs to run a one-time, heavy transformation that will take several hours on a single XS warehouse. The engineer wants to minimize the elapsed time for this job while keeping the warehouse configuration simple. Which warehouse sizing approach best meets this requirement?

   • ACreate a new warehouse with a larger size, such as 2XL, run the job, and then drop the warehouse.
   • BKeep the XS warehouse and rely on auto-scaling to increase the size during the job.
   • CUse a larger warehouse size and enable multi-cluster to distribute the transformation across clusters.
   • DEnable multi-cluster on the existing XS warehouse with a max cluster count of 4.
   Reveal Solution Discussion Select an answer first
4. 28foundation · easy

   Which Snowflake feature is designed to accelerate point lookup queries on a large table, such as finding a single row by a specific ID?

   • ASearch optimization service
   • BQuery result cache
   • CClustering key
   • DMaterialized view
   Reveal Solution Discussion Select an answer first
5. 29foundation · easy

   A warehouse is configured with multi-cluster scaling enabled. The administrator wants to ensure that at least one cluster is always available to serve queries, but also wants to allow the warehouse to scale out during peak times. Which configuration setting controls the minimum number of clusters?

   • AMIN_CLUSTER_COUNT
   • BMAX_CLUSTER_COUNT
   • CAUTO_SUSPEND
   • DWAREHOUSE_SIZE
   Reveal Solution Discussion Select an answer first
6. 30foundation · easy

   An administrator wants to be notified when a warehouse's credit usage exceeds a certain threshold. Which Snowflake feature can be used to send an alert?

   • AAccess control policy
   • BResource monitor with an alert action
   • CWarehouse scaling policy
   • DQuery profile
   Reveal Solution Discussion Select an answer first