Free Databricks-Certified-Professional-Data-Engineer Exam Questions - Easiest Way for Success

Prepare for the Databricks Databricks-Certified-Professional-Data-Engineer exam questions with our authentic preparation materials, including free Databricks-Certified-Professional-Data-Engineer practice exam questions and answers. TheExamsLab provides all the support you need to succeed in the Databricks Certified Professional Data Engineer Databricks-Certified-Professional-Data-Engineer exam. This dedication to student success is why we have the most satisfied Databricks-Certified-Professional-Data-Engineer certification exam candidates worldwide.

Page: 1 / 50

Total 247 Questions | Updated On: Sep 11, 2024

Add To Cart

Question 1

The data engineering team maintains the following code:

Assuming that this code produces logically correct results and the data in the source table has been deduplicated and validated, which statement describes what will occur when this code is executed?

A : The silver_customer_sales table will be overwritten by aggregated values calculated from all records in the gold_customer_lifetime_sales_summary table as a batch job.

B : A batch job will update the gold_customer_lifetime_sales_summary table, replacing only those rows that have different values than the current version of the table, using customer_id as the primary key.

C : The gold_customer_lifetime_sales_summary table will be overwritten by aggregated values calculated from all records in the silver_customer_sales table as a batch job.

D : An incremental job will leverage running information in the state store to update aggregate values in the gold_customer_lifetime_sales_summary table.

E : An incremental job will detect if new rows have been written to the silver_customer_sales table; if new rows are detected, all aggregates will be recalculated and used to overwrite the gold_customer_lifetime_sales_summary table.

Answer: E

Question 2

A junior data engineer has manually configured a series of jobs using the Databricks Jobs UI. Upon reviewing their work, the engineer realizes that they are listed as the "Owner" for each job. They attempt to transfer "Owner" privileges to the "DevOps" group, but cannot successfully accomplish this task. Which statement explains what is preventing this privilege transfer?

A : Databricks jobs must have exactly one owner; "Owner" privileges cannot be assigned to a group

B : The creator of a Databricks job will always have "Owner" privileges; this configuration cannot be changed.

C : Other than the default "admins" group, only individual users can be granted privileges on jobs.

D : A user can only transfer job ownership to a group if they are also a member of that group

E : Only workspace administrators can grant "Owner" privileges to a group.

Answer: A

Question 3

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 4

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 5

A : Databricks jobs must have exactly one owner; "Owner" privileges cannot be assigned to a group

B : The creator of a Databricks job will always have "Owner" privileges; this configuration cannot be changed.

C : Other than the default "admins" group, only individual users can be granted privileges on jobs.

D : A user can only transfer job ownership to a group if they are also a member of that group

E : Only workspace administrators can grant "Owner" privileges to a group.

Answer: A

Page: 1 / 50

Total 247 Questions | Updated On: Sep 11, 2024

Add To Cart