Exam AZ-305 topic 12 question 1 discussion

> Database: "An Azure SQL Database elastic pool" > Service Tier: "Business Critical" Reference & explanations: https://www.examtopics.com/discussions/microsoft/view/68044-exam-az-305-topic-9-question-1-discussion/

Today (14-DEC-2023) I took the AZ-305 exam and passed. Thanks to Examtopics and all members who participated in discussing AZ-305 Questionnaire and answers. This site has helped me greatly. Majority questions I had in the exam are in this set. I had Litware Test case in the exam. Thanks.

Database: b) Azure SQL Managed Instance Service tier: b) Business Critical

For me it's Azure SQL Managed Instance - both examples bellow are ZRS GP example:https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/high-availability-sla-local-zone-redundancy?view=azuresql#general-purpose-service-tier-1 BC example: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/high-availability-sla-local-zone-redundancy?view=azuresql#business-critical-service-tier-1

as per microsoft , " Zone-redundant configuration is in public preview for the General Purpose service tier and generally available for the Business Critical service tier." accordingly, the answer should be : 1. Azure SQL Managed Instance for the database 2. Business Critical service tier

What is different? https://www.examtopics.com/discussions/microsoft/view/68044-exam-az-305-topic-9-question-1-discussion/

Elastic and Business Critical for both questions... you should never use preview in prod, so you cannot choose managed instance!

1. Database: c. An Azure SQL Database elastic pool 2. Service tier: b. Business Critical Explanation: An Azure SQL Database Elastic Pool is a shared resource model that enables higher resource utilization efficiency. It allows multiple databases to share the same resources, which will be beneficial in this case where there are two databases, DB1 and DB2, to be migrated. Business Critical service tier provides high availability and low latency, and it is fully managed, which aligns with the business requirement to minimize administrative effort and the technical requirement to maintain availability if two availability zones fail. As you pointed out, the zone redundancy is still in preview for Managed Instances which can't guarantee the desired level of stability and reliability.

any thoughts on this please as zone redundancy is not supported for Azure SQL General Purpose. This would make it the most cost effective option above business critical. https://techcommunity.microsoft.com/t5/azure-sql-blog/zone-redundancy-for-azure-sql-database-general-purpose-tier/ba-p/3280376

1. Azure SQL Managed Instance for the database 2. Business Critical service tier Azure SQL Managed Instance provides automatic failover within an availability zone and can be configured with auto-failover groups for cross-region disaster recovery. The Business Critical service tier provides high availability with several readable secondary replicas and fast failover within an availability zone. This configuration meets Litware’s requirements for maintaining availability if two availability zones in the local Azure region fail, failing over automatically, and minimizing I/O latency. An Azure SQL Database Elastic Pool is a cost-effective solution for managing and scaling multiple databases that have varying and unpredictable resource demands. However, based on the information provided in the case study, it does not appear to be the best option for meeting Litware’s resiliency requirements for DB1 and DB2. Azure SQL Managed Instance would be a better choice for meeting these requirements.

The given answer is correct: 1. Azure SQL Database elastic pool 2. Business Critical I had this case study on my exam today, and I passed it with 979

1. Azure SQL DB elastic pool 2. Business Critical https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tiers-sql-database-vcore?view=azuresql#when-to-choose-this-service-tier-1 he Business Critical service tier is designed for applications that require low-latency responses from the underlying SSD storage (1-2 ms in average), faster recovery if the underlying infrastructure fails, or need to off-load reports, analytics, and read-only queries to the free of charge readable secondary replica of the primary database. The key reasons why you should choose Business Critical service tier instead of General Purpose tier are: - Low I/O latency requirements – workloads that need a consistently fast response from the storage layer (1-2 milliseconds in average) should use Business Critical tier.

Database: "An Azure SQL Database elastic pool" - Zone Redundancy still in Preview for Managed Instance so it's a nogo - You could have deployed two Azure Databases but here it is written "A SINGLE" so it's not working as you have two databases to migrate Service Tier: "Business Critical" - as you need to minimize I/O latency

Answer: Database: SQL Managed Instances Service Tier: Business Critical SQL Managed Instance now supports zone redundancy

Hello guys, I guess should be the following: > Database: "AZURE SQL MANAGED INSTANCE" - it can provide AUTO-FAILOVER > Service Tier: "Business Critical"

The scenario ask for availability zone and I wanted to opt for MI Business Critical but zone redundant feature is in preview. Single Azure SQL Database doesn't make sense because we got two databases. So the only option is actually elastic pool. So the answer is correct.

Single Azure SQL Database Business Critical A single azure sql db for each db would meet the requirements. You can't use an elastic pool unless you are aware of the load pattern of each db to make it worthwhile to use elastic db. There is no indication in the question to hint pool will be useful. also there is no indication in the answer that single azure db has to be for both dbs. It can a single db for each - db1 and db2. Therefore Multi DB in question doesn't rule out a single azure db as potential answer.