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

Questions 11–15

1. 11foundation · medium

   When editing a task in a DAG, which of the following can you modify?

   • AOnly the task's compute and schedule
   • BOnly the task's type and its position in the graph
   • CThe task's dependencies and its configuration
   • DOnly the task's name and description
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A data platform team has a Lakeflow Job with three tasks: `ingest_data` (a notebook), `clean_data` (a notebook), and `generate_report` (a SQL query). The `clean_data` task must run only after `ingest_data` succeeds, and `generate_report` must run only after `clean_data` succeeds. How should the team define the dependencies in the DAG-based task graph?

   • ASet `clean_data` and `generate_report` to both depend on `ingest_data`.
   • BSet `clean_data` to depend on `ingest_data`, and set `generate_report` to depend on `clean_data`.
   • CSet `ingest_data` to depend on `clean_data`, and set `clean_data` to depend on `generate_report`.
   • DLeave all tasks without dependencies and rely on the job's default parallel execution.
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A data analyst team has a Lakeflow Job that runs a SQL query task `monthly_report`. The query uses a parameter `report_month` that should be set to the current month when the job runs. The team wants to pass this parameter dynamically without editing the query each time. What is the best way to configure this?

   • AUse a job-level parameter `report_month` and reference it in the SQL query using `{{params.report_month}}`.
   • BUse a notebook task to run the SQL query and pass the month as a notebook parameter.
   • CCreate a separate SQL query task for each month and select the appropriate one in the job.
   • DHardcode the month in the SQL query and update it manually each month.
   Reveal Solution Discussion Select an answer first
5. 14foundation · medium

   In a pipeline task, what is the purpose of the target schema?

   • ATo specify the compute resources for the pipeline
   • BTo specify the refresh schedule for the pipeline
   • CTo specify the input data location for the pipeline
   • DTo specify the database where the pipeline's tables will be created
   Reveal Solution Discussion Select an answer first
6. 15foundation · medium

   What happens if a task in a DAG fails and a downstream task has the default dependency behavior?

   • AThe downstream task runs but is marked as failed
   • BThe entire job stops immediately
   • CThe downstream task does not run
   • DThe downstream task runs regardless of the failure
   Reveal Solution Discussion Select an answer first