data-engineer video for a retail company is using an Amazon DynamoDB table to store its product data. The table has a partition key based on the ProductID
A retail company is using an Amazon DynamoDB table to store its product data. The table has a partition key based on the ProductID attribute. The company now needs to query the table by Category and sort the results by Price. However, the table’s current partition key does not allow this query pattern, and the company wants a flexible, scalable solution that can be modified later if needed. Which solution will allow this query pattern while maintaining flexibility?