To create Zone Redundant Azure SQL database(Hyper Scale with 1 replica):

Modify the command to use a valid SKU, such as HS_Gen5_4 or higher (e.g., HS_Gen5_8, HS_Gen5_16).

• Updated Command:

New-AzSqlDatabase -ResourceGroupName "trial" -ServerName "msazserver" -DatabaseName "Database01" -Edition "Hyperscale" -HighAvailabilityReplicaCount 1 -ZoneRedundant -BackupStorageRedundancy Zone -RequestedServiceObjectiveName HS_Gen5_4

Change the server, resource group and database name accordingly.

• Another way to create a Zone Redundant SQL database:

1. Create a New SQL Database
2. In Compute + Storage section, click on Configure Database.

3. Under Service Tier, choose Hyperscale

4. Select Yes to make database zone dedundant with 1 Replica.