You are developing an Azure Cosmos DB solution by using the Azure Cosmos DB SQL API. The data includes millions of documents. Each document may contain hundreds of properties. The properties of the…

Question

Options

• Aa single property value that does not appear frequently in the documents
• Ba value containing the collection name
• Ca single property value that appears frequently in the documents
• Da concatenation of multiple property values with a random suffix appended
• Ea hash suffix appended to a property value

• A
  9% (6)
• B
  4% (3)
• C
  13% (9)
• D
  73% (49)

Explanation

You can form a partition key by concatenating multiple property values into a single artificial partitionKey property. These keys are referred to as synthetic keys. Another possible strategy to distribute the workload more evenly is to append a random number at the end of the partition key value. When you distribute items in this way, you can perform parallel write operations across partitions. Note: It's the best practice to have a partition key with many distinct values, such as hundreds or thousands. The goal is to distribute your data and workload evenly across the items associated with these partition key values. If such a property doesn't exist in your data, you can construct a synthetic partition key. https://docs.microsoft.com/en-us/azure/cosmos-db/synthetic-partition-keys

No community discussion yet for this question.