Configure and manage automation of tasks →mediumMultiple ChoiceObjective-mapped

DP-300 Configure and manage automation of tasks Practice Question

Exhibit

Refer to the exhibit.

{
  "name": "start-stop-database",
  "type": "Microsoft.Logic/workflows",
  "location": "eastus",
  "properties": {
    "definition": {
      "$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
      "actions": {
        "Pause_Database": {
          "type": "ApiConnection",
          "inputs": {
            "host": {
              "connection": {
                "name": "@parameters('$connections')['sql']['connectionId']"
              }
            },
            "method": "post",
            "path": "/databases/@{encodeURIComponent('AdventureWorks')}/pause",
            "queries": {
              "api-version": "2023-08-01-preview"
            }
          }
        }
      },
      "triggers": {
        "Recurrence": {
          "recurrence": {
            "frequency": "Week",
            "interval": 1,
            "schedule": {
              "hours": [20],
              "minutes": [0],
              "weekDays": ["Friday"]
            }
          },
          "type": "Recurrence"
        }
      }
    }
  }
}

Refer to the exhibit. A Logic App is configured to pause an Azure SQL Database named AdventureWorks every Friday at 8 PM. However, the database is not pausing. What is the most likely reason?

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 pause action is not supported for Azure SQL Database.

Azure SQL Database does not support pause/resume; only Azure SQL Data Warehouse (now Azure Synapse Analytics dedicated SQL pool) supports it. Therefore, the pause action is not supported for Azure SQL Database, making option D correct. Option A is incorrect because the connection authentication is not the issue here. Option B is incorrect because the recurrence trigger schedule is valid. Option C is incorrect because the API version is not the primary reason; the operation itself is unsupported.

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 SQL connection is not authenticated.
Why it's wrong here
The connection name is referenced correctly; authentication is handled separately.
✗
The recurrence trigger uses a schedule that is not valid.
Why it's wrong here
The recurrence schedule is valid: weekly on Friday at 20:00.
✗
The API version specified is outdated.
Why it's wrong here
The API version 2023-08-01-preview is recent; the issue is not the version but the operation.
✓
The pause action is not supported for Azure SQL Database.
Why this is correct
Pause/resume is only available for Azure Synapse dedicated SQL pools, not Azure SQL Database.

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