Prev Next

Database / Azure Cosmos DB interview questions

How does Cosmos DB pricing work and what are the key cost drivers?

Cosmos DB billing has three main components: provisioned throughput, storage, and additional features. Understanding each is essential for cost-effective application design.

1. Throughput cost — For provisioned throughput, you are billed per 100 RU/s per hour (around $0.008/hour per 100 RU/s in East US as of 2024). For autoscale, you pay for the maximum RU/s reached in any one-hour window. For serverless, you pay per million RU consumed. Throughput is the dominant cost for most workloads, making RU optimization the most impactful cost lever.

2. Storage cost — Charged per GB per month for the data stored in the container (both the document data and index storage). Index size can be significant — excluding unnecessary fields from the indexing policy reduces both write RU cost and storage billing.

3. Multi-region replication — Each additional read region multiplies your throughput cost. Writing to a 3-region account with provisioned 10,000 RU/s is billed as 30,000 RU/s equivalent. This is often the largest surprise in Cosmos DB bills for teams that add regions without considering the cost multiplier.

4. Additional features — The analytical store has separate storage pricing. Dedicated gateway has per-hour pricing per instance. Backup storage beyond the default 7-day point-in-time window incurs additional charges. Continuous backup (30-day or 7-day with point-in-time restore) costs more than periodic backup.

Cost optimization strategies:

  • Use autoscale instead of manual provisioning for variable workloads to avoid idle RU cost.
  • Reduce index size by excluding large text fields and rarely-queried properties.
  • Use TTL to auto-delete expired data rather than accumulating storage.
  • Leverage the Integrated Cache for read-heavy hot data to reduce RU consumption.
  • Keep cross-partition queries to a minimum — they consume RU proportional to the number of partitions.
If you add two additional read regions to a Cosmos DB account provisioned at 10,000 RU/s, what is the effective throughput you are billed for?
Beyond document data, what else contributes to Cosmos DB storage billing?

Invest now in Acorns!!! 🚀 Join Acorns and get your $5 bonus!

Invest now in Acorns!!! 🚀
Join Acorns and get your $5 bonus!

Earn passively and while sleeping

Acorns is a micro-investing app that automatically invests your "spare change" from daily purchases into diversified, expert-built portfolios of ETFs. It is designed for beginners, allowing you to start investing with as little as $5. The service automates saving and investing. Disclosure: I may receive a referral bonus.

Invest now!!! Get Free equity stock (US, UK only)!

Use Robinhood app to invest in stocks. It is safe and secure. Use the Referral link to claim your free stock when you sign up!.

The Robinhood app makes it easy to trade stocks, crypto and more.


Webull! Receive free stock by signing up using the link: Webull signup.

More Related questions...

What is Azure Cosmos DB and what problems does it solve? What are the different APIs available in Azure Cosmos DB? What is a partition key in Azure Cosmos DB and why is choosing it correctly so important? What are Request Units (RU/s) in Azure Cosmos DB? What are the five consistency levels in Azure Cosmos DB? How does global distribution work in Azure Cosmos DB? What is the Cosmos DB Change Feed and what are its main use cases? What is provisioned throughput vs autoscale vs serverless in Cosmos DB? How does indexing work in Azure Cosmos DB? What is Time to Live (TTL) in Cosmos DB and how do you configure it? What is a stored procedure in Cosmos DB and what are its limitations? What is the difference between a point read and a query in Cosmos DB? What is the Cosmos DB NoSQL query language and how does it differ from standard SQL? What is the Cosmos DB transactional batch API? What is Cosmos DB Integrated Cache and how does it reduce RU consumption? How does optimistic concurrency work in Azure Cosmos DB? What is hierarchical partition keys in Cosmos DB and when do you use it? What is the Cosmos DB Bulk Executor and how do you use bulk operations in the SDK? What are Cosmos DB triggers and user-defined functions (UDFs)? How does Cosmos DB handle conflicts in multi-region write (multi-master) setups? What is the Cosmos DB Emulator and how is it used in development? What is Cosmos DB for MongoDB API and what version compatibility does it provide? What is the Cosmos DB analytical store and Azure Synapse Link? What are Cosmos DB materialized views and how do they differ from containers? How does Cosmos DB pricing work and what are the key cost drivers? What is the Cosmos DB Gremlin API and what is it optimized for? How does Cosmos DB backup and restore work? What is the Cosmos DB Patch API and how does it differ from Replace? What is the Cosmos DB Cassandra API and how does CQL map to Cosmos DB concepts? How do you model one-to-many relationships in Cosmos DB? What is the Cosmos DB free tier and what does it include? What is the Cosmos DB SDK and what are the key client configuration options? What is the Cosmos DB Table API and when would you migrate from Azure Table Storage to it? How does Cosmos DB handle security and access control?
Show more question and Answers...

MuleESB

Comments & Discussions