A team of data analysts needs to run ad-hoc SQL queries on a Delta Lake table. They do not want to manage clusters and want to pay only for the queries they run. Which compute option should they use?

Create an all-purpose cluster with autoscaling.

Create a classic cluster with a fixed size.

Use a job compute cluster for each query.

Create a SQL warehouse with serverless compute.

A team of data engineers needs to run a scheduled ETL job every hour. The job processes a moderate amount of data and typically completes in under 10 minutes. The team wants to minimize costs and avoid managing a persistent cluster. Which compute configuration should they use?

Create an all-purpose cluster with autoscaling and a termination time of 2 hours.

Create a classic cluster with a fixed node count and no termination time.

Create a job compute cluster with autoscaling enabled and a termination time of 30 minutes.

Use a SQL warehouse for the ETL job.

A company uses Azure Databricks for both ad-hoc data exploration and scheduled production jobs. They want to minimize costs by not keeping clusters running when not in use, but they also want to avoid long startup times for interactive users. Which approach best meets these needs?

Use serverless compute for both interactive and job workloads.

Use a job cluster for production jobs and a separate interactive cluster with a short termination time for ad-hoc work.

Use a pool of idle instances for both interactive and job workloads.

Use a single classic cluster for both interactive and job workloads, with a long termination time.

Microsoft Certified:Azure Databricks Data Engineer Associate

Domain 1Objective 1

Select and Configure Compute in a Workspace DP-750 Practice Questions (Page 5)

Part of the Set up and configure an Azure Databricks environment domain, which accounts for 15–20% of the DP-750 exam. Microsoft does not publish an official question count, but from its 120-minute exam (~50–80 total, ~8–16 in this domain), expect 4–8 from this objective — we provide 27 practice questions to prepare you well beyond it. (estimate)

27questions here

6free pages

5concepts

15–20%of the exam

Questions 21–25

21foundation · easy
A data engineer needs to allow a colleague to attach notebooks to a shared cluster but prevent the colleague from modifying the cluster configuration. Which permission level should the engineer grant to the colleague?
Select an answer first
22application · medium
A team of data analysts needs to run ad-hoc SQL queries on a Delta Lake table. They do not want to manage clusters and want to pay only for the queries they run. Which compute option should they use?
Select an answer first
23application · medium
A team of data engineers needs to run a scheduled ETL job every hour. The job processes a moderate amount of data and typically completes in under 10 minutes. The team wants to minimize costs and avoid managing a persistent cluster. Which compute configuration should they use?
Select an answer first
24application · medium
A company uses Azure Databricks for both ad-hoc data exploration and scheduled production jobs. They want to minimize costs by not keeping clusters running when not in use, but they also want to avoid long startup times for interactive users. Which approach best meets these needs?
Select an answer first
25foundation · easy
A data engineer is the creator of a cluster and wants to delegate full control to another team member, including the ability to edit the cluster configuration and manage permissions. Which permission level should the engineer assign?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-750

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 Microsoft. “DP-750” is a trademark of its owner, used for identification only.

Select and Configure Compute in a Workspace DP-750 Practice Questions (Page 5)

Questions 21–25

A data engineer needs to allow a colleague to attach notebooks to a shared cluster but prevent the colleague from modifying the cluster configuration. Which permission level should the engineer grant to the colleague?

A team of data analysts needs to run ad-hoc SQL queries on a Delta Lake table. They do not want to manage clusters and want to pay only for the queries they run. Which compute option should they use?

A team of data engineers needs to run a scheduled ETL job every hour. The job processes a moderate amount of data and typically completes in under 10 minutes. The team wants to minimize costs and avoid managing a persistent cluster. Which compute configuration should they use?

A company uses Azure Databricks for both ad-hoc data exploration and scheduled production jobs. They want to minimize costs by not keeping clusters running when not in use, but they also want to avoid long startup times for interactive users. Which approach best meets these needs?

A data engineer is the creator of a cluster and wants to delegate full control to another team member, including the ability to edit the cluster configuration and manage permissions. Which permission level should the engineer assign?

Keep studying — Set up and configure an Azure Databricks environment