ExamTopics Logo
Mail Us[email protected]
Menu
Databricks Discussions
exam questions

Exam Certified Data Engineer Professional All Questions

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

Exam Certified Data Engineer Professional topic 1 question 219 discussion

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

A user new to Databricks is trying to troubleshoot long execution times for some pipeline logic they are working on. Presently, the user is executing code cell-by-cell, using display() calls to confirm code is producing the logically correct results as new transformations are added to an operation. To get a measure of average time to execute, the user is running each cell multiple times interactively.

Which of the following adjustments will get a more accurate measure of how code is likely to perform in production?

  • A. The Jobs UI should be leveraged to occasionally run the notebook as a job and track execution time during incremental code development because Photon can only be enabled on clusters launched for scheduled jobs.
  • B. The only way to meaningfully troubleshoot code execution times in development notebooks is to use production-sized data and production-sized clusters with Run All execution.
  • C. Production code development should only be done using an IDE; executing code against a local build of open source Spark and Delta Lake will provide the most accurate benchmarks for how code will perform in production.
  • D. Calling display() forces a job to trigger, while many transformations will only add to the logical query plan; because of caching, repeated execution of the same logic does not provide meaningful results.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by Bishal at Dec. 28, 2024, 2:09 p.m.

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
Submit Cancel
kishanu
2 weeks, 6 days ago
Selected Answer: D
Using display() will force the job to trigger and hence won't be tested as per production
upvoted 1 times
...
kishanu
2 weeks, 6 days ago
Selected Answer: D
Using display() will force the job to trigger and hence won't be tested as per production
upvoted 1 times
...
suranga4
1 month, 1 week ago
Selected Answer: B
B is the right answer
upvoted 1 times
...
mohadjhamad
1 month, 1 week ago
Selected Answer: D
Calling display() forces a job to trigger,
upvoted 1 times
...
mouthwash
3 months, 3 weeks ago
Selected Answer: B
B is the right answer.
upvoted 1 times
...
arekm
4 months ago
Selected Answer: B
B - this is a repeated question. You need production like data & environment to be able to troubleshoot the performance issues. display() does introduce overhead, but we use it here to investigate, where the problems start to surface. We still need the production like env and data first.
upvoted 1 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago