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

Questions 1–5

1. 1application · medium

   A data analyst is troubleshooting a slow SQL query that runs on a cluster with Photon enabled. The query uses a UDF (user-defined function) written in Python. What is the most likely reason the query is not benefiting from Photon?

   • APhoton cannot accelerate Python UDFs, so the query falls back to the JVM engine.
   • BPhoton requires all UDFs to be written in Scala.
   • CPhoton is disabled when a UDF is present, but the query still runs on the vectorized engine.
   • DPhoton only works with SQL, not with DataFrames, so the UDF is ignored.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which of the following is a key feature of Photon?

   • ARequirement to store data in a proprietary format
   • BCompatibility with Delta Lake
   • CInability to work with DataFrame API
   • DSupport for only a limited subset of SQL functions
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   What is a primary benefit of using Photon for SQL workloads?

   • AIt eliminates the need for cluster configuration.
   • BIt improves query performance, which can lower compute costs for the same workload.
   • CIt reduces the need for data partitioning.
   • DIt automatically converts all SQL queries to Python.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   What happens when Photon is enabled on a cluster?

   • AThe cluster must be restarted after enabling Photon.
   • BAll queries on the cluster automatically use Photon for execution.
   • COnly SQL queries use Photon, while DataFrame operations run on the standard engine.
   • DQueries require manual opt-in per query to use Photon.
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A data analyst is explaining to a colleague why a query on a Delta table runs faster on a Photon-enabled cluster. Which statement accurately describes Photon's role?

   • APhoton is a vectorized query engine that processes data in a columnar format, reducing CPU overhead.
   • BPhoton is a storage format that replaces Delta Lake.
   • CPhoton is a caching layer that stores query results in memory.
   • DPhoton is a scheduling tool that optimizes cluster resource allocation.
   Reveal Solution Discussion Select an answer first