The answer is configuring a Private Endpoint and a Virtual Network service endpoint. A Private Endpoint assigns a private IP address from your VNet to Azure SQL Database, isolating traffic entirely within the Microsoft backbone and eliminating public internet exposure, while a VNet service endpoint extends your VNet’s identity and private address space to the database over a direct connection, allowing you to restrict access to a specific subnet. On the DP-300 exam, this question tests your understanding of network security boundaries for Azure SQL—a common trap is confusing service endpoints with Private Link, but remember that service endpoints still use the public endpoint of the database (just filtered by VNet rules), whereas Private Endpoint fully removes public access. A useful memory tip: “Private Endpoint pulls the database into your VNet; service endpoint pushes your VNet to the database.”
DP-300 Plan and implement data platform resources Practice Question
This DP-300 practice question tests your understanding of plan and implement data platform resources. Match the stated requirement to the specific cloud service, access model, or configuration option — many options are valid in isolation but not for this scenario. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
Which TWO are valid ways to secure access to an Azure SQL Database?
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Configure a Virtual Network service endpoint
Option B is correct because a Virtual Network service endpoint extends your virtual network private address space and the identity of your VNet to Azure SQL Database over a direct connection. This allows you to secure access by limiting connectivity to only traffic originating from a specific subnet in your VNet, effectively blocking public internet access while using the Azure backbone network.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
✗
Use IPsec VPN from on-premises
Why it's wrong here
Azure SQL Database does not support IPsec directly.
✓
Configure a Virtual Network service endpoint
Why this is correct
Restricts traffic to a specific VNet.
Related concept
Read the scenario before looking for a memorised answer.
✓
Configure a Private Endpoint
Why this is correct
Provides private connectivity from a VNet.
Related concept
Read the scenario before looking for a memorised answer.
✗
Join the database to an on-premises Active Directory domain
Why it's wrong here
Not supported.
✗
Disable all firewall rules and rely only on authentication
Why it's wrong here
Firewall rules are necessary to block unauthorized IP addresses.
Common exam traps
Common exam trap: answer the scenario, not the keyword
The trap here is that candidates often confuse 'securing access' with 'authentication methods' and incorrectly assume that disabling firewall rules and relying solely on authentication (Option E) is valid, or they think an on-premises AD domain join (Option D) applies to Azure SQL Database, when in fact Azure SQL only supports Azure AD authentication and network-level controls like service endpoints or private endpoints are required for secure access.
Detailed technical explanation
How to think about this question
A Private Endpoint (Option C) uses Azure Private Link to assign a private IP address from your VNet to Azure SQL Database, making it accessible over a private network interface without traversing the public internet. Service endpoints (Option B) work by adding a route to the service's public IP prefixes, but traffic still uses the public endpoint of the database; however, the source IP seen by the database is the private IP from the VNet, allowing firewall rules to restrict access to that subnet. In contrast, Private Endpoint completely removes public endpoint exposure, which is critical for compliance scenarios requiring data exfiltration protection.
KKey Concepts to Remember
Read the scenario before looking for a memorised answer.
Find the constraint that changes the correct option.
Eliminate answers that are true in general but not in this case.
TExam Day Tips
→Watch for words such as best, first, most likely and least administrative effort.
→Review why wrong options are wrong, not only why the correct option is correct.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
How this comes up in practice
A company's IT admin needs to give a contractor read-only access to production logs without sharing account credentials. Using role-based access control (RBAC) and temporary scoped permissions — not a permanent shared password — is the correct pattern. Questions like this test whether you can apply least-privilege access across cloud identity services.
Related glossary terms
Concepts from this question explained
These glossary pages explain the core terms tested in this DP-300 question in full detail.
Plan and implement data platform resources — This question tests Plan and implement data platform resources — Read the scenario before looking for a memorised answer..
What is the correct answer to this question?
The correct answer is: Configure a Virtual Network service endpoint — Option B is correct because a Virtual Network service endpoint extends your virtual network private address space and the identity of your VNet to Azure SQL Database over a direct connection. This allows you to secure access by limiting connectivity to only traffic originating from a specific subnet in your VNet, effectively blocking public internet access while using the Azure backbone network.
What should I do if I get this DP-300 question wrong?
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
What is the key concept behind this question?
Read the scenario before looking for a memorised answer.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
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.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.