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

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

Exhibit

Refer to the exhibit.

```json
{
  "properties": {
    "state": "Enabled",
    "location": "West US",
    "properties": {
      "storageContainerPath": "https://mystorageaccount.blob.core.windows.net/sqldb-auditing-logs",
      "retentionDays": 90,
      "auditActionsAndGroups": [
        "DATABASE_LOGOUT_GROUP",
        "DATABASE_ROLE_MEMBER_CHANGE_GROUP",
        "SCHEMA_OBJECT_ACCESS_GROUP"
      ],
      "isAzureMonitorTargetEnabled": true,
      "isStorageSecondaryKeyInUse": false
    }
  }
}
```

You are reviewing the audit configuration of an Azure SQL Database using the above JSON from Azure Resource Manager. Based on the exhibit, which of the following is true?

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

✓

Audit logs are sent to Azure Monitor

The JSON shows 'isAzureMonitorTargetEnabled' is true, indicating audit logs are sent to Azure Monitor. Option B is incorrect because 'state' is 'Enabled', meaning auditing is enabled. Option A is incorrect because 'isStorageSecondaryKeyInUse' is false. Option C is incorrect because 'retentionDays' is 90, not 30.

Answer analysis

Option-by-option breakdown

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

✗
Audit logs are written using the secondary storage key
Why it's wrong here
isStorageSecondaryKeyInUse is false.
✗
Auditing is currently disabled
Why it's wrong here
state is Enabled.
✗
Audit logs are retained for 30 days
Why it's wrong here
retentionDays is 90.
✓
Audit logs are sent to Azure Monitor
Why this is correct
isAzureMonitorTargetEnabled is true.

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