In a SQL query task, how are parameters passed to the query?

Using question marks as positional placeholders

Using named parameters with a colon prefix, e.g., :param

Parameters are not supported in SQL query tasks

Using environment variables in the SQL warehouse

What must be specified when configuring a pipeline task in Lakeflow Jobs?

The SQL warehouse and the query text

The dashboard ID and the refresh schedule

The Delta Live Tables pipeline and the target schema

The notebook path and the compute cluster

In the Lakeflow Jobs UI, how can you add a new task to an existing job?

Clone an existing task and modify it

Use the 'Import' button to import a task from another job

Click the 'Add task' button in the job's task graph view

Upload a JSON file with the task definition

In a Lakeflow Jobs notebook task, how are parameters passed to the notebook?

As command-line arguments in the notebook execution command

As a separate file attached to the task

As environment variables in the cluster configuration

As a JSON string in the task configuration

A data engineering team has a Lakeflow Job with a DAG that includes tasks `A`, `B`, and `C`. Task `C` depends on both `A` and `B`. The team wants to change the DAG so that `C` only depends on `A`, and `B` becomes an independent task that runs in parallel with `A`. What is the correct way to modify the DAG?

Remove `A` from `C`'s dependencies and leave `B` as is.

Remove `B` from `C`'s dependencies and leave `B` as is.

Delete task `B` and then update `C` to depend only on `A`.

Add a dependency from `B` to `A` and remove `B` from `C`'s dependencies.

DatabricksCertified Data Engineer Associate

Domain 4Objective 2

Configure Common Tasks (notebook, SQL Query, Dashboard, and Pipeline Tasks) and Their Dependencies Using Lakeflow Jobs and Its DAG‑based Task Graph DATA-ENGINEER-ASSOCIATE Practice Questions (Page 1)

Part of the Working with Lakeflow Jobs domain, which accounts for 16% of the DATA-ENGINEER-ASSOCIATE exam. Databricks does not publish an official question count, but from its 90-minute exam (~35–60 total, ~6–10 in this domain), expect 2–3 from this objective — we provide 15 practice questions to prepare you well beyond it. (estimate)

15questions here

3free pages

6concepts

16%of the exam

Questions 1–5

1foundation · medium
In a SQL query task, how are parameters passed to the query?
Select an answer first
2foundation · medium
What must be specified when configuring a pipeline task in Lakeflow Jobs?
Select an answer first
3foundation · medium
In the Lakeflow Jobs UI, how can you add a new task to an existing job?
Select an answer first
4foundation · medium
In a Lakeflow Jobs notebook task, how are parameters passed to the notebook?
Select an answer first
5expert · hard
A data engineering team has a Lakeflow Job with a DAG that includes tasks `A`, `B`, and `C`. Task `C` depends on both `A` and `B`. The team wants to change the DAG so that `C` only depends on `A`, and `B` becomes an independent task that runs in parallel with `A`. What is the correct way to modify the DAG?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DATA-ENGINEER-ASSOCIATE

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