Develop data processing →hardMultiple ChoiceObjective-mapped

DP-203 Develop data processing Practice Question

Exhibit

Refer to the exhibit.

{
  "type": "Microsoft.Synapse/workspaces/sqlPools",
  "properties": {
    "createMode": "Default",
    "storageAccountType": "GRS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "maxSizeBytes": 263882790666240,
    "sku": {
      "name": "DW100c",
      "tier": "ServiceObjective"
    },
    "restorePointInTime": null,
    "sourceDatabaseId": null
  }
}

Refer to the exhibit. You are deploying an Azure Synapse Analytics dedicated SQL pool using the provided ARM template snippet. After deployment, you need to adjust the performance level to DW200c to handle increased workload. Which parameter should you modify?

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

✓

sku.name

Sku.name. In an Azure Synapse Analytics dedicated SQL pool, the performance level (e.g., DW200c) is defined by the 'sku.name' parameter in the ARM template. Option A (storageAccountType) controls data redundancy, not performance. Option B (maxSizeBytes) sets the maximum storage size. Option C (collation) determines the default collation for the database, which affects language support. Therefore, to adjust performance to DW200c, modify the sku.name parameter.

Answer analysis

Option-by-option breakdown

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

✗
storageAccountType
Why it's wrong here
This defines geo-redundancy options, not performance.
✗
maxSizeBytes
Why it's wrong here
This sets the maximum storage size, not compute performance.
✗
collation
Why it's wrong here
Collation defines sorting and comparison rules, not performance.
✓
sku.name
Why this is correct
The sku name specifies the Data Warehouse Unit (DWU) level, e.g., DW100c or DW200c.

Go deeper

DP-203 Develop data processing Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question