Exam AZ-305 topic 2 question 8 discussion

Answer is correct. -Azure SQL Database with Hyperscale(support up to 100TB). https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale#:~:text=A%20Hyperscale%20database%20is%20created%20with%20a%20starting,about%20Hyperscale%20pricing%2C%20see%20Azure%20SQL%20Database%20Pricing Managed Instance is incorrect because the database limit is 2-8TB max. https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits#:~:text=Up%20to%20280%2C%20unless%20the%20instance%20storage%20size,TB%29%20and%20Azure%20Premium%20Disk%20storage%20allocation%20space.

75T can only be supported by hyperscale.

Answer correct Managed instance can only support upto 32 GB - 16 TB

CORRECT

Answer : Azure SQL Database Hyperscale is the most suitable database architecture for the given requirements.

The key is that only Hyperscale can deal with 75 Tb, All other have limit of 4 Tb

Azure SQL Database Hyperscale: Support scaling up and down: The Hyperscale service tier supports scaling compute resources up and down based on your workload requirements. Support geo-redundant backups: It offers automatic backups with the ability to enable geo-redundant backups to ensure data durability in case of regional disasters. Support a database of up to 75 TB: Hyperscale supports databases up to 100 TB in size, which meets the requirement of 75 TB. Be optimized for online transaction processing (OLTP): Azure SQL Database Hyperscale is designed to handle OLTP workloads with high performance and low latency. In summary, you should include Azure SQL Database with the Hyperscale service tier in your database architecture design to meet all the listed requirements.

1. Azure SQL DB 2. Hyperscale https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale?view=azuresql#what-are-the-hyperscale-capabilities The Hyperscale service tier in Azure SQL Database provides the following additional capabilities: - Support for up to 100 TB of database size. - Higher overall performance due to higher transaction log throughput and faster transaction commit times regardless of data volumes. - Rapid Scale up - you can, in constant time, scale up your compute resources to accommodate heavy workloads when needed, and then scale the compute resources back down when not needed.

Answer is correct; let me compare with explain on microsoft official site; https://learn.microsoft.com/en-us/training/modules/design-data-storage-solution-for-relational-data/4-design-for-sql-server-azure#:~:text=SQL%20Server%20licenses.-,Compare%20Azure%20SQL%20deployment%20options,-You%27ve%20reviewed%20the

Answer is correct Box 1: Azure SQL Database Box 2: Hyperscale - key point 75TB Azure SQL Database with Hyperscale Thanks all who have mentioned the exam dates

Exam Question 12/28/2022

Ans - Correct

Correct. Resource limits for SQL Database tiers https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale?view=azuresql#compare-resource-limits

"Support geo-redundant backups". - this is not the same as geo replication as the answer states.... Both MI and SQL variants have auto backup that is stored as geo redundant blobs replicated to a paired region. But yes, hyperscale is correct due to DB size.

The reason to choose Hyperscale, since its the design of db migration: The Hyperscale service tier in Azure SQL Database provides the following additional capabilities: Support for up to 100 TB of database size. Fast database backups (based on file snapshots stored in Azure Blob storage) regardless of size with no IO impact on compute resources. Fast database restores (based on file snapshots) in minutes rather than hours or days (not a size of data operation). Higher overall performance due to higher transaction log throughput and faster transaction commit times regardless of data volumes. Rapid scale out - you can provision one or more read-only replicas for offloading your read workload and for use as hot-standbys. Rapid Scale up - you can, in constant time, scale up your compute resources to accommodate heavy workloads when needed, and then scale the compute resources back down when not needed.

Answers are correct - Azure SAL Database with Hyperscale.

was in exam 8 May 22