
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?
A
Hash distribute the large fact tables in DW1 before performing the automated data loads.
B
Assign a smaller resource class to the automated data load queries.
C
Assign a larger resource class to the automated data load queries.
D
Create sampled statistics for every column in each table of DW1.