Drag or tap steps into the slots.
AZ-305 Design infrastructure solutions Practice Question
Drag and drop the steps to set up Azure Private Link for an Azure SQL Database into the correct order.
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
Create endpoint, then approve, then configure DNS, then test, then disable public access
The correct sequence for setting up Azure Private Link for an Azure SQL Database is: first create the private endpoint in the virtual network, then approve the private link connection from the Azure SQL Database side, next configure DNS (typically using a private DNS zone) to resolve the database's FQDN to the private endpoint IP, test connectivity from within the virtual network, and finally disable public access to the database to enforce private connectivity. This order ensures each step builds on the previous one, avoiding connectivity issues or premature security restrictions.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Create endpoint, then approve, then configure DNS, then test, then disable public access
Why this is correct
This is the correct order because the endpoint must be created before it can be approved, DNS must be configured after approval to ensure proper name resolution, testing validates connectivity before disabling public access, and public access is disabled last to secure the database.
- ✗
Create endpoint, then approve, then test, then configure DNS, then disable public access
Why it's wrong here
Placing the test step before DNS configuration is invalid because a connectivity test resolves the Azure resource's fully qualified domain name (FQDN) through normal DNS, which at that point still points to the public IP address rather than the private endpoint IP. Even if the test succeeds, it would be exercising the public endpoint or falling back to it, so it does not validate the private link path. DNS must be configured after approval to map the FQDN to the private IP; only then can the test meaningfully confirm that traffic is traversing the private endpoint.
- ✗
Approve, then create endpoint, then configure DNS, then test, then disable public access
Why it's wrong here
Approval cannot happen before the private endpoint exists because the approval workflow acts on a pending private endpoint connection request that the target resource receives. When a private endpoint is created, it triggers a connection request in a 'Pending' state; only then can the target resource owner review and approve that specific request. Attempting to approve first would leave no connection request to act upon, and Azure would return an error or the operation would be a no-op, so the correct first step is always creating the endpoint.
- ✗
Create endpoint, then configure DNS, then approve, then test, then disable public access
Why it's wrong here
Configuring DNS before approval is incorrect because the private IP address that should be inserted into the private DNS zone is only truly usable after the connection is approved and the endpoint provisioning completes. Until approval, the private endpoint connection remains in a pending state, so any DNS record you create would either point to an address that is not ready or be overwritten when the system later provisions the endpoint. The proper workflow approves the endpoint first, establishing the active connection, and then configures DNS to map the FQDN to that approved private IP, ensuring name resolution matches the actual network path.
Visual reference
Go deeper
Related to this question
About these practice questions
Courseiva writes every AZ-305 question from scratch — 795 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This AZ-305 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-305 exam.