Free Access Databricks.Databricks-Certified-Professional-Data-Engineer.v2025-11-20.q139 Practice Test (Page 17)

Question 76

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 ofVACUUMcommands 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 the vacuum command permanently deletes all files containing deleted records, deleted records may be accessible with time travel for around 24 hours.

B.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.

C.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.

D.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.

E.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.

Question 77

A Databricks job has been configured with 3 tasks, each of which is a Databricks notebook. Task A does not depend on other tasks. Tasks B and C run in parallel, with each having a serial dependency on Task A.
If task A fails during a scheduled run, which statement describes the results of this run?

A.Because all tasks are managed as a dependency graph, no changes will be committed to the Lakehouse until all tasks have successfully been completed.

B.Tasks B and C will attempt to run as configured; any changes made in task A will be rolled back due to task failure.

C.Unless all tasks complete successfully, no changes will be committed to the Lakehouse; because task A failed, all commits will be rolled back automatically.

D.Tasks B and C will be skipped; some logic expressed in task A may have been committed before task failure.

E.Tasks B and C will be skipped; task A will not commit any changes because of stage failure.

Question 78

A notebook accepts an input parameter that is assigned to a python variable called department and this is an optional parameter to the notebook, you are looking to control the flow of the code using this parameter. you have to check department variable is present then execute the code and if no department value is passed then skip the code execution. How do you achieve this using python?

A.1.if department is not None:
2. #Execute code
3.else:
4. pass
(Correct)

B.1.if (department is not None)
2. #Execute code
3.else
4. pass

C.1.if department is not None:
2. #Execute code
3.end:
4. pass

D.1.if department is not None:
2. #Execute code
3.then:
4. pass

E.1.if department is None:
2. #Execute code
3.else:
4. pass

Question 79

The marketing team is looking to share data in an aggregate table with the sales organization, but the field names used by the teams do not match, and a number of marketing specific fields have not been approval for the sales org.
Which of the following solutions addresses the situation while emphasizing simplicity?

A.Create a view on the marketing table selecting only these fields approved for the sales team alias the names of any fields that should be standardized to the sales naming conventions.

B.Use a CTAS statement to create a derivative table from the marketing table configure a production jon to propagation changes.

C.Add a parallel table write to the current production pipeline, updating a new sales table that varies as required from marketing table.

D.Create a new table with the required schema and use Delta Lake's DEEP CLONE functionality to sync up changes committed to one table to the corresponding table.

Question 80

An external object storage container has been mounted to the location/mnt/finance_eda_bucket.
The following logic was executed to create a database for the finance team:

After the database was successfully created and permissions configured, a member of the finance team runs the following code:

If all users on the finance team are members of thefinancegroup, which statement describes how thetx_sales table will be created?

A.A logical table will persist the query plan to the Hive Metastore in the Databricks control plane.

B.An external table will be created in the storage container mounted to /mnt/finance eda bucket.

C.A logical table will persist the physical plan to the Hive Metastore in the Databricks control plane.

D.An managed table will be created in the storage container mounted to /mnt/finance eda bucket.

E.A managed table will be created in the DBFS root storage container.

Other Version: 545Databricks.Databricks-Certified-Professional-Data-Engineer.v2025-10-30.q132; 1574Databricks.Databricks-Certified-Professional-Data-Engineer.v2024-03-27.q76; 1297Databricks.Databricks-Certified-Professional-Data-Engineer.v2023-12-11.q54

Latest Upload: 117SAP.C-LCNC-2406.v2026-01-09.q21; 132Salesforce.CRT-550.v2026-01-09.q122; 116Salesforce.Marketing-Cloud-Intelligence.v2026-01-09.q41; 113CIPS.L4M1.v2026-01-09.q27; 105ISTQB.ATM.v2026-01-09.q49; 107SAP.C_BCBAI_2502.v2026-01-08.q38; 110Oracle.1Z0-1056-24.v2026-01-08.q53; 140Huawei.H13-831_V2.0.v2026-01-07.q101; 150Salesforce.Salesforce-Slack-Administrator.v2026-01-06.q103; 140CIPS.L5M15.v2026-01-06.q31

Question 76

Question 77

Question 78

Question 79

Question 80

Download PDF File