Practice Databricks-Certified-Professional-Data-Engineer Exam Online

Question 1

Which of the following statements best describes Delta Lake Auto Compaction?

A : Auto Compaction occurs after a write to a table has succeeded to check if files can further be compacted; if yes, it runs an OPTIMIZE job with Z-Ordering toward a file size of 128 MB

B : Auto Compaction occurs after a write to a table has succeeded to check if files can further be compacted; if yes, it runs an OPTIMIZE job without Z-Ordering toward a file size of 128 MB

C : Auto Compaction occurs after a write to a table has succeeded to check if files can further be compacted; if yes, it runs an OPTIMIZE job with Z-Ordering toward a file size of 1 GB.

D : Auto Compaction occurs after a write to a table has succeeded to check if files can further be compacted; if yes, it runs an OPTIMIZE job without Z-Ordering toward a file size of 1 GB.

E : None of the above statements correctly describe Delta Lake Auto Compaction.

Answer: B

Question 2

Which of the following describes the minimal permissions a data engineer needs to start and terminate an existing cluster ?

A : “Can Attach To” privilege on the cluster

B : “Can Restart” privilege on the cluster

C : “Can Manage” privilege on the cluster

D : Cluster creation allowed + “Can Attach To” privileges on the cluster

E : Cluster creation allowed + “Can Restart” privileges on the cluster

Answer: B

Question 3

The Databricks workspace administrator has configured interactive clusters for each of the data engineering

groups. To control costs, clusters are set to terminate after 30 minutes of inactivity. Each user should be able to

execute workloads against their assigned clusters at any time of the day.

Assuming users have been added to a workspace but not granted any permissions, which of the following

describes the minimal permissions a user would need to start and attach to an already configured cluster.

A : "Can Manage" privileges on the required cluster

B : Workspace Admin privileges, cluster creation allowed, "Can Attach To" privileges on the required cluster

C : Cluster creation allowed, "Can Attach To" privileges on the required cluster

D : "Can Restart" privileges on the required cluster

E : Cluster creation allowed, "Can Restart" privileges on the required cluster

Answer: A

Question 4

Incorporating unit tests into a PySpark application requires upfront attention to the design of your jobs, or a potentially significant refactoring of existing code. Which statement describes a main benefit that offset this additional effort?

A : Improves the quality of your data

B : Validates a complete use case of your application

C : Troubleshooting is easier since all steps are isolated and tested individually

D : Yields faster deployment and execution times

E : Ensures that all steps interact correctly to achieve the desired end result

Answer: C

Question 5

Which of the following commands allows data engineers to perform an insert-only merge?

A : MERGE INTO orders

USING new_orders

ON orders.orders_id = new_orders.orders_id

WHEN MATCHED

INSERT *

B : MERGE INTO orders

USING new_orders

ON orders.orders_id = new_orders.orders_id

WHEN NOT MATCHED

INSERT *

C : MERGE INTO orders

USING new_orders

ON orders.orders_id = new_orders.orders_id

WHEN MATCHED

INSERT *

WHEN NOT MATCHED

IGNORE *

D : MERGE INTO orders

USING new_orders

ON orders.orders_id = new_orders.orders_id

WHEN NOT MATCHED

INSERT *

WHEN MATCHED

IGNORE *

E : MERGE INTO orders

USING new_orders

ON orders.orders_id = new_orders.orders_id

WHEN NOT MATCHED

INSERT *

ELSE IGNORE *

Answer: B

Name:	Databricks Certified Professional Data Engineer
Exam Code:	Databricks-Certified-Professional-Data-Engineer
Certification:	Databricks Certified Professional
Vendor:	Databricks
Total Questions:	198
Last Updated:	Apr 23, 2024

Databricks Databricks-Certified-Professional-Data-Engineer