Online Access Free Databricks-Certified-Data-Engineer-Associate Practice Test

Which query is performing a streaming hop from raw data to a Bronze table?

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

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

Which of the following describes a benefit of creating an external table from Parquet rather than CSV when using a CREATE TABLE AS SELECT statement?

• A.Parquet files will become Delta tables
• B.CREATE TABLE AS SELECT statements cannot be used on files
• C.Parquet files have the ability to be optimized
• D.Parquet files can be partitioned
• E.Parquet files have a well-defined schema

Which of the following approaches should be used to send the Databricks Job owner an email in the case that the Job fails?

• A.Manually programming in an alert system in each cell of the Notebook
• B.MLflow Model Registry Webhooks
• C.Setting up an Alert in the Notebook
• D.There is no way to notify the Job owner in the case of Job failure
• E.Setting up an Alert in the Job page

An engineering manager wants to monitor the performance of a recent project using a Databricks SQL query. For the first week following the project's release, the manager wants the query results to be updated every minute. However, the manager is concerned that the compute resources used for the query will be left running and cost the organization a lot of money beyond the first week of the project's release.
Which of the following approaches can the engineering team use to ensure the query does not cost the organization any money beyond the first week of the project's release?

• A.They can set a limit to the number of DBUs that are consumed by the SQL Endpoint.
• B.They can set the query's refresh schedule to end after a certain number of refreshes.
• C.They can set the query's refresh schedule to end on a certain date in the query scheduler.
• D.They cannot ensure the query does not cost the organization money beyond the first week of the project's release.
• E.They can set a limit to the number of individuals that are able to manage the query's refresh schedule.