DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ54

Monitor, configure, and optimize database resources

You have an Azure data solution containing an enterprise data warehouse in Azure Synapse Analytics named DW1.

Several users run ad hoc queries against DW1 concurrently.

You regularly run automated data loads into DW1.

You need to ensure the automated data loads have sufficient memory to complete quickly and successfully while the ad hoc queries are running.

What should you do?

Explanation

In an Azure Synapse Analytics dedicated SQL pool, a query’s resource class governs its memory allocation and concurrency. A larger resource class grants more memory per query, which benefits memory-intensive data loads and enables them to complete more quickly and reliably; the trade-off is reduced available concurrency for other queries.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!