data-engineer-associate video for the data analysis team is experiencing slow performance with their Databricks SQL queries when using an always-on SQL
The data analysis team is experiencing slow performance with their Databricks SQL queries when using an always-on SQL endpoint. This issue arises when multiple team members run small queries simultaneously. After reviewing the system, the data engineering team identifies that all queries are being processed through the same SQL endpoint. Which of the following actions would most effectively improve query performance under these conditions?