Databricks Certified-Data-Engineer-Professional Value Pack (Frequently Bought Together)

A junior data engineer seeks to leverage Delta Lake's Change Data Feed functionality to create a Type 1 table representing all of the values that have ever been valid for all rows in a bronze table created with the property delta.enableChangeDataFeed = true. They plan to execute the following code as a daily job:

Which statement describes the execution and results of running the above query multiple times?

• A. Each time the job is executed, newly updated records will be merged into the target table, overwriting previous values with the same primary keys.
• B. Each time the job is executed, only those records that have been inserted or updated since the last execution will be appended to the target table giving the desired result.
• C. Each time the job is executed, the target table will be overwritten using the entire history of inserted or updated records, giving the desired result.
• D. Each time the job is executed, the differences between the original and current versions are calculated; this may result in duplicate entries for some records.
• E. Each time the job is executed, the entire available history of inserted or updated records will be appended to the target table, resulting in many duplicate entries.

A Delta Lake table in the Lakehouse named customer_parsams is used in churn prediction by the machine learning team. The table contains information about customers derived from a number of upstream sources. Currently, the data engineering team populates this table nightly by overwriting the table with the current valid values derived from upstream data sources.
Immediately after each update succeeds, the data engineer team would like to determine the difference between the new version and the previous of the table. Given the current implementation, which method can be used?

• A. Parse the Delta Lake transaction log to identify all newly written data files.
• B. Execute a query to calculate the difference between the new version and the previous version using Delta Lake's built-in versioning and time travel functionality.
• C. Parse the Spark event logs to identify those rows that were updated, inserted, or deleted.
• D. Execute DESCRIBE HISTORY customer_churn_params to obtain the full operation metrics for the update, including a log of all records that have been added or modified.

The DevOps team has configured a production workload as a collection of notebooks scheduled to run daily using the Jobs UI. A new data engineering hire is onboarding to the team and has requested access to one of these notebooks to review the production logic.
What are the maximum notebook permissions that can be granted to the user without allowing accidental changes to production code or data?

• A. No permissions
• B. Can Edit
• C. Can Manage
• D. Can Read
• E. Can Run

A data engineer wants to automate job monitoring and recovery in Databricks using the Jobs API.
They need to list all jobs, identify a failed job, and rerun it. Which sequence of API actions should the data engineer perform?

• A. Use the jobs/list endpoint to list jobs, then use the jobs/create endpoint to create a new job, and run the new job using jobs/run-now.
• B. Use the jobs/list endpoint to list jobs, check job run statuses with jobs/runs/list, and rerun a failed job using jobs/run-now.
• C. Use the jobs/get endpoint to retrieve job details, then use jobs/update to rerun failed jobs.
• D. Use the jobs/cancel endpoint to remove failed jobs, then recreate them with jobs/create and run the new ones.

A departing platform owner currently holds ownership of multiple catalogs and controls storage credentials and external locations. A data engineer has been asked to ensure continuity: transfer catalog ownership to the platform team group, delegate ongoing privilege management, and retain the ability to receive and share data via Delta Sharing. Which role must be in place to perform these actions across the metastore?

• A. Account Admin, because account admins can only create metastores but cannot change ownership of catalogs.
• B. Catalog Owner, because catalog owners can transfer any object in any catalog in the metastore.
• C. Metastore Admin, because metastore admins can transfer ownership and manage privileges across all metastore objects, including shares and recipients.
• D. Workspace Admin, because workspace admins can transfer ownership of any Unity Catalog object.