Databricks-Certified-Professional-Data-Engineer Practice Online

Question 1

Which of the following statements regarding the retention policy of Delta lake CDF is correct ?

A : Running the VACUUM command on the table deletes CDF data as well

B : Running the VACUUM command on the table does not deletes CDF data

C : Running the VACUUM command on the table does not deletes CDF data unless CASCADE clause is set to true

D : CDF data files can be purged by running VACUUM CHANGES command

E : CDF data files can never be permanently purged from Delta Lake

Answer: A

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

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

An upstream source writes Parquet data as hourly batches to directories named with the current date. A nightly batch job runs the following code to ingest all data from the previous day as indicated by the date variable:

Databricks-Certified-Professional-Data-Engineer-page61-image7

Assume that the fields customer_id and order_id serve as a composite key to uniquely identify each order. If the upstream system is known to occasionally produce duplicate entries for a single order hours apart, which statement is correct

A : Each write to the orders table will only contain unique records, and only those records without duplicates in the target table will be written.

B : Each write to the orders table will only contain unique records, but newly written records may have duplicates already present in the target table.

C : Each write to the orders table will only contain unique records; if existing records with the same key are present in the target table, these records will be overwritten.

D : Each write to the orders table will only contain unique records; if existing records with the same key are present in the target table, the operation will fail.

E : Each write to the orders table will run deduplication over the union of new and existing records, ensuring no duplicate records are present.

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:	May 14, 2024

Download Demo Databricks-Certified-Professional-Data-Engineer Dumps

Create Account

Password Recovery

Databricks-Certified-Professional-Data-Engineer Practice Online

Download Demo Databricks-Certified-Professional-Data-Engineer Dumps

Member Login

Create Account

Password Recovery

Databricks-Certified-Professional-Data-Engineer Practice Online