Databricks Certified Data Engineer Professional202 questions across 21 pages are complete and free, with no account or card.
202 questions in this bank
Free access · progress saved on this device
What statement is true regarding the retention of job run history?
Answer: C
https://learn.microsoft.com/en-us/azure/databricks/workflows/jobs/monitor-job-runs Azure Databricks maintains a history of your job runs for up to 60 days. If you need to preserve job runs, Databricks recommends exporting results before they expire. For more information, see Export job run results.
Source: Adapted from community discussion — hal2401me
A junior developer complains that the code in their notebook isn't producing the correct results in the development environment. A shared screenshot reveals that while they're using a notebook versioned with Databricks Repos, they're using a personal branch that contains old logic. The desired branch named dev-2.3.9 is not available from the branch selection dropdown. Which approach will allow this developer to review the current logic for this notebook?
Answer: B
The first step is to perform a pull. This fetches all the changes from the remote branch and only after that will you see the dev branch.
Source: Adapted from community discussion — NBurman
A production cluster has 3 executor nodes and uses the same virtual machine type for the driver and executor. When evaluating the Ganglia Metrics for this cluster, which indicator would signal a bottleneck caused by code executing on the driver?
Answer: E
Option E: In a Spark cluster, the driver node is responsible for managing the execution of the Spark application, including scheduling tasks, managing the execution plan, and interacting with the cluster manager. If the overall cluster CPU utilization is low (e.g., around 25%), it may indicate that the driver node is not utilizing the available resources effectively and might be a bottleneck.
Source: Adapted from community discussion — BrianNguyen95
Review the following error traceback:
Which statement describes the error being raised?
Answer: B
It's B. Regarding E, a syntax error would mean that the query is not valid due to a wrongfully written SQL statement. However, this is not the case. The column just does not exist.
Source: Adapted from community discussion — guillesd
Which distribution does Databricks support for installing custom Python code packages?
Answer: D
Which Python variable contains a list of directories to be searched when trying to locate required modules?
Answer: B
sys. path is a built-in variable within the sys module. It contains a list of directories that the interpreter will search in for the required module
Source: Adapted from community discussion — alexvno
Incorporating unit tests into a PySpark application requires upfront attention to the design of your jobs, or a potentially significant refactoring of existing code. Which statement describes a main benefit that offset this additional effort?
Answer: C
D is integration tests (how they relate to each other how connect), E is E2E test, C is "testing individually" which is only one fittign definition of unittest
Source: Adapted from community discussion — nedlo
Which statement describes integration testing?
Answer: A
Integration testing is a type of software testing where components of the software are gradually integrated and then tested as a unified group
Source: Adapted from community discussion — alexvno
A Databricks job has been configured with 3 tasks, each of which is a Databricks notebook. Task A does not depend on other tasks. Tasks B and C run in parallel, with each having a serial dependency on task A. If tasks A and B complete successfully but task C fails during a scheduled run, which statement describes the resulting state?
Answer: A
Should be 'A' only, as ACID compliance is applicable at operation level. For example if task C is having 3 target delta table writes (in independent Notebook cells) then it could have after 1 write the task fails during 2nd write. In that case 1st write will still be persisted. The ACID compliance will be applicable for only the 2nd write.
Source: Adapted from community discussion — IT3008
A Delta Lake table was created with the below query:
Realizing that the original query had a typographical error, the below code was executed: ALTER TABLE prod.sales_by_stor RENAME TO prod.sales_by_store Which result will occur after running the second command?
Answer: A
B is the correct answer. When you alter a table name in Delta Lake, the change is logged in the transaction log that Delta Lake uses to maintain a versioned history of all changes to the table. This is how Delta Lake maintains ACID properties and ensures a consistent view of the data. The transaction log is key to supporting features like time travel, auditing, and rollbacks in Delta Lake. The metadata and the actual data remain intact, and the reference to the table in the metastore is updated to reflect the new name.
Source: Adapted from community discussion — Tamele001
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
DE-PRO practice, question 121. 202 questions available.
Version 1.0.0. How we source questions