
Ultimate access to all questions.
You have an Azure data solution with an enterprise data warehouse named DW1 in Azure Synapse Analytics. Multiple users run concurrent ad hoc queries on DW1. You also perform regular automated data loads to DW1. You need to guarantee that the automated data loads have sufficient memory resources to complete quickly and successfully while the ad hoc queries are executing. What should you do?