Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-300 Exam - Topic 1 Question 135 Discussion

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 automated data loads to DW1.You need to ensure that the automated data loads have enough memory available to complete quickly andsuccessfully when the adhoc queries run.What should you do?
C) Assign a larger resource class to the automated data load queries.
A) Assign a smaller resource class to the automated data load queries.
B) Create sampled statistics to every column in each table of DW1.
D) Hash distribute the large fact tables in DW1 before performing the automated data loads.

Microsoft DP-300 Exam - Topic 1 Question 135 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 135
Topic #: 1
[All DP-300 Questions]

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 automated data loads to DW1.

You need to ensure that the automated data loads have enough memory available to complete quickly and

successfully when the adhoc queries run.

What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: C

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-workloadmanagement

by Dwight at Sep 29, 2026, 05:39 PM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel

Currently there are no comments in this discussion, be the first to comment!


Save Cancel