DP-420 · Question #197
You have an Azure Cosmos DB for NoSQL container. All queries to the container use the Bounded Staleness consistency level. You discover that when many queries are executed against the container, an…
The correct answer is B. Add a post-trigger to the container. E. Increase the maximum throughput. NOTE: The stated correct answers (B and E) appear to contain an error. Adding a post-trigger (B) executes additional server-side logic on each write, which consumes more RUs and would increase - not decrease - 429 errors. The logically correct answers are D and E. (D) Adding…
Question
You have an Azure Cosmos DB for NoSQL container. All queries to the container use the Bounded Staleness consistency level. You discover that when many queries are executed against the container, an HTTP 429 error is returned. What are two ways to reduce the number of HTTP 429 errors? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Options
- AUse a query request option to change the consistency level to Strong.
- BAdd a post-trigger to the container.
- CAdd a pre-trigger to the container.
- DAdd query retry logic to the client application.
- EIncrease the maximum throughput.
How the community answered
(27 responses)- A4% (1)
- B81% (22)
- C4% (1)
- D11% (3)
Explanation
NOTE: The stated correct answers (B and E) appear to contain an error. Adding a post-trigger (B) executes additional server-side logic on each write, which consumes more RUs and would increase - not decrease - 429 errors. The logically correct answers are D and E. (D) Adding query retry logic to the client application handles 429 responses gracefully with backoff, reducing the effective request rate under load and preventing cascading failures. (E) Increasing the maximum throughput directly raises the RU/s capacity of the container, so more concurrent queries can be served without hitting the limit. Changing consistency to Strong (A) would consume even more RUs (Strong reads are more expensive), making the problem worse. Pre-triggers (C) also add RU overhead. If this question appears on an exam, select D and E as the defensible answers.
Topics
Community Discussion
No community discussion yet for this question.