Question

You are building an inventory system on Azure Cosmos DB for NoSQL. A container named 'inventory' is partitioned by '/warehouseId'. You need to atomically decrement the stock count on multiple item documents that all belong to the same warehouse, and insert an audit-log document, all in a single transaction. You decide to use a server-side stored procedure. What is the most important constraint you must account for when invoking this stored procedure?

Accepted Answer

The stored procedure must be executed against a single logical partition key value, so all affected documents must share the same warehouseId.

Answer

The stored procedure can span multiple logical partitions as long as the total operation completes within the 5-second server execution budget.

Answer

The stored procedure automatically resumes across partitions when it returns a continuation token, so no partition constraint applies.

Answer

The stored procedure must be invoked using the Gateway connection mode to guarantee transactional atomicity across partitions.