What should you do?

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?
A . Connect to db1 and run the sp_configure command.
B . Connect to the master database of server1 and run the sp_configure command.
C . Configure the extended properties of db1.
D . Modify the database scoped configuration of db1.

View Answer

Answer: D

Explanation:

Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/configure-max-degree-of-parallelism