Get real Certified-Data-Engineer-Professional exam questions for better preparation

Databricks Certified-Data-Engineer-Professional Exam Overview:

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

Databricks Certified Data Engineer Professional Sample Questions:

1. A data engineer is optimizing a MERGE operation on an 800GB UC-managed table that experiences frequent updates and deletions. Which two actions should the engineer prioritize to improve MERGE performance? (Choose two.)

A) Partition the table by date.
B) Apply liquid clustering using the merge join keys.
C) Enable deletion vectors on the table if not already enabled.
D) Overwrite the table instead of Merge.
E) Use ZORDER on high-cardinality columns.

2. 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 change data feed only tracks inserts and updates not deleted records.
B) No; files containing deleted records may still be accessible with time travel until a BACUM command is used to remove invalidated data files.
C) Yes; the change data feed uses foreign keys to ensure delete consistency throughout the Lakehouse.
D) No; the Delta Lake DELETE command only provides ACID guarantees when combined with the MERGE INTO command
E) Yes; Delta Lake ACID guarantees provide assurance that the DELETE command successed fully and permanently purged these records.

3. A data engineer is designing a secure data sharing strategy for their organization. The company needs to share sensitive customer analytics data with two different partners. Partner A uses Databricks with Unity Catalog enabled, while Partner B uses Apache Spark on AWS without Databricks. How should the company implement secure data sharing for these scenarios?

A) Both partners should use the same Delta Sharing approach since security requirements are identical. You should create bearer tokens for both partners and use the open sharing protocol (D2O) for maximum compatibility.
B) Databricks-to-Databricks sharing (D2D) can only be used within the same cloud provider, so you must use open sharing (D2O) for any cross-cloud scenarios. Unit Catalog governance is not available when sharing with external platforms.
C) For Partner A, implement Databricks-to-Databricks sharing (D2D) with Unit Catalog integration and no-token exchange system. For Partner B, use open sharing protocol (D2O) with either bearer tokens or OIDC federation for authentication, ensuring both approaches maintain robust security and governance.
D) Open sharing protocol (D2O) should be used for both partners because it provides better security than D2D sharing. The bearer token approach is always more secure than Unity Catalog's native authentication.

4. The data engineering team has configured a job to process customer requests to be forgotten (have their data deleted). All user data that needs to be deleted is stored in Delta Lake tables using default table settings.
The team has decided to process all deletions from the previous week as a batch job at 1am each Sunday. The total duration of this job is less than one hour. Every Monday at 3am, a batch job executes a series of VACUUM commands on all Delta Lake tables throughout the organization.
The compliance officer has recently learned about Delta Lake's time travel functionality. They are concerned that this might allow continued access to deleted data.
Assuming all delete logic is correctly implemented, which statement correctly addresses this concern?

A) Because Delta Lake's delete statements have ACID guarantees, deleted records will be permanently purged from all storage systems as soon as a delete job completes.
B) Because the default data retention threshold is 7 days, data files containing deleted records will be retained until the vacuum job is run 8 days later.
C) Because the default data retention threshold is 24 hours, data files containing deleted records will be retained until the vacuum job is run the following day.
D) Because Delta Lake time travel provides full access to the entire history of a table, deleted records can always be recreated by users with full admin privileges.
E) Because the vacuum command permanently deletes all files containing deleted records, deleted records may be accessible with time travel for around 24 hours.

5. A Delta Lake table representing metadata about content from user has the following schema:
user_id LONG, post_text STRING, post_id STRING, longitude FLOAT, latitude FLOAT, post_time TIMESTAMP, date DATE Based on the above schema, which column is a good candidate for partitioning the Delta Table?

A) Post_time
B) Post_id
C) Date
D) User_id
E) latitude

Solutions: