Question 1mediummultiple choice
Full question →mediummultiple choiceObjective-mapped
A workload in a VNet must connect to Azure SQL Database over a private IP address, and the database must not be reachable through its public endpoint. Users should still connect by using the normal server name. What should you configure?
Answer choices
Why each option matters
Good practice is not just finding the correct option. The wrong answers often show the exact trap the exam wants you to fall into.
A
Distractor review
A service endpoint on the subnet and a public firewall rule on the SQL server.
Service endpoints keep traffic on the Microsoft backbone, but they do not give the service a private IP in your VNet. A public firewall rule also conflicts with the requirement to avoid the public endpoint.
B
Best answer
A private endpoint for Azure SQL Database and a private DNS zone linked to the VNet.
A private endpoint assigns a private IP from the VNet to the Azure SQL resource, which keeps traffic off the public endpoint. Linking the appropriate private DNS zone to the VNet ensures the normal server name resolves to the private IP. This gives private connectivity and keeps application configuration simple.
C
Distractor review
A network security group rule that denies all public internet traffic to the subnet.
An NSG cannot convert a public endpoint into a private one. It may block some traffic, but it does not provide private IP-based connectivity or DNS resolution.
D
Distractor review
A NAT gateway on the subnet so the SQL connection uses a private source address.
A NAT gateway affects outbound source translation. It does not create private access to Azure SQL Database or replace the public endpoint with a VNet address.
Common exam trap
Common exam trap: usable hosts are not the same as total addresses
Subnetting questions often tempt you into counting all addresses. In normal IPv4 subnets, the network and broadcast addresses are not usable host addresses.
Technical deep dive
How to think about this question
Subnetting questions test whether you can identify the network, broadcast address, usable range, mask and correct subnet. Slow down enough to calculate the block size correctly.
KKey Concepts to Remember
- CIDR notation defines the prefix length.
- Block size helps identify subnet boundaries.
- Network and broadcast addresses are not usable hosts in normal IPv4 subnets.
- The required host count determines the smallest suitable subnet.
TExam Day Tips
- Write the block size before choosing the subnet.
- Check whether the question asks for hosts, subnets or a specific address range.
- Do not confuse /24, /25, /26 and /27 host counts.
Related practice questions
Related AZ-104 practice-question pages
Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.
AZ-104 Azure RBAC practice questions
Practise AZ-104 questions linked to AZ-104 Azure RBAC.
AZ-104 storage account practice questions
Practise AZ-104 questions linked to AZ-104 storage account.
AZ-104 virtual network practice questions
Practise AZ-104 questions linked to AZ-104 virtual network.
AZ-104 NSG practice questions
Practise AZ-104 questions linked to AZ-104 NSG.
AZ-104 Azure Monitor practice questions
Practise AZ-104 questions linked to AZ-104 Azure Monitor.
AZ-104 backup practice questions
Practise AZ-104 questions linked to AZ-104 backup.
AZ-104 managed identity practice questions
Practise AZ-104 questions linked to AZ-104 managed identity.
AZ-104 load balancer practice questions
Practise AZ-104 questions linked to AZ-104 load balancer.
AZ-104 Azure Policy practice questions
Practise AZ-104 questions linked to AZ-104 Azure Policy.
AZ-104 virtual machine practice questions
Practise AZ-104 questions linked to AZ-104 virtual machine.
More questions from this exam
Keep practising from the same exam bank, or move into a focused topic page if this question exposed a weak area.
Question 1
A route table contains these entries: 10.0.0.0/8 with next hop Virtual appliance, and 10.1.1.0/24 with next hop Virtual network gateway. Which next hop will Azure use for traffic to 10.1.1.5?
Question 2
You are deploying a stateless web application on Azure virtual machines. The solution must automatically add and remove instances based on CPU demand and allow all instances to be managed as one logical group. Which Azure compute feature should you deploy?
Question 3
You are deploying a Windows Server VM for an internal app. The VM must support Secure Boot and vTPM later, its OS disk must survive host moves, and the team wants the lowest-cost managed disk tier that still behaves like a normal writable OS disk. Which two choices should you make? Select two.
Question 4
You need to deploy several identical virtual machines and ensure that the failure of a single Azure host does not affect all of them. Which feature should you use?
Question 5
You need to connect VNet-Hub and VNet-Spoke so that resources in both virtual networks can communicate privately over the Microsoft backbone. Both virtual networks are in the same region. What should you configure?
Question 6
You need to create a storage account that provides the lowest-cost redundant storage for non-critical data and only needs protection against local disk or server failure within a single datacenter. Which redundancy option should you choose?
FAQ
Questions learners often ask
What does this AZ-104 question test?
CIDR notation defines the prefix length.
What is the correct answer to this question?
The correct answer is: A private endpoint for Azure SQL Database and a private DNS zone linked to the VNet. — If the requirement is true private IP connectivity to a PaaS service, the correct design is a private endpoint. That places a private IP in the VNet for the Azure SQL resource. Pairing it with a private DNS zone linked to the VNet lets the application keep using the normal server name while resolving it to the private address. This is the standard Azure pattern for private access to PaaS services. Why others are wrong: Service endpoints do not provide a private IP, so they do not meet the requirement. NSGs can restrict traffic but cannot replace the public endpoint with a private one. NAT gateway only changes outbound internet source addresses and has nothing to do with private service connectivity or DNS resolution.
What should I do if I get this AZ-104 question wrong?
Then try more questions from the same exam bank and focus on understanding why the wrong options are tempting.
Discussion
Loading comments…
Sign in to join the discussion.