nerdexam
Microsoft

DP-420 · Question #206

You have an Azure Cosmos DB for NoSQL 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…

The correct answer is D. | where OperationName startswith "SqlContainersThroughputUpdate". The ControlPlaneRequests category in Azure Diagnostics logs management-plane operations - changes to account configuration, databases, containers, and throughput settings. To find RU/s modifications specifically for a SQL (Core) API container, the relevant operation name is…

Maintain an Azure Cosmos DB solution

Question

You have an Azure Cosmos DB for NoSQL 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 " AccountUpdateComplete"
  • B| where OperationName startswith "SqlContainersCreate"
  • C| where OperationName startswith "MongoCollectionsThroughputUpdate"
  • D| where OperationName startswith "SqlContainersThroughputUpdate"

How the community answered

(30 responses)
  • A
    3% (1)
  • B
    17% (5)
  • C
    10% (3)
  • D
    70% (21)

Explanation

The ControlPlaneRequests category in Azure Diagnostics logs management-plane operations - changes to account configuration, databases, containers, and throughput settings. To find RU/s modifications specifically for a SQL (Core) API container, the relevant operation name is SqlContainersThroughputUpdate (option D). This operation is recorded whenever someone updates the throughput (manual or autoscale) on a Cosmos DB for NoSQL container. Option A (AccountUpdateComplete) covers account-level settings changes, not per-container throughput. Option B (SqlContainersCreate) logs container creation events, not throughput updates. Option C (MongoCollectionsThroughputUpdate) applies to the Azure Cosmos DB for MongoDB API, not the NoSQL (SQL) API.

Topics

#Azure Cosmos DB#Diagnostic Logs#Kusto Query Language#Throughput Management

Community Discussion

No community discussion yet for this question.

Full DP-420 Practice