Question 1

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?

Options :

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 2

Which statement regarding static Delta tables in Stream-Static joins is correct?

Options :

A : Static Delta tables must be small enough to be broadcasted to all worker nodes in the cluster.

B : Static Delta tables need to be partitioned in order to be used in stream-static join.

C : Static Delta tables need to be refreshed with REFRESH TABLE command for each microbatch of a stream-static join

D : The latest version of the static Delta table is returned each time it is queried by a microbatch of the stream-static join

E : The latest version of the static Delta table is returned only for the first microbatch of the stream-static join. Then, it will be cached to be used by any upcoming microbatch.

Answer: D

Question 3

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 benefit offsets this additional effort?

Options :

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 4

When using CLI or REST API to get results from jobs with multiple tasks, which statement correctly describes the response structure?

Options :

A : Each run of a job will have a unique job_id; all tasks within this job will have a unique job_id

B : Each run of a job will have a unique job_id; all tasks within this job will have a unique task_id

C : Each run of a job will have a unique orchestration_id; all tasks within this job will have a unique run_id

D : Each run of a job will have a unique run_id; all tasks within this job will have a unique task_id

E : Each run of a job will have a unique run_id; all tasks within this job will also have a unique run_id

Answer: D

Question 5

Which of the following statements correctly describes End-to-End Testing ?

Options :

A : It’s an approach to simulate a user experience to ensure that the application can run properly under real-world scenarios

B : It’s an approach to test the interaction between subsystems of an application to ensure that modules work properly as a group.

C : It’s an approach to test individual units of code to determine whether they still work as expected if new changes are made to them in the future

D : It’s an approach to verify if each feature of the application works as per the business requirements

E : It’s an approach to measure the reliability, speed, scalability, and responsiveness of an application

Answer: A

Higher Test Marks with Free Online Databricks-Certified-Professional-Data-Engineer Exam Practice

Buying Options: