Hello @Toseef Ajmeri (AU) The short answer to all 3 questions is YES. Now, let me explain why.
If you look into the pricing of Azure Cosmos DB, it's billed for 3 different types of usage - compute, storage and bandwidth. See the details here - https://azure.microsoft.com/en-us/pricing/details/cosmos-db/autoscale-provisioned/
With this in mind, let's try to look into each of your questions.
- Azure Cosmos DB bills for consumed storage which includes all transactional and analytical data, indexes and backups. As a result, the size of your data (100-250kb multiplied by 10000-50000 orders) directly contribute to the overall storage cost and hence affect your billing.
- Azure Cosmos DB uses Request Units (RU) to measure compute, storage and I/O used for processing database operations. Operations like reads, writes, queries etc. consume RU. The exact RU value for an operation is correlated to the size of the item. In a nutshell, this will also contribute to your cost.
- This is just an extension of my response to Q1 that Cosmos DB bills you for the data storage and hence this will impact your cost as well.
If the Answer is helpful, please click "Accept Answer" and upvote it.