Which of the following benefits of using the Databricks Lakehouse Platform is provided by Delta Lake?

• A.The ability to manipulate the same data using a variety of languages
• B.The ability to collaborate in real time on a single notebook
• C.The ability to set up alerts for query failures
• D.The ability to support batch and streaming workloads
• E.The ability to distribute complex data operations

Comment: *

Name: *

Email: *

Verification: *

A data engineering team has noticed that their Databricks SQL queries are running too slowly when they are submitted to a non-running SQL endpoint. The data engineering team wants this issue to be resolved.
Which of the following approaches can the team use to reduce the time it takes to return results in this scenario?

• A.They can turn on the Auto Stop feature for the SQL endpoint.
• B.They can increase the cluster size of the SQL endpoint.
• C.They can increase the maximum bound of the SQL endpoint's scaling range.
• D.They can turn on the Serverless feature for the SQL endpoint and change the Spot Instance Policy to "Reliability Optimized."
• E.They can turn on the Serverless feature for the SQL endpoint.

Comment: *

Name: *

Email: *

Verification: *

Which of the following commands can be used to write data into a Delta table while avoiding the writing of duplicate records?

• A.INSERT
• B.MERGE
• C.IGNORE
• D.APPEND
• E.DROP

Comment: *

Name: *

Email: *

Verification: *

A data engineer that is new to using Python needs to create a Python function to add two integers together and return the sum?
Which of the following code blocks can the data engineer use to complete this task?

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

Comment: *

Name: *

Email: *

Verification: *

A data engineer has a Declarative Automation Bundle with a job resource keyed as etl_job in databricks.yml. After running databricks bundle deploy, the job appears in the workspace but has not executed.
Which command triggers execution of the deployed job?

• A.databricks bundle deploy run
• B.databricks jobs submit --json <config>
• C.databricks bundle execute etl_job
• D.databricks bundle run etl_job

Comment: *

Name: *

Email: *

Verification: *