DP-300 Practice Question: Monitor, configure, and optimize database resources
Exhibit
Refer to the exhibit.
```json
{
"properties": {
"state": "Disabled",
"emailAccountAdmins": true,
"emailAddresses": ["dba@contoso.com"],
"disabledAlerts": ["SqlInjection", "SqlInjectionVulnerability"],
"retentionDays": 30
}
}
```You are reviewing an Azure SQL Database server's vulnerability assessment settings. The exhibit shows the current configuration. A recent security audit requires that vulnerability assessment scans be enabled and that results be retained for at least 90 days. What should you do?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Change state to Enabled and set retentionDays to 90.
The vulnerability assessment must be enabled (state: Enabled) and retentionDays must be set to at least 90 to meet the audit requirement. The exhibit shows state as Disabled and retentionDays as 30. Option A is wrong because adding email addresses only affects notifications, not the scan state or retention. Option B is wrong because retentionDays of 90 with state Disabled means scans are not running. Option D is wrong because disabledAlerts control which alerts are suppressed; removing them does not enable the scan or change retention.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Add additional email addresses to ensure notification.
Why it's wrong here
Does not enable scanning or increase retention.
- ✗
Change retentionDays to 90 and keep the state as Disabled.
Why it's wrong here
The scan must be enabled (state: Enabled).
- ✓
Change state to Enabled and set retentionDays to 90.
Why this is correct
Enables the scan and meets the retention requirement.
- ✗
Remove the disabledAlerts entries to enable all alerts.
Why it's wrong here
This only enables alerts, not the scan itself.
Go deeper
Related to this question
Learn chapter
Overview of Azure Data Platform Options
Key term
Azure SQL Performance Tuning
Azure SQL Performance Tuning is the process of optimizing the speed and efficiency of queries and database operations in Microsoft Azure SQL Database or SQL Managed Instance to reduce latency and improve throughput.
About these practice questions
One of 906 original DP-300 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-300 exam.