exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 4 question 54 discussion

Actual exam question from Microsoft's AZ-305
Question #: 54
Topic #: 4
[All AZ-305 Questions]

You have an on-premises line-of-business (LOB) application that uses a Microsoft SQL Server instance as the backend.
You plan to migrate the on-premises SQL Server instance to Azure virtual machines.
You need to recommend a highly available SQL Server deployment that meets the following requirements:
✑ Minimizes costs
Minimizes failover time if a single server fails

What should you include in the recommendation?

  • A. an Always On availability group that has premium storage disks and a virtual network name (VNN)
  • B. an Always On Failover Cluster Instance that has a virtual network name (VNN) and a standard file share
  • C. an Always On availability group that has premium storage disks and a distributed network name (DNN)
  • D. an Always On Failover Cluster Instance that has a virtual network name (VNN) and a premium file share
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
GarryK
Highly Voted 2 years, 2 months ago
Selected Answer: B
I prefer B. Costs must be minimized. Failover must be provided if a single server fails. > No information is given that would recommend to use premium storage. > We need protection if a server fails, Failover Cluster provides availability at the instance level whereas Availability Groups provides failover at the Database Level. About AG. Because availability groups only provide database-level, and not instance-level, protection, anything not captured in the transaction log or configured in the database will need to be manually synchronized for each secondary replica. Some examples of objects that must be synchronized manually are logins at the instance level, linked servers, and SQL Server Agent jobs. About FC Databases are only available after recovery is complete, so recovery time will depend on many factors, and will generally be longer than failing over an availability group. The tradeoff is that when you fail over an availability group, there may be additional tasks required to make a database usable, such as enabling a SQL Server Agent job.
upvoted 16 times
jellybiscuit
2 years, 2 months ago
Yea, it depends on if you start with cost, or you start with time. I think I'd personally go with C, but I see your point.
upvoted 2 times
GarryK
1 year, 10 months ago
And I dont understand C as DNN is used with failover clusters, not AG. The distributed network name (DNN) replaces the virtual network name (VNN) as the connection point when used with an Always On failover cluster instance on SQL Server VMs. https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/failover-cluster-instance-distributed-network-name-dnn-configure?view=azuresql
upvoted 3 times
zellck
1 year, 9 months ago
You can use DNN with AG. https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group-distributed-network-name-dnn-listener-configure?view=azuresql With SQL Server on Azure VMs in a single subnet, the distributed network name (DNN) routes traffic to the appropriate clustered resource. It provides an easier way to connect to an Always On availability group (AG) than the virtual network name (VNN) listener, without the need for an Azure Load Balancer.
upvoted 2 times
...
...
...
a03
1 year ago
"While Azure shared disks also support Standard SSD sizes, we do not recommend using Standard SSDs for SQL Server workloads due to the performance limitations." https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/failover-cluster-instance-overview?view=azuresql So. correct answer D (FCI with Premium file share) if we are talking about instance level. Or C (AG with DNN) if we are talking about database level.
upvoted 1 times
...
...
dubuser
Highly Voted 1 year, 10 months ago
This question appeared in todays exam (29/01/23) Answered C Scored 903
upvoted 9 times
...
SeMo0o0o0o
Most Recent 3 weeks, 1 day ago
Selected Answer: C
C is correct
upvoted 1 times
...
23169fd
5 months, 2 weeks ago
Selected Answer: C
Always On Availability Groups provide better scalability and flexibility in a cloud environment. DNN (Distributed Network Name) allows for improved networking flexibility, which is beneficial in Azure. Although premium storage disks increase costs, they provide the necessary performance to ensure fast failover times, which can be crucial for maintaining high availability. Thus, option C strikes a good balance between high availability, performance, and cost management in an Azure environment.
upvoted 3 times
...
Lazylinux
7 months, 2 weeks ago
Selected Answer: C
Based on this article i would choose C https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group-distributed-network-name-dnn-listener-configure?view=azuresql
upvoted 2 times
...
PMPft17
1 year ago
The distributed network name (DNN) replaces the virtual network name (VNN) as the connection point when used with an Always On failover cluster instance on SQL Server VMs. This negates the need for an Azure Load Balancer routing traffic to the VNN, simplifying deployment, maintenance, and improving failover.
upvoted 2 times
...
quaternion
1 year, 4 months ago
Selected Answer: B
Failover Cluster provides availability at the instance level Minimize Cost --> Standard storage
upvoted 1 times
...
NotMeAnyWay
1 year, 4 months ago
Selected Answer: C
C. an Always On availability group that has premium storage disks and a distributed network name (DNN). The Always On Availability Group with a Distributed Network Name (DNN) would be the better choice due to the faster failover time, which aligns with the requirement of minimizing failover time if a single server fails. The DNN listener in this case doesn't require an Azure Load Balancer to reroute traffic, resulting in quicker failovers compared to the VNN listener. This is a great choice when high availability and minimal failover time are prioritized.
upvoted 6 times
...
techrat
1 year, 7 months ago
Selected Answer: C
Passed exam today with 979, and this question was on the exam, I am confident the correct answer is C.
upvoted 9 times
...
zellck
1 year, 9 months ago
Selected Answer: C
C is the answer. https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group-distributed-network-name-dnn-listener-configure?view=azuresql With SQL Server on Azure VMs in a single subnet, the distributed network name (DNN) routes traffic to the appropriate clustered resource. It provides an easier way to connect to an Always On availability group (AG) than the virtual network name (VNN) listener, without the need for an Azure Load Balancer.
upvoted 8 times
...
OPT_001122
1 year, 10 months ago
Selected Answer: C
C. an Always On availability group that has premium storage disks and a distributed network name (DNN)
upvoted 3 times
...
diego_alejandro
2 years ago
answer is C
upvoted 2 times
...
Snownoodles
2 years, 1 month ago
Selected Answer: C
DNN is recommended by MS
upvoted 6 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...