Query: Geo-redundant storage should be enabled for Storage Accounts

Description

Use geo-redundancy to create highly available applications.

Query

Tables used in this query:

• azure_storage_account
• azure_subscription

Controls using this query:

• 10.3.12 Ensure Redundancy is set to 'geo-redundant storage (GRS)' on critical Azure Storage Accounts
• 9.3.11 Ensure Redundancy is set to 'geo-redundant storage (GRS)' on critical Azure Storage Accounts
• Geo-redundant storage should be enabled for Storage Accounts

SQL