Question 1

A data engineer wants to upload a CSV file from local system storage to the DBFS of a Databricks workspace. They have Databricks CLI already configured on the local system.

Which of the following Databricks CLI commands can the data engineer use to complete this task ?

Options :

A : workspace

B : fs

C : jobs

D : configure

E : libraries

Answer: B

Question 2

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

Question 3

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?

Options :

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

Question 4

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 ?

Options :

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 5

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

Options :

A : MERGE INTO orders

USING new_orders

ON orders.orders_id = new_orders.orders_id

WHEN MATCHED

INSERT *

B : MERGE INTO orders

USING new_orders

ON orders.orders_id = new_orders.orders_id

WHEN NOT MATCHED

INSERT *

C : MERGE INTO orders

USING new_orders

ON orders.orders_id = new_orders.orders_id

WHEN MATCHED

INSERT *

WHEN NOT MATCHED

IGNORE *

D : MERGE INTO orders

USING new_orders

ON orders.orders_id = new_orders.orders_id

WHEN NOT MATCHED

INSERT *

WHEN MATCHED

IGNORE *

E : MERGE INTO orders

USING new_orders

ON orders.orders_id = new_orders.orders_id

WHEN NOT MATCHED

INSERT *

ELSE IGNORE *

Answer: B

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

Buying Options: