A data engineer has left the organization. The data team needs to transfer ownership of the data engineer's Delta tables to a new data engineer. The new data engineer is the lead engineer on the data team.
Assuming the original data engineer no longer has access, which of the following individuals must be the one to transfer ownership of the Delta tables in Data Explorer?

• A.Databricks account representative
• B.This transfer is not possible
• C.Workspace administrator
• D.New lead data engineer
• E.Original data engineer

Comment: *

Name: *

Email: *

Verification: *

A data engineer only wants to execute the final block of a Python program if the Python variable day_of_week is equal to 1 and the Python variable review_period is True.
Which of the following control flow statements should the data engineer use to begin this conditionally executed code block?

• A.if day_of_week = 1 and review_period:
• B.if day_of_week = 1 and review_period = "True":
• C.if day_of_week == 1 and review_period == "True":
• D.if day_of_week == 1 and review_period:
• E.if day_of_week = 1 & review_period: = "True":

Comment: *

Name: *

Email: *

Verification: *

Which of the following commands will return the number of null values in the member_id column?

• A.SELECT count(member_id) FROM my_table;
• B.SELECT count(member_id) - count_null(member_id) FROM my_table;
• C.SELECT count_if(member_id IS NULL) FROM my_table;
• D.SELECT null(member_id) FROM my_table;
• E.SELECT count_null(member_id) FROM my_table;

Comment: *

Name: *

Email: *

Verification: *

A data engineer wants to create a data entity from a couple of tables. The data entity must be used by other data engineers in other sessions. It also must be saved to a physical location.
Which of the following data entities should the data engineer create?

• A.Database
• B.Function
• C.View
• D.Temporary view
• E.Table

Comment: *

Name: *

Email: *

Verification: *

A data engineer is using the following code block as part of a batch ingestion pipeline to read from a composable table:

Which of the following changes needs to be made so this code block will work when the transactions table is a stream source?

• A.Replace predict with a stream-friendly prediction function
• B.Replace schema(schema) with option ("maxFilesPerTrigger", 1)
• C.Replace "transactions" with the path to the location of the Delta table
• D.Replace format("delta") with format("stream")
• E.Replace spark.read with spark.readStream

Comment: *

Name: *

Email: *

Verification: *