Home / Data Analyst practice test / Analyzing Queries / Question

Databricks Data Analyst Associate · free practice question

A data engineering team wants to speed up large-scale SQL aggregations and Delta table MERGE operations without changing any code. They are evaluating whether…

Exam-style question on Analyzing Queries from the free Data Analyst practice test, with the answer and a full explanation below.

Updated November 10, 2026

Analyzing Queries

A data engineering team wants to speed up large-scale SQL aggregations and Delta table MERGE operations without changing any code. They are evaluating whether to enable Photon. Which statement MOST accurately describes Photon's capabilities and limitations?

  1. APhoton is a vectorized engine that accelerates SQL, DataFrame, Python UDF, RDD and Dataset API workloads alike, so it serves as a drop-in replacement for the standard Spark runtime across workload types
  2. BPhoton is an open-source query engine that Databricks integrates as an option; it is incompatible with Apache Spark APIs, so existing PySpark and Spark SQL code has to be rewritten before it runs
  3. CPhoton is a vectorized engine that can accelerate SQL and Delta write workloads, but it brings a benefit to queries that run longer than 30 seconds, which rules out short dashboard refresh queries
  4. DPhoton is a vectorized engine offered on serverless SQL warehouses and not on interactive or jobs clusters, which limits its use to SQL editor and dashboard workloads rather than MERGE pipelines
  5. EPhoton is a Databricks-native vectorized engine that accelerates SQL and DataFrame workloads and Delta writes such as MERGE INTO and UPDATE, but it does not support Python UDFs, RDD APIs or Dataset APIs
Answer & explanation

Correct answer: E

WHY E: Photon is Databricks' native vectorized engine. It accelerates SQL and DataFrame operations on Delta and Parquet, replaces sort-merge joins with hash-joins, improves Delta write performance (MERGE, UPDATE, DELETE, INSERT, CTAS), and is compatible with Apache Spark APIs, so no code changes are needed. It does not support Python UDFs, RDD APIs, or Dataset APIs.

WHY NOT A: Photon does not support UDFs, RDDs, or the Dataset API; it falls back to the standard engine for those operations, so it is not a universal replacement for the Spark runtime.

WHY NOT C: The documented threshold is two seconds, not 30: Photon does not impact queries that already run in under two seconds.

WHY NOT D: Photon runs by default on SQL warehouses and serverless compute, and it can also be enabled on all-purpose and jobs clusters.

WHY NOT B: Photon is a Databricks-proprietary engine that is fully compatible with Apache Spark APIs and requires no code rewrites.

Take the full Data Analyst practice test free →

Would you pass today?

This question is one of 45 in the free, timed Databricks Data Analyst Associate practice test. Take it and get a section-by-section score.

Start the free test →