Databricks Data Engineer Associate Lakeflow Jobs Control Flow Tasks Dependencies Schedules Practice Test

 

Skill 4 • 60 original questions

This Databricks Certified Data Engineer Associate practice test focuses on lakeflow jobs control flow tasks dependencies schedules and triggers through original data-engineering scenarios aligned to the exam guide effective May 4, 2026. Databricks does not publish section percentages in this guide, so the complete ExamSnap collection distributes questions according to objective breadth while covering every published objective explicitly. For broader exam preparation, review the Databricks Certified Data Engineer Associate Exam Dumps page.

Instructions: Select the best answer for each question unless the stem says Select TWO. Review the explanation after answering; every option includes a reason it is or is not the best fit for that scenario.

Question 1

The analytics engineering team at Wingtip Toys is comparing implementation options. They must identify the feature or practice that best addresses this need: implement retries conditional branches and loops with lakeflow jobs. Which option best matches the requirement and the goal to apply the narrowest effective control? The team wants the decision to match the exact control boundary rather than the most feature-rich option.

1. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
2. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
3. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
4. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
5. Parameterize environment-specific values with Declarative Automation Bundle variables, targets, and overrides so the same source can be promoted across dev, test, and production

Correct answer: A

Why: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement. | B: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Use Automation Bundle variables and overrides for environment-specific configuration. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic

Question 2

A change request at Proseware has one non-negotiable requirement: make a decision that correctly reflects this requirement: configure notebook sql dashboard and pipeline tasks with dag dependencies. What should the data engineering team choose if the priority is to improve auditability? The team wants the decision to match the exact control boundary rather than the most feature-rich option.

1. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
2. Use COPY INTO for idempotent incremental file ingestion from supported cloud object storage into governed Delta tables when its file-tracking model fits the source
3. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
4. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
5. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Correct answer: C

Why: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Use COPY INTO for incremental cloud-object-storage loading into Unity Catalog tables. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement. | D: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Question 3

Northwind Traders is reviewing a production configuration. The governance team must choose the most accurate administrative approach for this requirement: implement schedules and understand scheduled file-arrival and table-update triggers. Which choice most directly satisfies the requirement while trying to avoid unnecessary complexity? The team will validate the decision with operational evidence after rollout.

1. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
2. Choose Auto Loader, Lakeflow Connect, partner connectors, or other methods by volume, frequency, source type, operational burden, and Unity Catalog governance requirements
3. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
4. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
5. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Correct answer: E

Why: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Prioritize ingestion methods from technical and governance requirements. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement.

Learning point: Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Question 4

The DevOps team at Tailspin Toys is comparing implementation options. They must choose the most accurate administrative approach for this requirement: choose time-based or data-driven triggers. Which option best matches the requirement and the goal to reduce user disruption? The team will validate the decision with operational evidence after rollout.

1. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
2. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
3. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
4. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
5. Use ABAC policies and governed tags or attributes when row-filtering and column-masking policy should be centrally defined and consistently enforced across matching data

Correct answer: B

Why: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement. | C: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Use Unity Catalog ABAC policies for centralized row filtering and column masking. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates

Question 5

During an implementation review at Fourth Coffee, the BI team needs to make a decision that correctly reflects this requirement: implement retries conditional branches and loops with lakeflow jobs. Which approach is the strongest fit when the organization also wants to preserve least privilege? The team wants the decision to match the exact control boundary rather than the most feature-rich option.

1. Choose the join or union semantics that preserve the intended row set and schema, using broadcast joins only when the smaller-side characteristics make them appropriate
2. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
3. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
4. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
5. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Correct answer: C

Why: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Combine DataFrames with joins unions and multiple-key operations. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement. | D: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic

Question 6

For an upcoming rollout at Northwind Traders, the data engineering team needs to make a decision that correctly reflects this requirement: configure notebook sql dashboard and pipeline tasks with dag dependencies. Which response is most appropriate if the solution should also apply the narrowest effective control? The implementation should avoid adding a control that does not address the stated constraint.

1. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
2. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
3. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
4. Choose among materialized views, views, streaming tables, and tables according to freshness, recomputation, query, and BI consumption requirements in Unity Catalog
5. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Correct answer: E

Why: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Build appropriate Gold layer objects for BI and analytics. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement.

Learning point: Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Question 7

A change request at Northwind Traders has one non-negotiable requirement: identify the feature or practice that best addresses this need: implement schedules and understand scheduled file-arrival and table-update triggers. What should the analytics engineering team choose if the priority is to support repeatable administration? The implementation should avoid adding a control that does not address the stated constraint.

1. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
2. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
3. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
4. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
5. Package and deploy Lakeflow Jobs, Lakeflow Spark Declarative Pipelines, and supported workspace assets in a version-controlled bundle for repeatable promotion

Correct answer: C

Why: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement. | D: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Deploy Declarative Automation Bundles for jobs pipelines and workspace assets. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Question 8

The data engineering team at Tailspin Toys is comparing implementation options. They must implement the skill described by choose time-based or data-driven triggers. Which option best matches the requirement and the goal to reduce user disruption? The choice must be defensible in a security and governance review.

1. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
2. Apply deterministic deduplication and the correct aggregate functions such as count, approximate distinct count, mean, or summary for the analytical requirement
3. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
4. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
5. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Correct answer: D

Why: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Deduplicate and aggregate DataFrames. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement. | E: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates

Question 9

During an implementation review at Fabrikam, the data engineering team needs to identify the feature or practice that best addresses this need: implement retries conditional branches and loops with lakeflow jobs. Which approach is the strongest fit when the organization also wants to reduce user disruption? The implementation should avoid adding a control that does not address the stated constraint.

1. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
2. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
3. Parameterize environment-specific values with Declarative Automation Bundle variables, targets, and overrides so the same source can be promoted across dev, test, and production
4. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
5. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Correct answer: A

Why: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement. | B: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Use Automation Bundle variables and overrides for environment-specific configuration. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic

Question 10

The DevOps team at Trey Research is comparing implementation options. They must implement the skill described by configure notebook sql dashboard and pipeline tasks with dag dependencies. Which option best matches the requirement and the goal to meet the stated compliance requirement? The team will validate the decision with operational evidence after rollout.

1. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
2. Tune shuffle partitions, default parallelism, driver/executor memory, or auto-broadcast threshold only from observed workload behavior and validate changes by re-measuring performance
3. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
4. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
5. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic

Correct answer: D

Why: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Use basic Spark tuning parameters and re-measure performance. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement. | E: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Question 11

A change request at Fabrikam has one non-negotiable requirement: make a decision that correctly reflects this requirement: implement schedules and understand scheduled file-arrival and table-update triggers. What should the platform team choose if the priority is to keep the design manageable at scale? The administrator must distinguish the requested feature from adjacent controls that solve a different problem.

1. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
2. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
3. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
4. Define and enforce validation rules at appropriate pipeline stages so invalid data is detected, handled, and measurable before Silver or Gold data is trusted
5. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates

Correct answer: B

Why: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement. | C: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Apply data quality checks and validation rules. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Question 12

An administration ticket for Woodgrove Bank states: choose the most accurate administrative approach for this requirement: choose time-based or data-driven triggers. Which decision should the data engineering team make to preserve least privilege? The team wants the decision to match the exact control boundary rather than the most feature-rich option.

1. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
2. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
3. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
4. Apply deterministic deduplication and the correct aggregate functions such as count, approximate distinct count, mean, or summary for the analytical requirement
5. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic

Correct answer: A

Why: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement. | B: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Deduplicate and aggregate DataFrames. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates

Question 13

During an implementation review at Proseware, the analytics engineering team needs to choose the most accurate administrative approach for this requirement: implement retries conditional branches and loops with lakeflow jobs. Which approach is the strongest fit when the organization also wants to reduce user disruption? The administrator must distinguish the requested feature from adjacent controls that solve a different problem.

1. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
2. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
3. Grant the least privileges needed to users, groups, and service principals at catalog, schema, table, or other supported scopes, using REVOKE or DENY where governance requires it
4. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
5. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates

Correct answer: D

Why: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Configure privileges with GRANT REVOKE and DENY at appropriate hierarchy levels. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement. | E: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic

Question 14

A change request at Trey Research has one non-negotiable requirement: make a decision that correctly reflects this requirement: configure notebook sql dashboard and pipeline tasks with dag dependencies. What should the platform team choose if the priority is to meet the stated compliance requirement? The team wants the decision to match the exact control boundary rather than the most feature-rich option.

1. Choose serverless or other supported Databricks compute based on workload type, compatibility, operational control, startup needs, performance characteristics, and cost model
2. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
3. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
4. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
5. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Correct answer: E

Why: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Understand compute services characteristics limitations cost models and workload selection. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement.

Learning point: Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Question 15

The governance team at Fabrikam is comparing implementation options. They must select an implementation consistent with this objective: implement schedules and understand scheduled file-arrival and table-update triggers. Which option best matches the requirement and the goal to avoid unnecessary complexity? The choice must be defensible in a security and governance review.

1. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
2. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
3. Use ABAC policies and governed tags or attributes when row-filtering and column-masking policy should be centrally defined and consistently enforced across matching data
4. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
5. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Correct answer: A

