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

Questions 16–20

1. 16application · medium

   A healthcare analytics team has a 'patient_records' table with 10 billion rows. They frequently run point lookups like 'SELECT * FROM patient_records WHERE patient_id = 123456' and also run occasional range queries on the 'admission_date' column. The table is large, and the point lookups are slow. They are considering enabling the Search Optimization Service (SOS). Which statement is correct regarding SOS?

   • ASOS will automatically maintain itself and requires no additional storage cost.
   • BSOS will accelerate both point lookups and range queries on any column.
   • CSOS requires a clustering key on the table to be effective.
   • DSOS will accelerate point lookups on patient_id but will not help with range queries on admission_date.
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   Which type of query is the Search Optimization Service specifically designed to accelerate?

   • AQueries that join multiple large tables.
   • BQueries that use window functions.
   • CPoint lookups and selective queries that return a small number of rows.
   • DLarge aggregations over the entire table.
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   What is the purpose of the ACCOUNTADMIN role in the context of monitoring and alerting?

   • AIt is the only role that can view the Query Profile.
   • BIt is required to run queries on all warehouses.
   • CIt automatically monitors all queries and sends alerts to users.
   • DIt has the privileges to create and manage resource monitors and alerts at the account level.
   Reveal Solution Discussion Select an answer first
5. 19application · medium

   A marketing team runs a dashboard that executes the same aggregation query every 5 minutes on a large 'events' table. The query aggregates data for the last 24 hours and takes 30 seconds to run. The team wants to reduce the load on the warehouse and improve dashboard responsiveness. Which approach is most effective?

   • ACreate a materialized view on the events table for the aggregation.
   • BAdd a clustering key on the event_date column.
   • CIncrease the warehouse size to Large.
   • DEnable result caching on the warehouse.
   Reveal Solution Discussion Select an answer first
6. 20application · medium

   A company has a single X-Large warehouse serving both a critical nightly batch job and an interactive BI dashboard. During the day, the BI dashboard queries are slow, and at night, the batch job is slow. The team wants to isolate workloads and ensure the batch job is not affected by dashboard load. What is the best approach?

   • ASet a resource monitor to limit the dashboard's credit usage.
   • BEnable multi-clustering on the existing warehouse with max clusters = 4.
   • CCreate two separate warehouses: one for the batch job and one for the BI dashboard.
   • DIncrease the warehouse to 2X-Large to provide more capacity for both workloads.
   Reveal Solution Discussion Select an answer first