DP-420 decision sheets

• SELECT VALUE for scalar aggregates and indexer custom queries
• Analytical store vs transactional store
• Cosmos DB built-in roles: data plane vs control plane
• Consistency levels: RPO, integrated cache and multi-write limits
• Diagnostic log table selection (resource-specific mode)
• Read regions vs multi-region writes vs manual and automatic failover
• Hierarchical partition keys: when to use them and how queries route
• Cosmos DB index types and indexing-policy strategy
• Migration and integration tool selection
• Logical vs physical partitions: throughput and storage limits
• Gateway mode vs direct mode, and CosmosClient lifetime
• Cosmos DB security: which control protects what
• Stored procedures vs TransactionalBatch