Why: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement. | B: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Use Unity Catalog ABAC policies for centralized row filtering and column masking. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Question 16

An administration ticket for Litware states: select an implementation consistent with this objective: choose time-based or data-driven triggers. Which decision should the DevOps team make to reduce user disruption? The choice must be defensible in a security and governance review.

1. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
2. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
3. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
4. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
5. Read bronze data, handle nulls and malformed values, standardize types and fields, and write validated silver Delta tables

Correct answer: D

Why: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement. | E: This is the control, feature, or practice that directly implements the stated skill: Clean bronze data and write standardized silver tables with PySpark or SQL. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates

Question 17

A change request at Proseware has one non-negotiable requirement: implement the skill described by implement retries conditional branches and loops with lakeflow jobs. What should the governance team choose if the priority is to apply the narrowest effective control? The choice must be defensible in a security and governance review.

1. Use cluster event logs, dependency resolution information, driver/executor logs, and memory behavior to isolate startup, library, or OOM root causes before changing configuration
2. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
3. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
4. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
5. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Correct answer: C

Why: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Diagnose cluster startup failures library conflicts and out-of-memory issues. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement. | D: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic

Question 18

The governance team at Woodgrove Bank is comparing implementation options. They must choose the most accurate administrative approach for this requirement: configure notebook sql dashboard and pipeline tasks with dag dependencies. Which option best matches the requirement and the goal to avoid unnecessary complexity? The administrator must distinguish the requested feature from adjacent controls that solve a different problem.

1. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
2. Use COPY INTO for idempotent incremental file ingestion from supported cloud object storage into governed Delta tables when its file-tracking model fits the source
3. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
4. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
5. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic

Correct answer: A

Why: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement. | B: This is the control, feature, or practice that directly implements the stated skill: Use COPY INTO for incremental cloud-object-storage loading into Unity Catalog tables. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Question 19

During an implementation review at Litware, the BI team needs to implement the skill described by implement schedules and understand scheduled file-arrival and table-update triggers. Which approach is the strongest fit when the organization also wants to reduce user disruption? The implementation should avoid adding a control that does not address the stated constraint.

1. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
2. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
3. Use the appropriate Lakeflow Connect connector and governed destination to ingest supported enterprise source data reliably into Unity Catalog tables
4. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
5. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Correct answer: D

Why: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Configure Lakeflow Connect for enterprise sources. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement. | E: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Question 20

The DevOps team at Tailspin Toys is comparing implementation options. They must make a decision that correctly reflects this requirement: choose time-based or data-driven triggers. Which option best matches the requirement and the goal to improve auditability? The administrator must distinguish the requested feature from adjacent controls that solve a different problem.

1. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
2. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
3. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
4. Read bronze data, handle nulls and malformed values, standardize types and fields, and write validated silver Delta tables
5. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic

Correct answer: C

Why: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement. | D: This is the control, feature, or practice that directly implements the stated skill: Clean bronze data and write standardized silver tables with PySpark or SQL. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates

Question 21

Wingtip Toys is reviewing a production configuration. The data engineering team must select an implementation consistent with this objective: implement retries conditional branches and loops with lakeflow jobs. Which choice most directly satisfies the requirement while trying to reduce user disruption? The administrator must distinguish the requested feature from adjacent controls that solve a different problem.

1. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
2. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
3. Choose the join or union semantics that preserve the intended row set and schema, using broadcast joins only when the smaller-side characteristics make them appropriate
4. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
5. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Correct answer: B

Why: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement. | C: This is the control, feature, or practice that directly implements the stated skill: Combine DataFrames with joins unions and multiple-key operations. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic

Question 22

An administration ticket for Alpine Ski House states: identify the feature or practice that best addresses this need: configure notebook sql dashboard and pipeline tasks with dag dependencies. Which decision should the platform team make to reduce user disruption? The implementation should avoid adding a control that does not address the stated constraint.

1. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
2. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
3. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
4. Use COPY INTO for idempotent incremental file ingestion from supported cloud object storage into governed Delta tables when its file-tracking model fits the source
5. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates

Correct answer: B

Why: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement. | C: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Use COPY INTO for incremental cloud-object-storage loading into Unity Catalog tables. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Question 23

For an upcoming rollout at Northwind Traders, the data engineering team needs to choose the most accurate administrative approach for this requirement: implement schedules and understand scheduled file-arrival and table-update triggers. Which response is most appropriate if the solution should also preserve least privilege? The implementation should avoid adding a control that does not address the stated constraint.

1. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
2. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
3. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
4. Parse and normalize JSON, nested, semi-structured, or unstructured source data with a supported managed or code-based ingestion path before landing it in Unity Catalog governed Delta tables
5. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Correct answer: C

Why: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement. | D: This is the control, feature, or practice that directly implements the stated skill: Ingest semi-structured and unstructured data into governed Delta tables. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Question 24

Contoso is reviewing a production configuration. The DevOps team must select an implementation consistent with this objective: choose time-based or data-driven triggers. Which choice most directly satisfies the requirement while trying to preserve least privilege? The administrator must distinguish the requested feature from adjacent controls that solve a different problem.

1. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
2. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
3. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
4. Apply deterministic deduplication and the correct aggregate functions such as count, approximate distinct count, mean, or summary for the analytical requirement
5. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic

Correct answer: C

Why: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement. | D: This is the control, feature, or practice that directly implements the stated skill: Deduplicate and aggregate DataFrames. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates

Question 25

Northwind Traders is reviewing a production configuration. The data engineering team must select an implementation consistent with this objective: implement retries conditional branches and loops with lakeflow jobs. Which choice most directly satisfies the requirement while trying to minimize operational overhead? The choice must be defensible in a security and governance review.

1. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
2. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
3. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
4. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
5. Compare current and historical run durations, retries, task timings, and failures to identify regressions and recurring performance patterns

Correct answer: C

Why: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement. | D: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Identify job performance trends using Lakeflow Jobs run history. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic

Question 26

During an implementation review at Alpine Ski House, the platform team needs to choose the most accurate administrative approach for this requirement: configure notebook sql dashboard and pipeline tasks with dag dependencies. Which approach is the strongest fit when the organization also wants to keep the design manageable at scale? The team will validate the decision with operational evidence after rollout.

1. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
2. Tune shuffle partitions, default parallelism, driver/executor memory, or auto-broadcast threshold only from observed workload behavior and validate changes by re-measuring performance
3. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
4. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
5. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Correct answer: C

Why: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Use basic Spark tuning parameters and re-measure performance. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement. | D: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Question 27

For an upcoming rollout at Tailspin Toys, the platform team needs to choose the most accurate administrative approach for this requirement: implement schedules and understand scheduled file-arrival and table-update triggers. Which response is most appropriate if the solution should also apply the narrowest effective control? The administrator must distinguish the requested feature from adjacent controls that solve a different problem.

1. Package and deploy Lakeflow Jobs, Lakeflow Spark Declarative Pipelines, and supported workspace assets in a version-controlled bundle for repeatable promotion
2. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
3. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
4. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
5. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Correct answer: E

Why: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Deploy Declarative Automation Bundles for jobs pipelines and workspace assets. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement.

Learning point: Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Question 28

During an implementation review at Woodgrove Bank, the platform team needs to choose the most accurate administrative approach for this requirement: choose time-based or data-driven triggers. Which approach is the strongest fit when the organization also wants to improve auditability? The choice must be defensible in a security and governance review.

1. Use supported Databricks CLI bundle commands to validate, deploy, run, and manage bundles as part of automated CI/CD workflows
2. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
3. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
4. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
5. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic

Correct answer: B

Why: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Use Databricks CLI for validation deployment and bundle management. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement. | C: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates

Question 29

The data engineering team at Contoso is comparing implementation options. They must choose the most accurate administrative approach for this requirement: implement retries conditional branches and loops with lakeflow jobs. Which option best matches the requirement and the goal to minimize operational overhead? The implementation should avoid adding a control that does not address the stated constraint.

1. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
2. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
3. Define and enforce validation rules at appropriate pipeline stages so invalid data is detected, handled, and measurable before Silver or Gold data is trusted
4. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
5. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates

Correct answer: B

Why: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement. | C: This is the control, feature, or practice that directly implements the stated skill: Apply data quality checks and validation rules. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic

Question 30

Contoso is reviewing a production configuration. The platform team must implement the skill described by configure notebook sql dashboard and pipeline tasks with dag dependencies. Which choice most directly satisfies the requirement while trying to preserve least privilege? The choice must be defensible in a security and governance review.

1. Apply deterministic deduplication and the correct aggregate functions such as count, approximate distinct count, mean, or summary for the analytical requirement
2. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
3. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
4. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
5. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates

Correct answer: C

Why: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Deduplicate and aggregate DataFrames. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement. | D: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Question 31

The platform team at Woodgrove Bank is comparing implementation options. They must implement the skill described by implement schedules and understand scheduled file-arrival and table-update triggers. Which option best matches the requirement and the goal to minimize operational overhead? The team wants the decision to match the exact control boundary rather than the most feature-rich option.

1. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
2. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
3. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
4. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
5. Use Databricks Git folders or repository integration for branch-based development, commits, pushes, and pull-request workflows while keeping source control as the collaboration system of record

Correct answer: D

Why: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement. | E: This is the control, feature, or practice that directly implements the stated skill: Manage branches commits pushes and pull requests with Databricks Git integration. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Question 32

The DevOps team at Litware is comparing implementation options. They must select an implementation consistent with this objective: choose time-based or data-driven triggers. Which option best matches the requirement and the goal to avoid unnecessary complexity? The implementation should avoid adding a control that does not address the stated constraint.

1. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
2. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
3. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
4. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
5. Use Databricks Git folders or repository integration for branch-based development, commits, pushes, and pull-request workflows while keeping source control as the collaboration system of record

Correct answer: C

Why: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement. | D: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Manage branches commits pushes and pull requests with Databricks Git integration. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates

Question 33

Proseware is reviewing a production configuration. The BI team must select an implementation consistent with this objective: implement retries conditional branches and loops with lakeflow jobs. Which choice most directly satisfies the requirement while trying to apply the narrowest effective control? The implementation should avoid adding a control that does not address the stated constraint.

1. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
2. Use managed tables when Databricks should manage data lifecycle and external tables when data lifecycle/location must remain externally managed, applying supported create modify delete and conversion operations
3. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
4. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
5. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Correct answer: D

Why: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Differentiate and operate managed and external Unity Catalog tables. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement. | E: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic

Question 34

A change request at Northwind Traders has one non-negotiable requirement: select an implementation consistent with this objective: configure notebook sql dashboard and pipeline tasks with dag dependencies. What should the analytics engineering team choose if the priority is to meet the stated compliance requirement? The implementation should avoid adding a control that does not address the stated constraint.

1. Define and enforce validation rules at appropriate pipeline stages so invalid data is detected, handled, and measurable before Silver or Gold data is trusted
2. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
3. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
4. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
5. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Correct answer: C

Why: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Apply data quality checks and validation rules. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement. | D: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Question 35

An administration ticket for Contoso states: make a decision that correctly reflects this requirement: implement schedules and understand scheduled file-arrival and table-update triggers. Which decision should the DevOps team make to avoid unnecessary complexity? The team wants the decision to match the exact control boundary rather than the most feature-rich option.

1. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
2. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
3. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
4. Use Databricks Git folders or repository integration for branch-based development, commits, pushes, and pull-request workflows while keeping source control as the collaboration system of record
5. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates

Correct answer: B

Why: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement. | C: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Manage branches commits pushes and pull requests with Databricks Git integration. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Question 36

A change request at Contoso has one non-negotiable requirement: implement the skill described by choose time-based or data-driven triggers. What should the analytics engineering team choose if the priority is to reduce security risk? The administrator must distinguish the requested feature from adjacent controls that solve a different problem.

1. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
2. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
3. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
4. Use COPY INTO for idempotent incremental file ingestion from supported cloud object storage into governed Delta tables when its file-tracking model fits the source
5. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Correct answer: C

Why: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement. | D: This is the control, feature, or practice that directly implements the stated skill: Use COPY INTO for incremental cloud-object-storage loading into Unity Catalog tables. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates

Question 37

Contoso is reviewing a production configuration. The data engineering team must make a decision that correctly reflects this requirement: implement retries conditional branches and loops with lakeflow jobs. Which choice most directly satisfies the requirement while trying to apply the narrowest effective control? The administrator must distinguish the requested feature from adjacent controls that solve a different problem.

1. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
2. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
3. Use JDBC, ODBC, or REST when a supported API/client is the practical ingestion path, then orchestrate and schedule the notebook or task with Lakeflow Jobs
4. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
5. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Correct answer: D

Why: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Use JDBC ODBC or REST clients in notebooks and orchestrate with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement. | E: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic

Question 38

A change request at Contoso has one non-negotiable requirement: identify the feature or practice that best addresses this need: configure notebook sql dashboard and pipeline tasks with dag dependencies. What should the data engineering team choose if the priority is to support repeatable administration? The choice must be defensible in a security and governance review.

1. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
2. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
3. Use JDBC, ODBC, or REST when a supported API/client is the practical ingestion path, then orchestrate and schedule the notebook or task with Lakeflow Jobs
4. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
5. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates

Correct answer: A

Why: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement. | B: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Use JDBC ODBC or REST clients in notebooks and orchestrate with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Question 39

For an upcoming rollout at Trey Research, the platform team needs to identify the feature or practice that best addresses this need: implement schedules and understand scheduled file-arrival and table-update triggers. Which response is most appropriate if the solution should also keep the design manageable at scale? The choice must be defensible in a security and governance review.

1. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
2. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
3. Tune shuffle partitions, default parallelism, driver/executor memory, or auto-broadcast threshold only from observed workload behavior and validate changes by re-measuring performance
4. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
5. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates

Correct answer: A

Why: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement. | B: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Use basic Spark tuning parameters and re-measure performance. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Question 40

The DevOps team at Alpine Ski House is comparing implementation options. They must implement the skill described by choose time-based or data-driven triggers. Which option best matches the requirement and the goal to reduce security risk? The team wants the decision to match the exact control boundary rather than the most feature-rich option.

1. Use cluster event logs, dependency resolution information, driver/executor logs, and memory behavior to isolate startup, library, or OOM root causes before changing configuration
2. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
3. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
4. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
5. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic

Correct answer: D

Why: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Diagnose cluster startup failures library conflicts and out-of-memory issues. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement. | E: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates

Question 41

Fabrikam is reviewing a production configuration. The data engineering team must implement the skill described by implement retries conditional branches and loops with lakeflow jobs. Which choice most directly satisfies the requirement while trying to meet the stated compliance requirement? The choice must be defensible in a security and governance review.

1. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
2. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
3. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
4. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
5. Parse and normalize JSON, nested, semi-structured, or unstructured source data with a supported managed or code-based ingestion path before landing it in Unity Catalog governed Delta tables

Correct answer: D

Why: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement. | E: This is the control, feature, or practice that directly implements the stated skill: Ingest semi-structured and unstructured data into governed Delta tables. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic

Question 42

During an implementation review at Woodgrove Bank, the data engineering team needs to choose the most accurate administrative approach for this requirement: configure notebook sql dashboard and pipeline tasks with dag dependencies. Which approach is the strongest fit when the organization also wants to support repeatable administration? The administrator must distinguish the requested feature from adjacent controls that solve a different problem.

1. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
2. Grant the least privileges needed to users, groups, and service principals at catalog, schema, table, or other supported scopes, using REVOKE or DENY where governance requires it
3. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
4. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
5. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates

Correct answer: C

Why: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Configure privileges with GRANT REVOKE and DENY at appropriate hierarchy levels. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement. | D: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Question 43

Wingtip Toys is reviewing a production configuration. The data engineering team must identify the feature or practice that best addresses this need: implement schedules and understand scheduled file-arrival and table-update triggers. Which choice most directly satisfies the requirement while trying to reduce user disruption? The implementation should avoid adding a control that does not address the stated constraint.

1. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
2. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
3. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
4. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
5. Grant the least privileges needed to users, groups, and service principals at catalog, schema, table, or other supported scopes, using REVOKE or DENY where governance requires it

Correct answer: C

Why: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement. | D: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Configure privileges with GRANT REVOKE and DENY at appropriate hierarchy levels. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Question 44

An administration ticket for Fabrikam states: select an implementation consistent with this objective: choose time-based or data-driven triggers. Which decision should the governance team make to keep the design manageable at scale? The implementation should avoid adding a control that does not address the stated constraint.

1. Parameterize environment-specific values with Declarative Automation Bundle variables, targets, and overrides so the same source can be promoted across dev, test, and production
2. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
3. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
4. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
5. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic

Correct answer: C

Why: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Use Automation Bundle variables and overrides for environment-specific configuration. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement. | D: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates

Question 45

For an upcoming rollout at Northwind Traders, the governance team needs to choose the most accurate administrative approach for this requirement: implement retries conditional branches and loops with lakeflow jobs. Which response is most appropriate if the solution should also minimize operational overhead? The administrator must distinguish the requested feature from adjacent controls that solve a different problem.

1. Parse and normalize JSON, nested, semi-structured, or unstructured source data with a supported managed or code-based ingestion path before landing it in Unity Catalog governed Delta tables
2. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
3. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
4. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
5. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic

Correct answer: E

Why: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Ingest semi-structured and unstructured data into governed Delta tables. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement.

Learning point: Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic

Question 46

Wingtip Toys is reviewing a production configuration. The analytics engineering team must choose the most accurate administrative approach for this requirement: configure notebook sql dashboard and pipeline tasks with dag dependencies. Which choice most directly satisfies the requirement while trying to apply the narrowest effective control? The administrator must distinguish the requested feature from adjacent controls that solve a different problem.

1. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
2. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
3. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
4. Select batch, streaming, or incremental ingestion according to source behavior, latency, scale, and reliability requirements
5. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Correct answer: B

Why: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement. | C: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Use batch streaming and incremental ingestion patterns from supported local and Lakeflow Connect sources. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Question 47

