Free Access GAQM.Databricks-Certified-Data-Engineer-Associate.v2024-11-27.q107 Practice Test (Page 9)

Question 36

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."

Question 37

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 turn on the Auto Stop feature for the SQL endpoint.

C.They can turn on the Serverless feature for the SQL endpoint.

D.They can turn on the Serverless feature for the SQL endpoint and change the Spot Instance Policy to
"Reliability Optimized."

E.They can increase the maximum bound of the SQL endpoint's scaling range.

Question 38

A data engineer wants to create a relational object by pulling data from two tables. The relational object does not need to be used by other data engineers in other sessions. In order to save on storage costs, the data engineer wants to avoid copying and storing physical data.
Which of the following relational objects should the data engineer create?

A.Spark SQL Table

B.View

C.Database

D.Temporary view

E.Delta Table

Question 39

A data engineer that is new to using Python needs to create a Python function to add two integers together and return the sum?
Which of the following code blocks can the data engineer use to complete this task?

A.

B.

C.

D.

E.

Question 40

A data engineer needs to apply custom logic to string column city in table stores for a specific use case. In order to apply this custom logic at scale, the data engineer wants to create a SQL user-defined function (UDF).
Which of the following code blocks creates this SQL UDF?

A.

B.

C.

D.

E.

Question 36

Question 37

Question 38

Question 39

Question 40

Download PDF File