Pass with professional Certified-Data-Engineer-Professional actual quiz materials

Databricks Certified-Data-Engineer-Professional Exam Overview:

Databricks Certified-Data-Engineer-Professional Exam Syllabus Topics:

Databricks Certified Data Engineer Professional Sample Questions:

Question 1

A view is registered with the following code:

Both users and orders are Delta Lake tables.
Which statement describes the results of querying recent_orders?

A. All logic will execute at query time and return the result of joining the valid versions of the source tables at the time the query began.
B. All logic will execute when the view is defined and store the result of joining tables to the DBFS; this stored data will be returned when the view is queried.
C. Results will be computed and cached when the view is defined; these cached results will incrementally update as new records are inserted into source tables.
D. All logic will execute at query time and return the result of joining the valid versions of the source tables at the time the query finishes.

Question 2

What statement is true regarding the retention of job run history?

A. It is retained for 60 days, after which logs are archived
B. It is retained for 60 days, during which you can export notebook run results to HTML
C. It is retained until you export or delete job run logs
D. It is retained for 90 days or until the run-id is re-used through custom run configuration
E. It is retained for 30 days, during which time you can deliver job run logs to DBFS or S3

Question 3

A data engineering workspace was automatically enabled for Unity Catalog, creating a workspace catalog. New team members report they can create tables in the default schema but cannot access table in other schemas within the same workspace catalog. Why are the new team members unable to access tables in other schemas?

A. Workspace catalog permissions are not subject to inheritance rules.
B. Workspace users receive USE CATALOG and specific privileges on default schema only.
C. New users only receive CREATE TABLE privileges on the default schema.
D. Tables in other schemas require additional BROWSEprivileges that new users don't receive automatically

Question 4

A data engineer is tasked with building a nightly batch ETL pipeline that processes very large volumes of raw JSON logs from a data lake into Delta tables for reporting. The data arrives in bulk once per day, and the pipeline takes several hours to complete. Cost efficiency is important, but performance and reliability of completing the pipeline are the highest priorities. Which type of Databricks cluster should the data engineer configure?

A. A job cluster configured to autoscale across multiple workers during the pipeline run.
B. An all-purpose cluster always kept running to ensure low-latency job startup times.
C. A lightweight single-node cluster with low worker node count to reduce costs.
D. A high-concurrency cluster designed for interactive SQL workloads.

Question 5

The data governance team is reviewing code used for deleting records for compliance with GDPR. They note the following logic is used to delete records from the Delta Lake table named users.

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

A. Yes; Delta Lake ACID guarantees provide assurance that the delete command succeeded fully and permanently purged these records.
B. No; files containing deleted records may still be accessible with time travel until a vacuum command is used to remove invalidated data files.
C. No; the Delta cache may return records from previous versions of the table until the cluster is restarted.
D. No; the Delta Lake delete command only provides ACID guarantees when combined with the merge into command.
E. Yes; the Delta cache immediately updates to reflect the latest data files recorded to disk.

Solutions: