Configure and manage automation of tasks →easyMultiple ChoiceObjective-mapped

DP-300 Configure and manage automation of tasks Practice Question

Exhibit

{
  "type": "Microsoft.Sql/servers/databases/auditingSettings",
  "apiVersion": "2020-11-01-preview",
  "properties": {
    "state": "Enabled",
    "auditActionsAndGroups": [
      "SUCCESSFUL_DATABASE_AUTHENTICATION_GROUP",
      "FAILED_DATABASE_AUTHENTICATION_GROUP"
    ],
    "storageAccountAccessKey": "...",
    "retentionDays": 90
  }
}

Refer to the exhibit. The ARM template snippet configures auditing for an Azure SQL Database. Based on the configuration, which events are 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

✓

Successful and failed database authentication attempts.

The auditActionsAndGroups include SUCCESSFUL_DATABASE_AUTHENTICATION_GROUP and FAILED_DATABASE_AUTHENTICATION_GROUP, which audit successful and failed logins respectively. Option A is wrong because data modification statements (DML) are not included. Option C is wrong because data modifications are not included. Option D is wrong because only authentication events are listed.

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 data modification statements (DML).
Why it's wrong here
DML is not included; the audit groups listed are for authentication events.
✓
Successful and failed database authentication attempts.
Why this is correct
Both successful and failed authentication attempts are included, as per the groups listed.
✗
Only failed authentication attempts.
Why it's wrong here
The audit includes both successful and failed attempts, not just failed.
✗
All database schema changes (DDL).
Why it's wrong here
Only authentication events are listed, not schema changes.

Go deeper

DP-300 Configure and manage automation of tasks Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question