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: Jan 10, 2025

Add To Cart

Question 1

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

A : MERGE INTO ordersUSING new_ordersON orders.orders_id = new_orders.orders_idWHEN MATCHED INSERT *

B : MERGE INTO ordersUSING new_ordersON orders.orders_id = new_orders.orders_idWHEN NOT MATCHED INSERT *

C : MERGE INTO ordersUSING new_ordersON orders.orders_id = new_orders.orders_idWHEN MATCHED INSERT *WHEN NOT MATCHED IGNORE *

D : MERGE INTO ordersUSING new_ordersON orders.orders_id = new_orders.orders_idWHEN NOT MATCHED INSERT *WHEN MATCHED IGNORE *

E : MERGE INTO ordersUSING new_ordersON orders.orders_id = new_orders.orders_idWHEN NOT MATCHED INSERT *ELSE IGNORE *

Answer: B

Question 2

The data engineering team maintains the following code:

Databricks-Certified-Professional-Data-Engineer-page61-image9

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

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

B : The enriched_itemized_orders_by_account table will be overwritten using the current valid version of data in each of the three tables referenced in the join logic.

C : An incremental job will leverage information in the state store to identify unjoined rows in the source tables and write these rows to the enriched_iteinized_orders_by_account table.

D : An incremental job will detect if new rows have been written to any of the source tables; if new rows are detected, all results will be recalculated and used to overwrite the enriched_itemized_orders_by_account table

E : No computation will occur until enriched_itemized_orders_by_account is queried; upon query materialization, results will be calculated using the current valid version of data in each of the three tables referenced in the join logic.

Answer: B

Question 3

A data architect has designed a system in which two Structured Streaming jobs will concurrently write to a single bronze Delta table. Each job is subscribing to a different topic from an Apache Kafka source, but they will write data with the same schema. To keep the directory structure simple, a data engineer has decided to nest a checkpoint directory to be shared by both streams. The proposed directory structure is displayed below:

Databricks-Certified-Professional-Data-Engineer-page61-image5

Which statement describes whether this checkpoint directory structure is valid for the given scenario and why?

A : No; Delta Lake manages streaming checkpoints in the transaction log.

B : Yes; both of the streams can share a single checkpoint directory.

C : No; only one stream can write to a Delta Lake table

D : Yes; Delta Lake supports infinite concurrent writers.

E : No; each of the streams needs to have its own checkpoint directory.

Answer: E

Question 4

The data engineering team is using the LOCATION keyword for every new Delta Lake table created in the Lakehouse.

Which of the following describes the purpose of using the LOCATION keyword in this case ?

A : The LOCATION keyword is used to configure the created Delta Lake tables as managed tables.

B : The LOCATION keyword is used to configure the created Delta Lake tables as external tables.

C : The LOCATION keyword is used to define the created Delta Lake tables in an external database.

D : The LOCATION keyword is used to define the created Delta Lake tables in a database over a JDBC connection.

E : The LOCATION keyword is used to set a default schema and checkpoint location for the created Delta Lake tables.

Answer: B

Question 5

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

Page: 1 / 50

Total 247 Questions | Updated On: Jan 10, 2025

Add To Cart