Which of the following describes a scenario in which a data engineer will want to use a single-node cluster?

• A.When they are working interactively with a small amount of data
• B.When they are running automated reports to be refreshed as quickly as possible
• C.When they are working with SQL within Databricks SQL
• D.When they are concerned about the ability to automatically scale with larger data
• E.When they are manually running reports with a large amount of data

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 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 engineer needs to view the full history of operations performed on a Delta table, including timestamps, user information, and operation types. Which SQL command provides this audit information?

• A.DESCRIBE HISTORY
• B.SHOW DATABASES
• C.DESCRIBE TABLE
• D.SHOW TABLES

Comment: *

Name: *

Email: *

Verification: *

A data engineer has a single-task Job that runs each morning before they begin working. After identifying an upstream data issue, they need to set up another task to run a new notebook prior to the original task.
Which of the following approaches can the data engineer use to set up the new task?

• A.They can clone the existing task in the existing Job and update it to run the new notebook.
• B.They can create a new task in the existing Job and then add it as a dependency of the original task.
• C.They can create a new task in the existing Job and then add the original task as a dependency of the new task.
• D.They can create a new job from scratch and add both tasks to run concurrently.
• E.They can clone the existing task to a new Job and then edit it to run the new notebook.

Comment: *

Name: *

Email: *

Verification: *