Ultimate access to all questions.
The data analysis team has observed that their Databricks SQL queries experience significant slowdowns when connected to their always-on SQL endpoint. This performance degradation becomes evident especially when numerous team members execute small queries simultaneously. Seeking assistance, they approach the data engineering team. Upon investigation, the data engineering team identifies that all of the team’s queries are utilizing the same SQL endpoint. What strategy can the data engineering team employ to reduce the query latency for the team?