You have an Azure data solution that contains an enterprise data warehouse in Azure Synapse Analytics named DW1. Several users execute adhoc queries to DW1 concurrently. You regularly perform…

Question

Options

• AAssign a smaller resource class to the automated data load queries.
• BCreate sampled statistics to every column in each table of DW1.
• CAssign a larger resource class to the automated data load queries.
• DHash distribute the large fact tables in DW1 before performing the automated data loads.

• A
  15% (5)
• B
  3% (1)
• C
  76% (25)
• D
  6% (2)

Explanation

The performance capacity of a query is determined by the user's resource class. Smaller resource classes reduce the maximum memory per query, but increase concurrency. Larger resource classes increase the maximum memory per query, but reduce concurrency. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/resource-classes- for-workload-management

No community discussion yet for this question.