DatabricksCertified Data Engineer Professional
Domain 6Objective 5
Use the Query Profile to Analyze the Query and Identify Bottlenecks, Such as Bad Data Skipping, Inefficient Types of Joins, and Data Shuffling. DATA-ENGINEER-PROFESSIONAL Practice Questions (Page 3)
Part of the Cost & Performance Optimization domain, which accounts for 13% of the DATA-ENGINEER-PROFESSIONAL exam. Databricks does not publish an official question count, but from its 120-minute exam (~50–80 total, ~7–10 in this domain), expect 1–2 from this objective — we provide 17 practice questions to prepare you well beyond it. (estimate)
17questions here
4free pages
5concepts
13%of the exam
Questions 11–15
- 11
In the query profile, which observation most directly indicates a data skew problem?
Select an answer first - 12
Which metric in the Databricks query profile indicates the total time spent by all tasks in a stage, useful for identifying stages that dominate execution time?
Select an answer first - 13
A query profile shows a stage with a 'Shuffle Write' of 500 GB and a 'Shuffle Read' of 500 GB. The stage is a join between two tables on a column that is not skewed. The join is a SortMergeJoin. The engineer wants to reduce the shuffle. Which of the following is the most effective approach?
Select an answer first - 14
A query profile shows a stage with a 'Shuffle Write' of 1 TB and a 'Shuffle Read' of 1 TB. The stage is a groupBy operation on a column with 10 million distinct values. The cluster has 100 executors. Which of the following is the most likely cause of the high shuffle?
Select an answer first - 15
In the query profile, which join type is generally most efficient when one side of the join is small enough to fit in memory?
Select an answer first
Finished these 5 questions?
Review the revealed explanations, or continue through the curriculum.
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.