Examine this statement and output:
You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)
Exam 1z0-908 All QuestionsBrowse all questions from this exam
Question 31
Correct Answer: B, D
To reduce query execution time, focus on queries with the highest average latencies. QN = 5 has the highest average latency of 21.03 seconds and QN = 4 has the second highest average latency of 10.32 seconds. These two queries clearly take significantly more time to execute compared to the others and should be prioritized for optimization.
Discussion
marklvOptions: AE
E. high lock time -- query 2 A. Long execution time, somewhat locking. -- query 3 query 1 looks fine though there are many executions.
alemdba
i think should focus on time -- ms s m us
alemdba
CE i think. E has 358 us letency C has 1 min letency A has only ms lenetcy