Answer-first summary for fast verification
Answer: Accelerated performance for ad hoc and interactive SQL queries.
Configuring Delta tables for Databricks SQL focuses on reducing query latency and improving execution speeds for interactive analysis. This is particularly beneficial for Business Intelligence (BI) and reporting workloads where fast response times for SQL queries are essential.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What is the primary advantage of optimizing Delta tables specifically for Databricks SQL workloads?
A
Enhanced time travel and versioning capabilities.
B
Accelerated performance for ad hoc and interactive SQL queries.
C
Improved write throughput for high-velocity data streams.
D
Automatic partitioning of large-scale datasets.