DP-300 Practice Question: Monitor, configure, and optimize database resources
Exhibit
Refer to the exhibit.
```json
{
"properties": {
"networkAcls": {
"defaultAction": "Deny",
"virtualNetworkRules": [
{
"id": "/subscriptions/.../virtualNetworks/vnet1/subnets/subnet1",
"ignoreMissingVnetServiceEndpoint": false
}
],
"ipRules": []
}
}
}
```You are configuring a private endpoint for an Azure SQL Database. The exhibit shows the current network ACLs. You need to ensure that only traffic from a specific subnet in VNet1 is allowed, and all other traffic is denied. What should you do?
⚠ Common exam trap
Many candidates think they need to add an IP rule for the subnet's IP range (Option B) or change the default action to allow (Option D), not realizing that private endpoints use virtual network rules that already implicitly allow traffic from the subnet, and the default deny action is correct for restricting all other traffic.
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
✓
No changes needed; the configuration already meets the requirement.
The exhibit shows that the private endpoint is configured with a network ACL that has a deny-all default action and an explicit allow rule for the specific subnet in VNet1. Since private endpoints use network policies (like NSG rules) to filter traffic, and the ACL already denies all traffic except the allowed subnet, no changes are needed. The configuration meets the requirement because the private endpoint's network ACLs are evaluated in order, and the explicit allow for the subnet overrides the default deny for all other traffic.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
No changes needed; the configuration already meets the requirement.
Why this is correct
Default deny with a VNet rule for the subnet allows only that subnet.
- ✗
Add an IP rule to allow the subnet's IP range.
Why it's wrong here
Would allow that IP range, but the VNet rule already handles it; adding IP rule could allow other IPs.
- ✗
Set ignoreMissingVnetServiceEndpoint to true.
Why it's wrong here
Could allow traffic if the endpoint is missing, which is not secure.
- ✗
Change defaultAction to Allow.
Why it's wrong here
Would allow all traffic, contradicting the requirement.
Visual reference
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.