Policy: Azure > CIS v1 > 4 Database Services > 4.09 Ensure that 'Data encryption' is set to 'On' on a SQL Database (Scored)

Configures auditing against a CIS Benchmark item.

Level: 1 (Scored)

Enable Transparent Data Encryption on every SQL server.

Resource Types

This policy targets the following resource types:

This policy is used with the following primary policy:

Schema Type	`string`
Default	`Per Azure > CIS v1`
Valid Values [YAML]	`Per Azure > CIS v1` `Skip` `Check: Level 1 (Scored)`

Category URI

tmod:@turbot/cis#/control/categories/v071408

Policy Type URI

tmod:@turbot/azure-cisv1#/policy/types/r0409

GraphQL

query policyType(id: "tmod:@turbot/azure-cisv1#/policy/types/r0409") { … }

query policySettings(filter: "policyTypeId:'tmod:@turbot/azure-cisv1#/policy/types/r0409'") { … }

query policyValues(filter: "policyTypeId:'tmod:@turbot/azure-cisv1#/policy/types/r0409'") { … }

CLI

Get Policy Type

turbot graphql policy-type --id "tmod:@turbot/azure-cisv1#/policy/types/r0409"

Get Policy Settings

turbot graphql policy-settings --filter "policyTypeId:tmod:@turbot/azure-cisv1#/policy/types/r0409"