Home / Data Engineer Associate / Objective 6.5

Domain 6: Troubleshooting, Monitoring, and Optimization · 10% of the exam · Full exam outline

6.5 Diagnose cluster startup failures, library conflicts, and out-of-memory issues.

Practice questions

Question 1easy

A classic cluster fails to start and terminates with INIT_SCRIPT_FAILURE, naming a cluster-scoped script stored in a volume. Cluster log delivery is configured. Where should the engineer look first to find the failing command?

Included in Master: master every domain.See plans
Question 2medium

A job computes changes in sensor readings with this query:

SELECT device_id, reading_ts,
reading - LAG(reading) OVER (ORDER BY reading_ts) AS delta
FROM iot.silver.readings

Each delta is meant to compare a reading with the previous reading from the same device. As the table grew, executors started running out of memory in the stage that computes the window. Which change fixes the cause?

Included in Master: master every domain.See plans