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 2)

Questions 6–10

1. 6foundation · medium

   When configuring a SQL query task in Lakeflow Jobs, which compute resource is required?

   • AA job cluster
   • BA SQL warehouse
   • CAn interactive cluster
   • DA Delta Live Tables pipeline
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A data engineering team uses Delta Live Tables (DLT) to build a medallion architecture. They have a DLT pipeline named `sales_pipeline` that processes raw data into bronze, silver, and gold tables. The team wants to trigger this pipeline from a Lakeflow Job after a data ingestion task completes. Which task configuration should they use?

   • AAdd a pipeline task that selects `sales_pipeline` and specifies the target schema for the gold tables.
   • BAdd a dashboard task that monitors the pipeline's output tables, assuming the pipeline runs on its own schedule.
   • CAdd a SQL query task that executes `REFRESH TABLE` on the gold tables to update them.
   • DAdd a notebook task that runs the DLT pipeline code directly, bypassing the pipeline definition.
   Reveal Solution Discussion Select an answer first
4. 8foundation · medium

   In a Lakeflow Jobs DAG, how is a dependency between two tasks defined?

   • ABy setting the upstream task as a prerequisite for the downstream task
   • BBy naming the tasks with a common prefix
   • CBy assigning the same compute resource to both tasks
   • DBy placing the tasks in the same folder
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A data science team has a Lakeflow Job that runs a notebook task `train_model`. The notebook requires a specific cluster configuration with GPU support and a specific runtime version. The team wants to ensure the notebook always runs on the correct compute. What should they configure in the notebook task?

   • AUse the default cluster for the job and hope it has GPU support.
   • BSpecify the cluster ID or cluster configuration in the notebook task settings.
   • CAdd a SQL query task before the notebook task to check the cluster's GPU availability.
   • DSet the notebook task to run on a serverless compute that automatically scales.
   Reveal Solution Discussion Select an answer first
6. 10foundation · medium

   When a dashboard task runs, what happens?

   • AThe dashboard's underlying queries are executed and the dashboard is refreshed
   • BThe dashboard is recreated from scratch with new visualizations
   • CThe dashboard is exported as a PDF and sent to subscribers
   • DThe dashboard's SQL warehouse is started and stopped
   Reveal Solution Discussion Select an answer first