An administration ticket for Adventure Works states: make a decision that correctly reflects this requirement: implement schedules and understand scheduled file-arrival and table-update triggers. Which decision should the BI team make to preserve least privilege? The implementation should avoid adding a control that does not address the stated constraint.

1. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
2. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
3. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
4. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
5. Use supported Databricks CLI bundle commands to validate, deploy, run, and manage bundles as part of automated CI/CD workflows

Correct answer: D

Why: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement. | E: This is the control, feature, or practice that directly implements the stated skill: Use Databricks CLI for validation deployment and bundle management. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Question 48

For an upcoming rollout at Proseware, the data engineering team needs to choose the most accurate administrative approach for this requirement: choose time-based or data-driven triggers. Which response is most appropriate if the solution should also preserve least privilege? The choice must be defensible in a security and governance review.

1. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
2. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
3. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
4. Read bronze data, handle nulls and malformed values, standardize types and fields, and write validated silver Delta tables
5. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic

Correct answer: B

Why: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement. | C: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Clean bronze data and write standardized silver tables with PySpark or SQL. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates

Question 49

Fabrikam is reviewing a production configuration. The governance team must select an implementation consistent with this objective: implement retries conditional branches and loops with lakeflow jobs. Which choice most directly satisfies the requirement while trying to keep the design manageable at scale? The implementation should avoid adding a control that does not address the stated constraint.

1. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
2. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
3. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
4. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
5. Compare current and historical run durations, retries, task timings, and failures to identify regressions and recurring performance patterns

Correct answer: C

Why: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement. | D: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Identify job performance trends using Lakeflow Jobs run history. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic

Question 50

The BI team at Alpine Ski House is comparing implementation options. They must implement the skill described by configure notebook sql dashboard and pipeline tasks with dag dependencies. Which option best matches the requirement and the goal to improve auditability? The choice must be defensible in a security and governance review.

1. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
2. Compare current and historical run durations, retries, task timings, and failures to identify regressions and recurring performance patterns
3. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
4. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
5. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Correct answer: E

Why: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Identify job performance trends using Lakeflow Jobs run history. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement.

Learning point: Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Question 51

For an upcoming rollout at Proseware, the platform team needs to identify the feature or practice that best addresses this need: implement schedules and understand scheduled file-arrival and table-update triggers. Which response is most appropriate if the solution should also reduce user disruption? The administrator must distinguish the requested feature from adjacent controls that solve a different problem.

1. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
2. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
3. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
4. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
5. Use cluster event logs, dependency resolution information, driver/executor logs, and memory behavior to isolate startup, library, or OOM root causes before changing configuration

Correct answer: D

Why: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement. | E: This is the control, feature, or practice that directly implements the stated skill: Diagnose cluster startup failures library conflicts and out-of-memory issues. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Question 52

The analytics engineering team at Wingtip Toys is comparing implementation options. They must choose the most accurate administrative approach for this requirement: choose time-based or data-driven triggers. Which option best matches the requirement and the goal to preserve least privilege? The administrator must distinguish the requested feature from adjacent controls that solve a different problem.

1. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
2. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
3. Parameterize environment-specific values with Declarative Automation Bundle variables, targets, and overrides so the same source can be promoted across dev, test, and production
4. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
5. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Correct answer: A

Why: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement. | B: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Use Automation Bundle variables and overrides for environment-specific configuration. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates

Question 53

The data engineering team at Proseware is comparing implementation options. They must choose the most accurate administrative approach for this requirement: implement retries conditional branches and loops with lakeflow jobs. Which option best matches the requirement and the goal to meet the stated compliance requirement? The administrator must distinguish the requested feature from adjacent controls that solve a different problem.

1. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
2. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
3. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
4. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
5. Use the Jobs UI and DAG to locate failed or blocked tasks, understand upstream dependencies, and assess pipeline runtime and failure-rate health

Correct answer: A

Why: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement. | B: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Monitor pipeline health using Lakeflow Jobs status DAG runtime and failure information. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic

Question 54

An administration ticket for Woodgrove Bank states: identify the feature or practice that best addresses this need: configure notebook sql dashboard and pipeline tasks with dag dependencies. Which decision should the BI team make to minimize operational overhead? The team will validate the decision with operational evidence after rollout.

1. Use the platform architecture, Delta Lake transaction/storage capabilities, and Unity Catalog governance model together to select the right platform component for the workload
2. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
3. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
4. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
5. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Correct answer: E

Why: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Understand core Databricks Data Intelligence Platform components including architecture Delta Lake and Unity Catalog. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement.

Learning point: Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Question 55

Litware is reviewing a production configuration. The governance team must choose the most accurate administrative approach for this requirement: implement schedules and understand scheduled file-arrival and table-update triggers. Which choice most directly satisfies the requirement while trying to preserve least privilege? The team will validate the decision with operational evidence after rollout.

1. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
2. Use cluster event logs, dependency resolution information, driver/executor logs, and memory behavior to isolate startup, library, or OOM root causes before changing configuration
3. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
4. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
5. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Correct answer: E

Why: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Diagnose cluster startup failures library conflicts and out-of-memory issues. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement.

Learning point: Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Question 56

Fourth Coffee is reviewing a production configuration. The BI team must choose the most accurate administrative approach for this requirement: choose time-based or data-driven triggers. Which choice most directly satisfies the requirement while trying to avoid unnecessary complexity? The administrator must distinguish the requested feature from adjacent controls that solve a different problem.

1. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
2. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
3. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
4. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
5. Define and enforce validation rules at appropriate pipeline stages so invalid data is detected, handled, and measurable before Silver or Gold data is trusted

Correct answer: D

Why: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement. | E: This is the control, feature, or practice that directly implements the stated skill: Apply data quality checks and validation rules. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates

Question 57

During an implementation review at Fabrikam, the data engineering team needs to identify the feature or practice that best addresses this need: implement retries conditional branches and loops with lakeflow jobs. Which approach is the strongest fit when the organization also wants to avoid unnecessary complexity? The team wants the decision to match the exact control boundary rather than the most feature-rich option.

1. Use cluster event logs, dependency resolution information, driver/executor logs, and memory behavior to isolate startup, library, or OOM root causes before changing configuration
2. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
3. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
4. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
5. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Correct answer: D

Why: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Diagnose cluster startup failures library conflicts and out-of-memory issues. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. This directly matches the scenario requirement. | E: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic

Question 58

For an upcoming rollout at Tailspin Toys, the analytics engineering team needs to implement the skill described by configure notebook sql dashboard and pipeline tasks with dag dependencies. Which response is most appropriate if the solution should also apply the narrowest effective control? The team wants the decision to match the exact control boundary rather than the most feature-rich option.

1. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
2. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
3. Parameterize environment-specific values with Declarative Automation Bundle variables, targets, and overrides so the same source can be promoted across dev, test, and production
4. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
5. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic

Correct answer: D

Why: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Use Automation Bundle variables and overrides for environment-specific configuration. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. This directly matches the scenario requirement. | E: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Question 59

A change request at Contoso has one non-negotiable requirement: make a decision that correctly reflects this requirement: implement schedules and understand scheduled file-arrival and table-update triggers. What should the BI team choose if the priority is to apply the narrowest effective control? The choice must be defensible in a security and governance review.

1. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly
2. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
3. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
4. Define and enforce validation rules at appropriate pipeline stages so invalid data is detected, handled, and measurable before Silver or Gold data is trusted
5. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Correct answer: E

Why: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | D: This is the control, feature, or practice that directly implements the stated skill: Apply data quality checks and validation rules. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. This directly matches the scenario requirement.

Learning point: Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow

Question 60

Contoso is reviewing a production configuration. The governance team must make a decision that correctly reflects this requirement: choose time-based or data-driven triggers. Which choice most directly satisfies the requirement while trying to minimize operational overhead? The choice must be defensible in a security and governance review.

1. Choose and configure a scheduled, file-arrival, or table-update trigger based on the event that should start the workflow
2. Package and deploy Lakeflow Jobs, Lakeflow Spark Declarative Pipelines, and supported workspace assets in a version-controlled bundle for repeatable promotion
3. Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates
4. Use job control-flow capabilities such as retries, conditional tasks, and loops to express recoverable and data-dependent orchestration logic
5. Create the required task types and dependency graph so Lakeflow Jobs runs tasks in the intended order and exposes upstream/downstream status clearly

Correct answer: C

Why: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement.

Option review: A: This is the control, feature, or practice that directly implements the stated skill: Implement schedules and understand scheduled file-arrival and table-update triggers. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | B: This is the control, feature, or practice that directly implements the stated skill: Deploy Declarative Automation Bundles for jobs pipelines and workspace assets. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | C: This is the control, feature, or practice that directly implements the stated skill: Choose time-based or data-driven triggers. This directly matches the scenario requirement. | D: This is the control, feature, or practice that directly implements the stated skill: Implement retries conditional branches and loops with Lakeflow Jobs. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here. | E: This is the control, feature, or practice that directly implements the stated skill: Configure notebook SQL dashboard and pipeline tasks with DAG dependencies. It can be appropriate for a different objective, but it does not most directly address the requirement being tested here.

Learning point: Use time-based triggers for clock-driven SLAs and data-driven triggers when execution should follow actual data arrival or table updates