Ensure SQL Server audit with selected event types is enabled and has retention period of minimum 365 days for Azure SQL Database

SQL Server audit has retention period of less than 365 days for Azure SQL Database, this may make audit challenging.

In Azure Console -

1. Open the Azure Portal and go to SQL servers.
2. Choose the SQL server you wish to edit.
3. Under Backups, under Retention policies, add retention policies.
4. Select save.

In Terraform -

1. In the azurerm_sql_database resource, set retention_days greater than 365 days.

References:
https://learn.microsoft.com/en-us/sql/relational-databases/database-mail/database-mail?view=sql-server-ver16
https://registry.terraform.io/providers/hashicorp/azurerm/latest/docs/resources/sql_database#retention_days