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.)
Exam SnowPro Advanced Data Engineer All QuestionsBrowse all questions from this exam
Question 25
Correct Answer: A, C
To improve the performance of the query, one option is to add a LIMIT to the ORDER BY clause. Adding a LIMIT can reduce the amount of data processed, which will result in faster query execution times, especially if only a subset of the results is needed. Another option is to move the query to a larger virtual warehouse. Using a larger virtual warehouse provides more resources (CPU, memory), which can significantly enhance the processing power and reduce execution time for large queries.
Discussion
Eshkin_KotOptions: AC
Why not D? It doesn't say we don't need all the data, so why LIMIT (option A)? Agree with C
mns0173
there are no indexes in snowflake. And also based on context looks like dev just run this query in some kind of query editor and in such case obviously do not need to return gigabytes of data.
BigDataBBOptions: AB
Snowflake don't support the create of index, You can cluster a table by a cluster key, but this option is not in the list of option. in addition to this in the question is write that You are in DEV environment. So You don't need to have all the data but to know how SF process them.
stopthisnowOptions: AC
AC makes sense