SnowflakeSnowflake
ARA-C01 · Question #149
ARA-C01 Question #149: Real Exam Question with Answer & Explanation
Sign in or unlock ARA-C01 to reveal the answer and full explanation for question #149. The question stem and answer options stay visible for context.
Performance Optimization
Question
The Business Intelligence team reports that when some team members run queries for their dashboards in parallel with others, the query response time is getting significantly slower What can a Snowflake Architect do to identify what is occurring and troubleshoot this issue? A. B. C. D.
Options
- AReview the Query Profile in Snowsight to identify bottlenecks and use the AUTO_SUSPEND and AUTO_RESUME features to manage warehouse resources
- BUse the QUERY_HISTORY view in the ACCOUNT_USAGE schema to analyze query execution times and identify resource contention, then consider using multi-cluster warehouses to handle concurrent workloads
- CEnable the Query Acceleration Service for the warehouse and review the WAREHOUSE_METERING_HISTORY to understand usage patterns
- DReview the RESOURCE_MONITOR settings and create separate warehouses for different teams to isolate workloads and prevent resource contention
Unlock ARA-C01 to see the answer
You've previewed enough free ARA-C01 questions. Unlock ARA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Query Performance#Concurrency#Performance Monitoring#Troubleshooting