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 cade block used by the data engineer is below:

If the data engineer only wants the query to execute a micro-batch to process data every 5 seconds, which of the following lines of code should the data engineer use to fill in the blank?

• A.trigger("5 seconds")
• B.trigger()
• C.trigger(once="5 seconds")
• D.trigger(processingTime="5 seconds")
• E.trigger(continuous="5 seconds")

Comment: *

Name: *

Email: *

Verification: *

Which of the following commands will return the location of database customer360?

• A.DESCRIBE LOCATION customer360;
• B.DROP DATABASE customer360;
• C.ALTER DATABASE customer360 SET DBPROPERTIES ('location' = '/user'};
• D.USE DATABASE customer360;
• E.DESCRIBE DATABASE customer360;

Comment: *

Name: *

Email: *

Verification: *

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 cade block used by the data engineer is below:

If the data engineer only wants the query to execute a micro-batch to process data every 5 seconds, which of the following lines of code should the data engineer use to fill in the blank?

• A.trigger("5 seconds")
• B.trigger()
• C.trigger(once="5 seconds")
• D.trigger(processingTime="5 seconds")
• E.trigger(continuous="5 seconds")

Comment: *

Name: *

Email: *

Verification: *

Which Databricks SQL predicate correctly performs a null-safe equality comparison so that rows are matched when both sides are NULL or when both are equal non-NULL values?

• A.WHERE customer_id = :cid
• B.WHERE COALESCE(customer_id, '') = COALESCE(:cid, '')
• C.WHERE customer_id <=> :cid
• D.WHERE customer_id <> :cid OR customer_id IS NULL

Comment: *

Name: *

Email: *

Verification: *

A dataset has been defined using Delta Live Tables and includes an expectations clause:
CONSTRAINT valid_timestamp EXPECT (timestamp > '2020-01-01') ON VIOLATION FAIL UPDATE What is the expected behavior when a batch of data containing data that violates these constraints is processed?

• A.Records that violate the expectation cause the job to fail.
• B.Records that violate the expectation are added to the target dataset and flagged as invalid in a field added to the target dataset.
• C.Records that violate the expectation are dropped from the target dataset and recorded as invalid in the event log.
• D.Records that violate the expectation are added to the target dataset and recorded as invalid in the event log.

Comment: *

Name: *

Email: *

Verification: *