A team has a cluster with Photon enabled, but they notice that some SQL queries are still slow. They suspect that Photon is not being used for all queries. What is a possible reason?

The queries are reading from external tables, which Photon does not support.

Photon only works on clusters with a specific runtime version.

Photon is only used for queries that run longer than a minute.

The queries use unsupported operations, causing fallback to the JVM engine.

A data analyst runs a daily SQL dashboard that aggregates billions of rows from Delta Lake tables. The cluster currently uses the standard JVM-based engine, and the dashboard takes over an hour to complete. The analyst wants to reduce runtime without changing the SQL code or the underlying data. Which action should the analyst take?

Increase the number of retries for the dashboard query.

Switch the cluster to a single-node cluster to reduce network overhead.

Rewrite the SQL to use only basic SELECT and WHERE clauses.

Enable Photon on the cluster and restart it.

A company runs a mix of workloads on a shared cluster: interactive SQL queries from Tableau, batch ETL jobs that read and write Delta tables, and Python pandas code that runs on the driver. The team wants to improve SQL performance but is concerned about breaking the pandas code. What should they do?

Create a separate cluster for pandas and keep the original cluster without Photon.

Disable the JVM engine and run everything on Photon.

Enable Photon and rewrite all pandas code to use SQL.

Enable Photon on the cluster; pandas code will continue to run on the JVM.

Which statement best describes the role of Photon in Databricks?

It accelerates query execution by using vectorized processing.

It replaces the need for Delta Lake in data storage.

It provides an alternative to Spark SQL for querying data.

It manages cluster autoscaling based on query load.

Which of the following workloads is supported by Photon?

Machine learning model training with TensorFlow

Data visualization in dashboards

DatabricksCertified Data Analyst Associate

Domain 5Objective 1

Understand the Features, Benefits, and Supported Workloads of Photon. DATA-ANALYST-ASSOCIATE Practice Questions (Page 4)

Part of the Section 5: Analyzing Queries domain, which makes up ~17% of our current practice bank. Databricks does not publish an official question count, but from its 90-minute exam (~35–60 total, ~6–10 in this domain), expect 1–2 from this objective — we provide 21 practice questions to prepare you well beyond it. (estimate)

21questions here

5free pages

5concepts

Questions 16–20

16application · medium
A team has a cluster with Photon enabled, but they notice that some SQL queries are still slow. They suspect that Photon is not being used for all queries. What is a possible reason?
Select an answer first
17application · medium
A data analyst runs a daily SQL dashboard that aggregates billions of rows from Delta Lake tables. The cluster currently uses the standard JVM-based engine, and the dashboard takes over an hour to complete. The analyst wants to reduce runtime without changing the SQL code or the underlying data. Which action should the analyst take?
Select an answer first
18application · medium
A company runs a mix of workloads on a shared cluster: interactive SQL queries from Tableau, batch ETL jobs that read and write Delta tables, and Python pandas code that runs on the driver. The team wants to improve SQL performance but is concerned about breaking the pandas code. What should they do?
Select an answer first
19foundation · easy
Which statement best describes the role of Photon in Databricks?
Select an answer first
20foundation · easy
Which of the following workloads is supported by Photon?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DATA-ANALYST-ASSOCIATE

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Databricks. “DATA-ANALYST-ASSOCIATE” is a trademark of its owner, used for identification only.

Understand the Features, Benefits, and Supported Workloads of Photon. DATA-ANALYST-ASSOCIATE Practice Questions (Page 4)

Questions 16–20

A team has a cluster with Photon enabled, but they notice that some SQL queries are still slow. They suspect that Photon is not being used for all queries. What is a possible reason?

Which statement best describes the role of Photon in Databricks?

Which of the following workloads is supported by Photon?

Keep studying — Section 5: Analyzing Queries