nerdexam
Microsoft

DP-420 · Question #27

You have an Azure Cosmos DB Core (SQL) API account. You configure the diagnostic settings to send all log information to a Log Analytics workspace. You need to identify when the provisioned request…

The correct answer is D. | where OperationName startswith "SqlContainersThroughputUpdate". The correct answer is D: | where OperationName startswith 'SqlContainersThroughputUpdate'. When querying the ControlPlaneRequests category in Azure Diagnostics logs, each management operation has a distinct OperationName. The operation that records changes to provisioned…

Maintain an Azure Cosmos DB solution

Question

You have an Azure Cosmos DB Core (SQL) API account. You configure the diagnostic settings to send all log information to a Log Analytics workspace. You need to identify when the provisioned request units per second (RU/s) for resources within the account were modified. You write the following query. AzureDiagnostics | where Category == "ControlPlaneRequests" What should you include in the query?

Options

  • A| where OperationName startswith "AccountUpdateStart"
  • B| where OperationName startswith "SqlContainersDelete"
  • C| where OperationName startswith "MongoCollectionsThroughputUpdate"
  • D| where OperationName startswith "SqlContainersThroughputUpdate"

How the community answered

(50 responses)
  • A
    6% (3)
  • B
    2% (1)
  • C
    2% (1)
  • D
    90% (45)

Explanation

The correct answer is D: | where OperationName startswith 'SqlContainersThroughputUpdate'. When querying the ControlPlaneRequests category in Azure Diagnostics logs, each management operation has a distinct OperationName. The operation that records changes to provisioned throughput (RU/s) on a SQL API container is SqlContainersThroughputUpdate. Option A (AccountUpdateStart) tracks account-level setting changes. Option B (SqlContainersDelete) tracks container deletions. Option C (MongoCollectionsThroughputUpdate) is specific to the MongoDB API, not the Core (SQL) API. Since the account uses the Core (SQL) API, option D is the correct filter.

Topics

#Azure Cosmos DB Diagnostics#Log Analytics KQL#Throughput Management#Control Plane Operations

Community Discussion

No community discussion yet for this question.

Full DP-420 Practice