exam questions

Exam Certified Data Engineer Professional All Questions

View all questions & answers for the Certified Data Engineer Professional exam

Exam Certified Data Engineer Professional topic 1 question 94 discussion

Actual exam question from Databricks's Certified Data Engineer Professional
Question #: 94
Topic #: 1
[All Certified Data Engineer Professional Questions]

Spill occurs as a result of executing various wide transformations. However, diagnosing spill requires one to proactively look for key indicators.

Where in the Spark UI are two of the primary indicators that a partition is spilling to disk?

  • A. Query’s detail screen and Job’s detail screen
  • B. Stage’s detail screen and Executor’s log files
  • C. Driver’s and Executor’s log files
  • D. Executor’s detail screen and Executor’s log files
  • E. Stage’s detail screen and Query’s detail screen
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
60ties
Highly Voted 1 year, 5 months ago
Selected Answer: B
B is correct
upvoted 7 times
...
vctrhugo
Highly Voted 1 year, 2 months ago
Selected Answer: B
In the Spark UI, the Stage’s detail screen provides key metrics about each stage of a job, including the amount of data that has been spilled to disk. If you see a high number in the “Spill (Memory)” or “Spill (Disk)” columns, it’s an indication that a partition is spilling to disk. The Executor’s log files can also provide valuable information about spill. If a task is spilling a lot of data, you’ll see messages in the logs like “Spilling UnsafeExternalSorter to disk” or “Task memory spill”. These messages indicate that the task ran out of memory and had to spill data to disk.
upvoted 5 times
...
dd1192d
Most Recent 6 months, 4 weeks ago
Selected Answer: B
b
upvoted 1 times
...
jin1991
1 year, 4 months ago
Selected Answer: E
E is correct
upvoted 1 times
jin1991
1 year, 4 months ago
My bad, looking again, B is correct.
upvoted 2 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago