Question 1hardmultiple choice
Full question →hardmultiple choiceObjective-mapped
A finance web app in AppSubnet must connect to Azure SQL Database over the service's public endpoint. Only AppSubnet should be allowed, and the security team does not want to deploy any private IPs or change DNS. 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 private endpoint for the SQL server and a private DNS zone linked to AppSubnet.
Private endpoints place the SQL service behind a private IP in your virtual network and typically require DNS updates so the app resolves the name to the private address. That directly conflicts with the requirement to avoid private IPs and DNS changes.
B
Best answer
Enable the Microsoft.Sql service endpoint on AppSubnet and add a virtual network rule on the SQL server.
A service endpoint keeps Azure SQL reachable through its public endpoint while allowing access only from the authorized subnet. The subnet must have the Microsoft.Sql service endpoint enabled, and the SQL server must have a virtual network rule that permits AppSubnet. This satisfies the requirement to avoid private IPs and DNS changes while still restricting access to the subnet.
C
Distractor review
Create an NSG rule on AppSubnet to allow outbound TCP 1433 traffic to the SQL server's public IP address.
An NSG can filter traffic at the subnet or NIC level, but Azure SQL authorization is not granted by an NSG alone. Azure SQL requires either firewall rules or a virtual network rule tied to a service endpoint for subnet-based access control.
D
Distractor review
Publish the AppSubnet public IP address range in the SQL server firewall as an allow list.
A subnet's private address range is not a valid public IP allow list, and this approach does not provide subnet-based authorization. The correct control for this scenario is a service endpoint plus a virtual network rule.
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: Enable the Microsoft.Sql service endpoint on AppSubnet and add a virtual network rule on the SQL server. — When the requirement is to keep using the public endpoint and avoid private IPs or DNS changes, service endpoints are the right fit. They extend the subnet's identity to Azure SQL, and the SQL server must also have a virtual network rule for that subnet. This provides access control without changing hostname resolution or deploying a private endpoint. Why others are wrong: A private endpoint violates the explicit no-private-IP requirement and usually requires DNS changes. An NSG rule alone cannot authorize Azure SQL access because SQL server access is enforced by SQL networking rules, not by the NSG. Allowing a subnet range directly in the SQL firewall is not the correct subnet-based control for this scenario; a service endpoint with a virtual network rule is required.
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.