Exam AZ-305 topic 2 question 33 discussion

I agree with the answer. "Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second. The serverless compute tier is available in the General Purpose service tier and currently in preview in the Hyperscale service tier." https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview

i dont see serverless in the question why ppl talk about that? is it possible that the question changed?

CORRECT

Auto-pausing and auto-resuming is currently only supported in the General Purpose service tier. then from a per second billing requirement, the general purpose is a better option than Hyperscale

I "love" how Microsoft came up with the "General Purpose" and "Standard" terms, both sort of suggesting more or less the same thing, but some products use one of them and other products use the other one... Microsoft, are you trying DELIBERATELY to trick and confuse us?

A single Azure SQL database Service tier: Hyperscale

-Single Azure SQL Database -Hyperscale

Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns. The serverless compute tier is available in the General Purpose service tier and the Hyperscale service tier.

the given answer is correct. A single Azure SQL database: Provides the flexibility to scale compute resources independently. General Purpose: This service tier supports serverless configuration, which automatically scales compute resources based on demand and provides per-second billing.

Azure SQL Product: You should choose “A single Azure SQL database”. This product is designed to automatically scale compute resources based on the workload demand. Service Tier: The “Hyperscale” service tier would be the best fit. It provides highly scalable storage and compute performance that can auto-scale up to 100 TB per database, which aligns with the requirement of automatically scaling compute resources. Additionally, Hyperscale service tier provides rapid scaling capabilities without downtime.

This question seems incomplete. Both General Purpose and Hyperscale serverless compute tiers work here. Something is missing to the requirements of the question. I wonder if this is an old question and the tiers have changed since it was in circulation. Anyway, pick your poison. General Purpose and Hyperscale technically both work here. Single Azure SQL DB in the only only that supports per-second billing. The others require provisioned compute tiers. Cheers

I tend to disagree with answer and those who say Hyperscale is NOT publicly available, obviously you are NOT practicing what you study!! can easily be checked by creating SQL DB in azure under vCore compute answer is Single SQL DB - as all agreed Hyperscale service tier and below is why (NOTE no mention of cost as condition) The widest variety of workloads, including those workloads with highly scalable storage and read-scale requirements. Offers higher resilience to failures by allowing configuration of more than one high availability secondary replica. The Hyperscale service tier is suitable for all workload types. Its cloud native architecture provides independently scalable compute and storage to support the widest variety of traditional and modern applications. Compute and storage resources in Hyperscale substantially exceed the resources available in the General Purpose and Business Critical tiers Follow below

https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql&tabs=general-purpose Based on above link, both answers are correct.

1: SINGLE SQL DATABASE 2: GENERAL PURPOSE SERVICE TIER

Both "General Purpose" and "Hyperscale" support Serverless, but "Serverless for Hyperscale is currently in preview." So, better to select "General Purpose".

give answer is correct. Hyperscale doen't provide per second billing: https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale?view=azuresql

To meet the requirements of automatically scaling compute resources based on workload demand and providing per-second billing, you should recommend the following: Azure SQL Product: Azure SQL Database Service Tier: Hyperscale Azure SQL Database Hyperscale provides automatic scaling of compute resources based on the workload demand, allowing your database to handle varying workloads effectively. It also offers per-second billing, which means you are billed based on the actual usage, providing cost efficiency. Hyperscale is particularly suitable for large and mission-critical databases that require high performance and scalability.