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: *

Which of the following describes the relationship between Gold tables and Silver tables?

• A.Gold tables are more likely to contain aggregations than Silver tables.
• B.Gold tables are more likely to contain more data than Silver tables.
• C.Gold tables are more likely to contain truthful data than Silver tables.
• D.Gold tables are more likely to contain a less refined view of data than Silver tables.
• E.Gold tables are more likely to contain valuable data than Silver tables.

Comment: *

Name: *

Email: *

Verification: *

In which of the following scenarios should a data engineer use the MERGE INTO command instead of the INSERT INTO command?

• A.When the location of the data needs to be changed
• B.When the target table is an external table
• C.When the source table can be deleted
• D.When the target table cannot contain duplicate records
• E.When the source is not a Delta 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 create a table in Databricks using data from their organization's existing SQLite database.
They run the following command:

Which of the following lines of code fills in the above blank to successfully complete the task?

• A.org.apache.spark.sql.jdbc
• B.autoloader
• C.DELTA
• D.sqlite
• E.org.apache.spark.sql.sqlite

Comment: *

Name: *

Email: *

Verification: *