Databricks Certified Data Analyst Associate · Free Practice Question Medium
Question 2
In a Databricks environment, you're analyzing query performance improvements. After several runs of a complex query on a large dataset, you notice a significant reduction in latency. What feature of Databricks is most likely contributing to this decrease in query execution time?
-
A
Improved data indexing mechanisms.
-
B
Automatic query rewriting for optimization.
-
C
Use of persistent tables instead of temporary views.
-
D
Caching of intermediate data and results from previous query executions.
-
E
Increased hardware resources allocation.
Reveal correct answer
Correct answer: D
Explanation
When a query is run multiple times, Databricks stores the results and intermediate data in cache. Subsequent executions of the same query or those with similar computations can leverage this cached data, leading to significantly reduced query latency. This efficiency gain is particularly notable in complex queries on large datasets, where accessing cached results avoids the need for repeated data processing and computation.
References:
https://learn.microsoft.com/en-us/azure/databricks/sql/admin/query-caching
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
