Snowflake
DEA-C02 · Question #25
A Data Engineer is evaluating the performance of a query in a development environment. Based on the Query Profile, what are some performance tuning options the Engineer can use? (Choose two.)
Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #25. The question stem and answer options stay visible for context.
Performance Optimization
Question
A Data Engineer is evaluating the performance of a query in a development environment. Based on the Query Profile, what are some performance tuning options the Engineer can use? (Choose two.)
Exhibit
Options
- AAdd a LIMIT to the ORDER BY if possible
- BUse a multi-cluster virtual warehouse with the scaling policy set to standard
- CMove the query to a larger virtual warehouse
- DCreate indexes to ensure sorted access to data
- EIncrease the MAX_CLUSTER_COUNT
Unlock DEA-C02 to see the answer
You've previewed enough free DEA-C02 questions. Unlock DEA-C02 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#Virtual Warehouses#SQL Optimization