Free Databricks Databricks-Certified-Professional-Data-Engineer Exam Questions

Become Databricks Certified with updated Databricks-Certified-Professional-Data-Engineer exam questions and correct answers

Page: 1 / 50

Total 247 Questions | Updated On: Nov 12, 2024

Add To Cart

Question 1

A data engineer wants to use Databricks REST API to retrieve the metadata of a job run using its run_id.

Which of the following REST API calls achieves this requirement ?

A : Send POST request to the endpoint ‘api/2.1/jobs/runs/get’

B : Send GET request to the endpoint ‘api/2.1/jobs/runs/get’

C : Send POST request to the endpoint ‘api/2.1/jobs/runs/get-output’

D : Send GET request to the endpoint ‘api/2.1/jobs/runs/get-output’

E : Send GET request to the endpoint ‘api/2.1/jobs/runs/get-metadata’

Answer: B

Question 2

A junior data engineer seeks to leverage Delta Lake's Change Data Feed functionality to create a Type 1 table representing all of the values that have ever been valid for all rows in a bronze table created with the property delta.enableChangeDataFeed = true. They plan to execute the following code as a daily job:

Databricks-Certified-Professional-Data-Engineer-page61-image24

Which statement describes the execution and results of running the above query multiple times?

A : ch time the job is executed, newly updated records will be merged into the target table, overwriting previous values with the same primary keys.

B : ch time the job is executed, the entire available history of inserted or updated records will be appended to the target table, resulting in many duplicate entries.

C : ch time the job is executed, the target table will be overwritten using the entire history of inserted or updated records, giving the desired result.

D : ch time the job is executed, the differences between the original and current versions are calculated; this may result in duplicate entries for some records.

E : ch time the job is executed, only those records that have been inserted or updated since the last execution will be appended to the target table, giving the desired result.

Answer: B

Question 3

The data engineering team has a secret scope named ‘DataOps-Prod’ that contains all secrets needed by DataOps engineers in a production workspace.

Which of the following is the minimum permission required for the DataOps engineers to use the secrets in this scope ?

A : MANAGE permission on the “DataOps-Prod” scope

B : READ permission on the “DataOps-Prod” scope

C : MANAGE permission on each secret in the “DataOps-Prod” scope

D : READ permission on each secret in the “DataOps-Prod” scope

E : Workspace Administrator role

Answer: B

Question 4

A distributed team of data analysts share computing resources on an interactive cluster with autoscaling configured. In order to better manage costs and query throughput, the workspace administrator is hoping to evaluate whether cluster upscaling is caused by many concurrent users or resource-intensive queries. In which location can one review the timeline for cluster resizing events?

A : Workspace audit logs

B : Driver's log file

C : Ganglia

D : Cluster Event Log

E : Executor's log file

Answer: D

Question 5

A data engineer is analyzing a Spark job via the Spark UI. They have the following summary metrics for 27 completed tasks in a particular stage

Which conclusion can the data engineer draw from the above statistics ?

A : All task are operating over partitions with even amounts of data

B : All task are operating over empty or near empty partitions

C : All tasks are operating over partitions with larger skewed amounts of data.

D : Number of tasks are operating over partitions with larger skewed amounts of data.

E : Number of tasks are operating over empty or near empty partitions

Answer: D

Page: 1 / 50

Total 247 Questions | Updated On: Nov 12, 2024

Add To Cart