Which of the following tools is used by Auto Loader process data incrementally?

• A.Checkpointing
• B.Spark Structured Streaming
• C.Data Explorer
• D.Unity Catalog
• E.Databricks SQL

Comment: *

Name: *

Email: *

Verification: *

Which of the following commands will return the number of null values in the member_id column?

• A.SELECT count(member_id) FROM my_table;
• B.SELECT count(member_id) - count_null(member_id) FROM my_table;
• C.SELECT count_if(member_id IS NULL) FROM my_table;
• D.SELECT null(member_id) FROM my_table;
• E.SELECT count_null(member_id) FROM my_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: *

A data engineer is running code in a Databricks Repo that is cloned from a central Git repository. A colleague of the data engineer informs them that changes have been made and synced to the central Git repository. The data engineer now needs to sync their Databricks Repo to get the changes from the central Git repository.
Which of the following Git operations does the data engineer need to run to accomplish this task?

• A.Merge
• B.Push
• C.Pull
• D.Commit
• E.Clone

Comment: *

Name: *

Email: *

Verification: *

A data engineer has been using a Databricks SQL dashboard to monitor the cleanliness of the input data to an ELT job. The ELT job has its Databricks SQL query that returns the number of input records containing unexpected NULL values. The data engineer wants their entire team to be notified via a messaging webhook whenever this value reaches 100.
Which of the following approaches can the data engineer use to notify their entire team via a messaging webhook whenever the number of NULL values reaches 100?

• A.They can set up an Alert with a custom template.
• B.They can set up an Alert without notifications.
• C.They can set up an Alert with a new email alert destination.
• D.They can set up an Alert with a new webhook alert destination.
• E.They can set up an Alert with one-time notifications.

Comment: *

Name: *

Email: *

Verification: *