Answer-first summary for fast verification
Answer: It is easy to migrate existing SQL queries to Databricks SQL
The correct answer is B because ANSI SQL compatibility makes it easy to migrate existing SQL queries from other database systems to Databricks SQL without significant rewrites. This is a well-documented benefit of ANSI SQL adoption. Option A is incorrect as ANSI SQL is actually less customizable than proprietary dialects. Option C is incorrect because Photon optimizations work regardless of SQL dialect. Option D is incorrect as performance depends on the underlying engine, not the SQL dialect standard. Option E is incorrect because ANSI SQL is a standard that works across systems, not specifically tied to Spark interpreters.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which of the following is a benefit of using ANSI SQL as the standard SQL dialect in Databricks SQL?
A
It has increased customization capabilities
B
It is easy to migrate existing SQL queries to Databricks SQL
C
It allows for the use of Photon's computation optimizations
D
It is more performant than other SQL dialects
E
It is more compatible with Spark's interpreters
No comments yet.