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 describes the storage organization of a Delta table?

• A.Delta tables are stored in a single file that contains data, history, metadata, and other attributes.
• B.Delta tables store their data in a single file and all metadata in a collection of files in a separate location.
• C.Delta tables are stored in a collection of files that contain data, history, metadata, and other attributes.
• D.Delta tables are stored in a collection of files that contain only the data stored within the table.
• E.Delta tables are stored in a single file that contains only the data stored within the table.

Comment: *

Name: *

Email: *

Verification: *

Which of the following describes the storage organization of a Delta table?

• A.Delta tables are stored in a single file that contains data, history, metadata, and other attributes.
• B.Delta tables store their data in a single file and all metadata in a collection of files in a separate location.
• C.Delta tables are stored in a collection of files that contain data, history, metadata, and other attributes.
• D.Delta tables are stored in a collection of files that contain only the data stored within the table.
• E.Delta tables are stored in a single file that contains only the data stored within the table.

Comment: *

Name: *

Email: *

Verification: *

A data analyst has developed a query that runs against Delta table. They want help from the data engineering team to implement a series of tests to ensure the data returned by the query is clean. However, the data engineering team uses Python for its tests rather than SQL.
Which of the following operations could the data engineering team use to run the query and operate with the results in PySpark?

• A.SELECT * FROM sales
• B.spark.delta.table
• C.spark.sql
• D.There is no way to share data between PySpark and SQL.
• E.spark.table

Comment: *

Name: *

Email: *

Verification: *

A data analysis team has noticed that their Databricks SQL queries are running too slowly when connected to their always-on SQL endpoint. They claim that this issue is present when many members of the team are running small queries simultaneously. They ask the data engineering team for help. The data engineering team notices that each of the team's queries uses the same SQL endpoint.
Which of the following approaches can the data engineering team use to improve the latency of the team's queries?

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

Comment: *

Name: *

Email: *

Verification: *