Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/configure-max-degree-of-parallelism Basic Concept: This question tests plan and implement data platform resources in the DP-300 exam context.
The correct choice is determined by the exact service boundary and operational requirement stated in the scenario.
Why D is Correct: Modify of db1. is an Azure data-platform feature, but it must match the workload model, service tier, migration path, or deployment constraint described in the scenario. This fits the case because the requested outcome is: You need to modify the MAXDOP settings for db1. The selected feature addresses that outcome directly rather than relying on a workaround.
Why A is Wrong: Connect to db1 and run the sp_configure command. is an Azure data-platform feature, but it must match the workload model, service tier, migration path, or deployment constraint described in the scenario. It would solve a neighboring problem, but not the deployment, sizing, or migration requirement in this item.
Why B is Wrong: Connect to the master database of server1 and run the sp_configure command. is an Azure data-platform feature, but it must match the workload model, service tier, migration path, or deployment constraint described in the scenario. It mismatches the target platform, migration method, compute tier, or deployment model described in the scenario, so it would not satisfy the workload as stated.
Why C is Wrong: Configure the extended properties of db1. is an Azure data-platform feature, but it must match the workload model, service tier, migration path, or deployment constraint described in the scenario. It applies to a different Azure data-platform design than the one the question is testing.