Home / Data Engineer Associate / Objective 4.2

Domain 4: Working with Lakeflow Jobs · 16% of the exam · Full exam outline

4.2 Configure common tasks (notebook, SQL query, dashboard, and pipeline tasks) and their dependencies using Lakeflow Jobs and its DAG-based task graph

Practice questions

Question 1easy

A data engineer adds a SQL task to a Lakeflow Jobs job to run a saved query after the nightly load. Which compute can this task use?

Included in Sample: sample every domain.See plans

Choose an answer to check it. Afterward, select any option to review its explanation.

SQL tasks run on Databricks SQL and need a serverless or pro SQL warehouse; the query, alert or file runs against the warehouse selected in the task.

Job clusters serve tasks such as notebooks and scripts; a SQL task needs a SQL warehouse instead of a cluster.

Any SQL warehouse may seem acceptable, but the SQL task requirement names only serverless or pro warehouses, so a classic one does not qualify.

All-purpose clusters run notebooks and other code tasks, but a SQL task is configured against a SQL warehouse.

Question 2easy

In a job's task graph, an engineer clones a transform task that depends on two upstream load tasks. What does the cloned task contain?

Included in Master: master every domain.See plans