exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 4 question 67 discussion

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

You need to design a highly available Azure SQL database that meets the following requirements:

• Failover between replicas of the database must occur without any data loss.
• The database must remain available in the event of a zone outage.
• Costs must be minimized.

Which deployment option should you use?

  • A. Azure SQL Database Hyperscale
  • B. Azure SQL Database Premium
  • C. Azure SQL Database Basic
  • D. Azure SQL Database Standard
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

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
mVic
Highly Voted 1 year, 11 months ago
Selected Answer: B
Premium should be the answer. Whenever zone-redundancy (availability within the same region) is required you can only choose: -General Purpose -Premium -Business Critical See: https://learn.microsoft.com/en-GB/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell
upvoted 19 times
...
ServerBrain
Highly Voted 1 year, 11 months ago
Actually About 23 questions added today..
upvoted 6 times
[Removed]
1 year, 11 months ago
Some look like they are duplicates
upvoted 4 times
...
...
SeMo0o0o0o
Most Recent 3 weeks ago
Selected Answer: B
B is correct 1. Azure SQL Database Premium 2. Azure SQL Database Serverless 3. Azure SQL Database Business Critical
upvoted 1 times
...
steel72
1 year, 8 months ago
Selected Answer: B
Correct answer is "Azure SQL Database Premium". Basic and Standard do not support zone-redundancy: https://learn.microsoft.com/en-GB/azure/azure-sql/database/high-availability-sla
upvoted 3 times
...
zellck
1 year, 9 months ago
Same as Question 16. https://www.examtopics.com/discussions/microsoft/view/79423-exam-az-305-topic-2-question-16-discussion
upvoted 1 times
...
zellck
1 year, 9 months ago
Selected Answer: B
B is the answer. https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview?view=azuresql#service-tiers The Premium service tier is designed for OLTP applications with high transaction rates and low latency I/O requirements. It offers the highest resilience to failures by using several isolated replicas.
upvoted 1 times
...
VBK8579
1 year, 10 months ago
Selected Answer: B
B. Azure SQL Database Premium
upvoted 1 times
...
OPT_001122
1 year, 10 months ago
Selected Answer: B
B. Azure SQL Database Premium
upvoted 1 times
...
janvandermerwer
1 year, 10 months ago
Selected Answer: B
Premium for failover without data loss.
upvoted 1 times
...
yeanlingmedal71
1 year, 10 months ago
Selected Answer: B
Azure SQL Database Premium tier supports multiple redundant replicas for each database that are automatically provisioned in the same datacenter within a region. This design leverages the SQL Server AlwaysON technology and provides resilience to server failures with 99.99% availability SLA and RPO=0. With the introduction of Azure Availability Zones, we are happy to announce that SQL Database now offers built-in support of Availability Zones in its Premium service tier. https://azure.microsoft.com/en-us/blog/azure-sql-database-now-offers-zone-redundant-premium-databases-and-elastic-pools/ Zone-redundant configuration is not available in SQL Managed Instance. In SQL Database this feature is only available when the Gen5 hardware is selected. https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell
upvoted 3 times
...
uacanillo
1 year, 10 months ago
The deployment option that should be used to meet the requirements of a highly available Azure SQL database with minimal data loss and minimal cost is option D, Azure SQL Database Standard. This option provides active-passive failover capabilities and also allows for read-access to secondary replicas, which can help minimize costs. Additionally, it also provides zone-redundant databases, so in case of zone outage, the database will remain available
upvoted 1 times
diego84
1 year, 10 months ago
check this Basic, Standard, and General Purpose service tier locally redundant availability. However, General Purpose service tier zone redundant availability https://learn.microsoft.com/en-GB/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell
upvoted 1 times
...
...
mscbgslt
1 year, 11 months ago
Selected Answer: D
Azure SQL database standard as we have to minimize costs: https://azure.microsoft.com/en-us/blog/azure-sql-database-standard-geo-replication/
upvoted 4 times
...
maku067
1 year, 11 months ago
Selected Answer: B
seems correct.
upvoted 1 times
...
ServerBrain
1 year, 11 months ago
This question was added today 05Jan2023. Serves as update confirmation ..
upvoted 2 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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago