Ensure SQL Server Threat Detection Retention is set to a value greater than 90 days for Azure SQL Database

SQL Server Threat Detection Retention period has less than 90 days, 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 90 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