DP-300 Implement a secure environment Practice Question
Your organization has an Azure SQL Database server. You need to ensure that only applications running on Azure virtual machines in a specific virtual network can connect to the database. Which THREE actions should you take?
⚠ Common exam trap
A common mix-up: candidates confuse enabling a service endpoint (Option A) with actually restricting access, forgetting that a virtual network rule is required to explicitly allow traffic from the specific subnet.
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
✓
Add a virtual network rule for the specific subnet of the VMs.
Adding a virtual network rule for the specific subnet of the VMs allows Azure SQL Database to accept traffic only from that subnet when a service endpoint is enabled. This restricts access to the database to only those applications running on Azure VMs within the specified virtual network, ensuring network-level isolation.
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 a service endpoint for Azure SQL Database to the virtual network.
Why it's wrong here
Incorrect: The service endpoint is necessary but the question asks for actions; the rule itself requires the endpoint to exist.
- ✓
Add a virtual network rule for the specific subnet of the VMs.
Why this is correct
Correct: This allows traffic from that subnet.
- ✓
Set the 'Allow Azure Services and resources to access this server' setting to OFF.
Why this is correct
Correct: This disables access from all Azure services unless explicitly allowed.
- ✓
Remove all existing firewall rules that allow public IP ranges.
Why this is correct
Correct: This restricts access to only the VNet.
- ✗
Set the 'Allow Azure Services and resources to access this server' setting to ON.
Why it's wrong here
Incorrect: This would allow all Azure services, not just those from your VNet.
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
This DP-300 question is part of Courseiva's 906-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. 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.