Monitor, configure, and optimize database resources →hardMultiple ChoiceObjective-mapped

DP-300 Practice Question: Monitor, configure, and optimize database resources

Exhibit

Refer to the exhibit.

```json
{
  "type": "Microsoft.Sql/servers/databases/securityAlertPolicies",
  "apiVersion": "2023-08-01-preview",
  "name": "Default",
  "properties": {
    "state": "Enabled",
    "emailAddresses": ["admin@contoso.com"],
    "emailAccountAdmins": true,
    "storageEndpoint": "https://mystorageaccount.blob.core.windows.net",
    "retentionDays": 0
  }
}
```

You are reviewing a deployment template for an Azure SQL Database. The above snippet configures a security alert policy. What is a potential issue with this configuration?

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

The retentionDays is set to 0, which may cause logs to be deleted immediately

RetentionDays set to 0 disables retention, meaning audit logs will not be retained in storage. Option A is wrong because state Enabled is fine. Option B is wrong because emailAddresses is provided. Option D is wrong because emailAccountAdmins true is fine.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
The state is not set to "Disabled"
Why it's wrong here
The state is set to Enabled, which is correct for a security alert policy.
✗
The emailAccountAdmins property is set to true
Why it's wrong here
EmailAddresses is provided and emailAccountAdmins is set to true, which is fine.
✓
The retentionDays is set to 0, which may cause logs to be deleted immediately
Why this is correct
RetentionDays set to 0 disables retention, meaning audit logs will not be retained in storage.
✗
The emailAddresses array is missing an entry
Why it's wrong here
EmailAccountAdmins true is fine.

Go deeper

DP-300 Practice Question: Monitor, configure, and optimize database resources

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question