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

Question

Options

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

• A
  4% (1)
• B
  4% (1)
• C
  82% (23)
• D
  11% (3)

Explanation

The performance capacity of a query is determined by the user's resource class. Resource classes are pre-determined resource limits in Synapse SQL pool that govern compute resources and concurrency for query execution. Resource classes can help you configure resources for your queries by setting limits on the number of queries that run concurrently and on the compute-resources assigned to each query. There's a trade-off between memory and concurrency. 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.