AZ-802 Practice Question: Implement and Manage On-Prem and Hybrid Networking
You need to provide a secure method for on-premises administrators to manage Azure SQL databases without exposing the database to the public internet. You want to ensure that traffic from the on-premises network stays within the private network space. Which solution should you implement?
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
✓
Azure Private Link with a Private Endpoint
Azure Private Link allows you to access Azure PaaS services over a private endpoint in your virtual network. When combined with a VPN or ExpressRoute, this extends the private connectivity to your on-premises environment. This setup ensures that traffic never traverses the public internet, satisfying strict security and compliance requirements.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Azure Service Endpoints
Why it's wrong here
Service Endpoints provide secure connectivity to Azure services but they do not extend to on-premises networks directly. They essentially route VNet traffic over the Azure backbone, but on-premises clients would still need to use the public IP of the service, which may be blocked by corporate firewalls.
- ✓
Azure Private Link with a Private Endpoint
Why this is correct
Private Link maps a private IP address from your VNet to the Azure SQL instance. By using a VPN or ExpressRoute, on-premises administrators can reach this private IP address directly. This configuration keeps all management traffic off the public internet and within the organization's private address space.
- ✗
Azure Bastion
Why it's wrong here
Azure Bastion is a service that provides secure RDP and SSH access to virtual machines within a VNet via the Azure portal. It is not designed for direct database connectivity or for providing private access to PaaS services like Azure SQL for administrative tools running on-premises.
- ✗
Azure Front Door
Why it's wrong here
Azure Front Door is a global, scalable entry point that uses the Microsoft global edge network to create fast, secure, and widely available web applications. It is a Layer 7 service intended for public web traffic and does not provide private, internal-only connectivity for database management.
About these practice questions
This AZ-802 question is part of Courseiva's 116-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 and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Microsoft exam blueprint
This AZ-802 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 AZ-802 exam.