Design Scalable Snowflake Solutions ARA-C01 Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   What does the 'ECONOMY' scaling policy do in a multi-cluster warehouse?

   • AIt adds clusters immediately to minimize query latency
   • BIt limits the maximum number of clusters to one
   • CIt prioritizes cost savings by adding clusters less aggressively
   • DIt disables auto-suspend to keep clusters running
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which Snowflake feature allows a virtual warehouse to automatically add or remove compute resources based on the number of concurrent queries?

   • AMulti-cluster warehouse with scaling policy set to STANDARD
   • BResource monitors
   • CClustering keys
   • DAuto-suspend and auto-resume settings
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Which feature can improve query performance by pre-aggregating data in Snowflake?

   • AResource monitors
   • BMaterialized views
   • CClustering keys
   • DData sharing
   Reveal Solution Discussion Select an answer first
5. 4application · medium

   A logistics company stores shipment tracking data in Snowflake. The data is partitioned by date, and queries frequently filter on the `shipment_status` column. The table has grown to 50 TB, and query performance has degraded. The team has already applied a clustering key on the date column. What should they do to improve query performance without increasing warehouse size?

   • AEnable search optimization on the table.
   • BCreate a separate table for each shipment status.
   • CAdd `shipment_status` as a second clustering key on the table.
   • DUse a larger warehouse to scan the data faster.
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   When a suspended warehouse receives a new query, what happens?

   • AThe query is queued until the warehouse is manually resumed
   • BThe query fails because the warehouse is suspended
   • CThe query is redirected to a different warehouse
   • DThe warehouse automatically resumes to process the query
   Reveal Solution Discussion Select an answer first