Free Databricks Databricks-Certified-Professional-Data-Engineer Exam Dumps Questions & Answers

A junior developer complains that the code in their notebook isn ' t producing the correct results in the development environment. A shared screenshot reveals that while they ' re using a notebook versioned with Databricks Repos, they ' re using a personal branch that contains old logic. The desired branch named dev-
2.3.9 is not available from the branch selection dropdown.
Which approach will allow this developer to review the current logic for this notebook?

• A.Use Repos to pull changes from the remote Git repository and select the dev-2.3.9 branch.
• B.Use Repos to make a pull request use the Databricks REST API to update the current branch to dev-
  2.3.9
• C.Merge all changes back to the main branch in the remote Git repository and clone the repo again
• D.Use Repos to checkout the dev-2.3.9 branch and auto-resolve conflicts with the current branch
• E.Use Repos to merge the current branch and the dev-2.3.9 branch, then make a pull request to sync with the remote repository

Assuming that the Databricks CLI has been installed and configured correctly, which Databricks CLI command can be used to upload a custom Python Wheel to object storage mounted with the DBFS for use with a production job?

• A.configure
• B.jobs
• C.fs
• D.libraries
• E.workspace

A data team is implementing an append-only Delta Lake pipeline that processes both batch and streaming data . They want to ensure that schema changes in the source data are automatically incorporated without breaking the pipeline.
Which configuration should the team use when writing data to the Delta table?

• A.ignoreChanges = false
• B.validateSchema = false
• C.mergeSchema = true
• D.overwriteSchema = true

A CHECK constraint has been successfully added to the Delta table named activity_details using the following logic:

A batch job is attempting to insert new records to the table, including a record where latitude = 45.50 and longitude = 212.67.
Which statement describes the outcome of this batch insert?

• A.The write will fail completely because of the constraint violation and no records will be inserted into the target table.
• B.The write will include all records in the target table; any violations will be indicated in the boolean column named valid_coordinates.
• C.The write will insert all records except those that violate the table constraints; the violating records will be recorded to a quarantine table.
• D.The write will insert all records except those that violate the table constraints; the violating records will be reported in a warning log.
• E.The write will fail when the violating record is reached; any records previously processed will be recorded to the target table.

The data governance team is reviewing user for deleting records for compliance with GDPR. The following logic has been implemented to propagate deleted requests from the user_lookup table to the user aggregate table.

Assuming that user_id is a unique identifying key and that all users have requested deletion have been removed from the user_lookup table, which statement describes whether successfully executing the above logic guarantees that the records to be deleted from the user_aggregates table are no longer accessible and why?

• A.No: the Delta Lake DELETE command only provides ACID guarantees when combined with the MERGE INTO command
• B.Yes: Delta Lake ACID guarantees provide assurance that the DELETE command successed fully and permanently purged these records.
• C.No: the change data feed only tracks inserts and updates not deleted records.
• D.No: files containing deleted records may still be accessible with time travel until a BACUM command is used to remove invalidated data files.