nerdexam
Databricks

DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE · Question #22

Which of the following describes a scenario in which a data engineer will want to use a single- node cluster?

The correct answer is A. When they are working interactively with a small amount of data. A single-node cluster runs only a driver with no worker nodes, making it lightweight and inexpensive. It is best suited for interactive, exploratory work on small datasets where distributed computing is unnecessary. For automated reports requiring speed (B), large-scale SQL…

Submitted by chen.hong· Apr 18, 2026Databricks Lakehouse Platform

Question

Which of the following describes a scenario in which a data engineer will want to use a single- node cluster?

Options

  • AWhen they are working interactively with a small amount of data
  • BWhen they are running automated reports to be refreshed as quickly as possible
  • CWhen they are working with SQL within Databricks SQL
  • DWhen they are concerned about the ability to automatically scale with larger data
  • EWhen they are manually running reports with a large amount of data

How the community answered

(62 responses)
  • A
    95% (59)
  • C
    2% (1)
  • D
    3% (2)

Explanation

A single-node cluster runs only a driver with no worker nodes, making it lightweight and inexpensive. It is best suited for interactive, exploratory work on small datasets where distributed computing is unnecessary. For automated reports requiring speed (B), large-scale SQL workloads via Databricks SQL (C), autoscaling needs (D), or large data processing (E), a multi-node cluster is required to distribute the workload and handle increased data volume.

Topics

#Databricks Clusters#Single-node Compute#Workload Management#Interactive Workloads

Community Discussion

No community discussion yet for this question.

Full DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE Practice