In Azure SQL Database, you can change the default MAXDOP value:
At the query level, using the MAXDOP query hint.
At the database level, using the MAXDOP database scoped configuration.
https://docs.microsoft.com/en-us/azure/azure-sql/database/configure-max-degree-of-parallelism?view=azuresql
Answer A : Connect to db1 and run sp_configure
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-degree-of-parallelism-server-configuration-option?view=sql-server-ver15
The answer is D. The answer b it nos posible because sp_configure is a server level, no database level.
the syntax for database level it the next
-- Syntax for SQL Server, Azure SQL Database and Azure SQL Managed Instance
ALTER DATABASE SCOPED CONFIGURATION
{
{ [ FOR SECONDARY] SET <set_options>}
}
| CLEAR PROCEDURE_CACHE [plan_handle]
| SET < set_options >
[;]
< set_options > ::=
{
MAXDOP = { <value> | PRIMARY}
| LEGACY_CARDINALITY_ESTIMATION = { ON | OFF | PRIMARY}
upvoted 3 times
...
...
...
This section is not available anymore. Please use the main Exam Page.DP-300 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
joelabc1234
Highly Voted 1 year agoeric0718
Most Recent 6 months, 3 weeks agomhmodsaid
6 months, 3 weeks agoazure2022
1 year, 2 months agoovokpus
1 year, 2 months agoquermi
1 year ago