You have an Azure SQL database named db1 on a server named server1. You need to modify the MAXDOP settings for db1. What should you do?

The correct answer is D. Modify the database scoped configuration of db1. If you determine that a MAXDOP setting different from the default is optimal for your Azure SQL Database workload, you can use the ALTER DATABASE SCOPED CONFIGURATION T-SQL https://docs.microsoft.com/en-us/azure/azure-sql/database/configure-max-degree-of-parallelism

Submitted by eva_at· Mar 6, 2026Monitor, configure, and optimize database resources

Question

You have an Azure SQL database named db1 on a server named server1. You need to modify the MAXDOP settings for db1. What should you do?

Options

AConnect to db1 and run the sp_configure command.
BConnect to the master database of server1 and run the sp_configure command.
CConfigure the extended properties of db1.
DModify the database scoped configuration of db1.

How the community answered

(47 responses)

B
2% (1)
C
4% (2)
D
94% (44)

Explanation

If you determine that a MAXDOP setting different from the default is optimal for your Azure SQL Database workload, you can use the ALTER DATABASE SCOPED CONFIGURATION T-SQL https://docs.microsoft.com/en-us/azure/azure-sql/database/configure-max-degree-of-parallelism

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice