Configure and manage automation of tasks →hardMultiple ChoiceObjective-mapped

DP-300 Configure and manage automation of tasks Practice Question

Exhibit

{
  "properties": {
    "targetGroup": {
      "type": "SqlDatabase",
      "membershipType": "Exclude",
      "members": [
        {
          "serverName": "prod-server",
          "databaseName": "db1"
        }
      ]
    },
    "schedule": {
      "type": "Once",
      "startTime": "2026-01-15T02:00:00Z"
    },
    "jobStep": {
      "type": "TSql",
      "commandText": "EXEC sp_cleanup @retention_days = 30"
    }
  }
}

Refer to the exhibit. You are reviewing an Elastic Database Job definition for Azure SQL Database. The job is scheduled to run once on January 15, 2026. Which statement about the job's target is correct?

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 job will target all databases in the server except 'db1'.

The target group uses membershipType 'Exclude' with a members list containing only 'db1'. This means that the job will target all databases in the logical server except 'db1'. Option A is incorrect because the membership type is 'Exclude', not 'Include', so it does not target only 'db1'. Option C is incorrect because the target group is at the database level within a server, not the entire server itself. Option D is incorrect because the target group excludes 'db1', so it targets all databases on the server, but not the server as a whole.

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 job will target only the database named 'db1'.
Why it's wrong here
The membership type is 'Exclude', so 'db1' is excluded.
✓
The job will target all databases in the server except 'db1'.
Why this is correct
Exclude membership with a list excludes those databases from the server.
✗
The job will target the entire logical server.
Why it's wrong here
The target group type is SqlDatabase, not SqlServer.
✗
The job will target the server and all its databases.
Why it's wrong here
The target is databases, not the server, and excludes db1.

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