Question

A retail analytics dashboard issues the same set of point reads and queries thousands of times per minute against an Azure Cosmos DB for NoSQL container. The data changes only a few times per hour, but the team is alarmed by the RU consumption and cost from these repetitive reads. They want to dramatically reduce RU charges for the repeated reads without changing the queries themselves. Which approach best meets this requirement?

Accepted Answer

Provision a dedicated gateway and configure the integrated cache, connecting the SDK in gateway mode with a suitable MaxIntegratedCacheStaleness.

Answer

Switch the SDK to direct connectivity mode to bypass the gateway and cache results client-side.

Answer

Enable Azure Synapse Link and query the analytical store for the repeated reads.

Answer

Increase provisioned throughput with autoscale so the repeated reads no longer throttle.