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

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

Exhibit

Refer to the exhibit.

{
    "properties": {
        "state": "Enabled",
        "storageEndpoint": "https://mystorage.blob.core.windows.net",
        "retentionDays": 30,
        "auditActionsAndGroups": [
            "SUCCESSFUL_DATABASE_AUTHENTICATION_GROUP",
            "FAILED_DATABASE_AUTHENTICATION_GROUP"
        ]
    }
}

Refer to the exhibit. You apply this JSON configuration to an Azure SQL Database server. Which actions will be audited?

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

✓

Only successful and failed database authentication attempts

The configuration only includes SUCCESSFUL_DATABASE_AUTHENTICATION_GROUP and FAILED_DATABASE_AUTHENTICATION_GROUP. Option A is wrong because it includes actions not in the config. Option B is wrong because it includes data modification actions. Option D is wrong because it includes all actions.

Answer analysis

Option-by-option breakdown

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

✗
All successful and failed login attempts and all schema changes
Why it's wrong here
Schema changes not included.
✗
All database-level actions
Why it's wrong here
Only authentication groups.
✓
Only successful and failed database authentication attempts
Why this is correct
Only the two groups specified.
✗
All successful and failed logins and all data modification statements
Why it's wrong here
Data modifications not included.

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