What is the primary purpose of the Query Profiler UI in Databricks?

To schedule and orchestrate data pipelines

To manage user permissions and access control

To monitor cluster health and resource utilization

To analyze query execution details and identify performance bottlenecks

What type of information can be found in the event logs of a Lakeflow Spark Declarative Pipeline?

Only the cluster utilization metrics during the pipeline run

Detailed events such as data quality rule results, task failures, and execution timings

Only the final status of the pipeline run

Only the SQL queries executed by the pipeline

A data engineer prefers using the Databricks CLI for monitoring because they are comfortable with shell scripting. They want to list all job runs for a specific job that occurred in the last 24 hours and see their status. Which CLI command should they use?

databricks clusters list --job-id

databricks jobs runs list --job-id --limit 10

databricks jobs list --run-status

A data engineer is troubleshooting a slow-running Spark job. They suspect that a particular stage is experiencing significant data skew, causing some tasks to take much longer than others. They want to confirm this by examining the task-level metrics. Which combination of tools should they use?

Run the Databricks CLI command 'databricks runs get' to retrieve the job run's output and look for any error messages about skew.

Query the system.compute.cluster_details table to see the cluster's autoscaling metrics and identify if the cluster scaled down during the job.

Use the Spark UI to view the stage's task list and sort by duration, then check the 'Shuffle Read Size/Records' column for outliers.

Use the Query Profiler UI to view the operator-level metrics for the SQL query that launched the Spark job.

DatabricksCertified Data Engineer Professional

Domain 5Objective 1

Monitoring DATA-ENGINEER-PROFESSIONAL Practice Questions (Page 5)

Part of the Monitoring and Alerting domain, which accounts for 10% of the DATA-ENGINEER-PROFESSIONAL exam. Databricks does not publish an official question count, but from its 120-minute exam (~50–80 total, ~5–8 in this domain), expect 3–4 from this objective — we provide 27 practice questions to prepare you well beyond it. (estimate)

27questions here

6free pages

8concepts

10%of the exam

Questions 21–25

21foundation · easy
What is the primary purpose of the Query Profiler UI in Databricks?
Select an answer first
22foundation · easy
What type of information can be found in the event logs of a Lakeflow Spark Declarative Pipeline?
Select an answer first
23application · medium
A data engineer prefers using the Databricks CLI for monitoring because they are comfortable with shell scripting. They want to list all job runs for a specific job that occurred in the last 24 hours and see their status. Which CLI command should they use?
Select an answer first
24application · medium
A data engineer is troubleshooting a slow-running Spark job. They suspect that a particular stage is experiencing significant data skew, causing some tasks to take much longer than others. They want to confirm this by examining the task-level metrics. Which combination of tools should they use?
Select an answer first
25foundation · easy
Which Spark UI tab provides information about the memory and disk usage of each executor?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DATA-ENGINEER-PROFESSIONAL

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Databricks. “DATA-ENGINEER-PROFESSIONAL” is a trademark of its owner, used for identification only.