A data engineer needs to apply custom logic to string column city in table stores for a specific use case. In order to apply this custom logic at scale, the data engineer wants to create a SQL user-defined function (UDF).
Which of the following code blocks creates this SQL UDF?

• A.
• B.
• C.
• D.
• E.

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 DROP ROW What is the expected behavior when a batch of data containing data that violates these constraints is processed?

• A.Records that violate the expectation are dropped from the target dataset and loaded into a quarantine table.
• 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.
• E.Records that violate the expectation cause the job to fail.

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 reviewing the documentation on audit logs in Databricks for compliance purposes and needs to understand the format in which audit logs output events.
How are events formatted in Databricks audit logs?

• A.In Databricks, audit logs output events in a CSV format.
• B.In Databricks, audit logs output events in a plain text format. In Databricks, audit logs output events in a JSON format.
• C.In Databricks, audit logs output events in an XML format.

Comment: *

Name: *

Email: *

Verification: *

A new data engineering team team has been assigned to an ELT project. The new data engineering team will need full privileges on the table sales to fully manage the project.
Which command can be used to grant full permissions on the database to the new data engineering team?

• A.grant all privileges on table sales TO team;
• B.GRANT SELECT ON TABLE sales TO team;
• C.GRANT SELECT CREATE MODIFY ON TABLE sales TO team;
• D.GRANT ALL PRIVILEGES ON TABLE team TO sales;

Comment: *

Name: *

Email: *

Verification: *