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

Questions 11–15

1. 11expert · hard

   A data engineering team runs a nightly ETL job that reads from a Delta table, performs complex transformations, and writes to another Delta table. The job currently uses Spark DataFrames in Python. They want to reduce runtime and cost. They are considering enabling Photon. What is the most important consideration?

   • APhoton does not support write operations, so the job will fail.
   • BPhoton will accelerate the DataFrame operations, but Python UDFs will cause fallback to the JVM engine.
   • CPhoton requires the job to be rewritten in Scala to work.
   • DPhoton only works with SQL, so the DataFrame job will not benefit.
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   Which feature is associated with Photon?

   • ASupport for ANSI SQL
   • BRequirement to use a separate cluster for each query
   • CAutomatic conversion of SQL to Scala
   • DExclusive support for Python UDFs
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   How is Photon enabled on a Databricks cluster?

   • ABy selecting the Photon option when creating or editing the cluster
   • BBy setting a Spark configuration property in the notebook
   • CBy installing a library on the cluster
   • DBy submitting a support request to Databricks
   Reveal Solution Discussion Select an answer first
5. 14expert · hard

   A data analyst is comparing two clusters: one with Photon enabled and one without. Both clusters run the same SQL query on the same Delta table. The analyst notices that the Photon-enabled cluster returns results faster. What is the most likely reason for this performance difference?

   • APhoton uses vectorized execution and columnar processing, which reduces CPU overhead.
   • BPhoton caches the query results in memory, so subsequent runs are faster.
   • CPhoton uses more nodes than the JVM engine.
   • DPhoton uses a different storage format that is faster to read.
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   A company runs a SQL warehouse for ad-hoc analytics. The warehouse is currently on a Standard cluster without Photon. They want to reduce query latency and cost. What should they do?

   • ADisable Delta Lake to reduce overhead.
   • BMove the SQL warehouse to a job cluster to save cost.
   • CEnable Photon on the SQL warehouse and restart it.
   • DIncrease the cluster size to improve performance.
   Reveal Solution Discussion Select an answer first