A data engineer has configured a Structured Streaming job to read from a table, manipulate the data, and then perform a streaming write into a new table.
The code block used by the data engineer is below:

If the data engineer only wants the query to process all of the available data in as many batches as required, which of the following lines of code should the data engineer use to fill in the blank?

• A.processingTime(1)
• B.trigger(availableNow=True)
• C.trigger(parallelBatch=True)
• D.trigger(processingTime="once")
• E.trigger(continuous="once")

Comment: *

Name: *

Email: *

Verification: *

A data organization leader is upset about the data analysis team's reports being different from the data engineering team's reports. The leader believes the siloed nature of their organization's data engineering and data analysis architectures is to blame.
Which of the following describes how a data lakehouse could alleviate this issue?

• A.Both teams would be able to collaborate on projects in real-time
• B.Both teams would respond more quickly to ad-hoc requests
• C.Both teams would use the same source of truth for their work
• D.Both teams would autoscale their work as data size evolves
• E.Both teams would reorganize to report to the same department

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

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 == "True":
• B.if day_of_week = 1 and review_period:
• C.if day_of_week = 1 & review_period: = "True":
• D.if day_of_week == 1 and review_period:
• E.if day_of_week = 1 and review_period = "True":

Comment: *

Name: *

Email: *

Verification: *

A data engineer wants to create a new table containing the names of customers that live in France.
They have written the following command:

A senior data engineer mentions that it is organization policy to include a table property indicating that the new table includes personally identifiable information (PII).
Which of the following lines of code fills in the above blank to successfully complete the task?

• A.There is no way to indicate whether a table contains PII.
• B."COMMENT PII"
• C.TBLPROPERTIES PII
• D.COMMENT "Contains PII"
• E.PII

Comment: *

Name: *

Email: *

Verification: *