A company created a serverless application that includes users' favorite actors. The company modeled its ata in an Amazon DynamoDB table The categories of the table are Actor, Movie, and Year.
Each actor appears in several movies and can appear in multiple movies in a single year. The company ants to see which of the users' favorite actors were in the same movie and which movies were in the ame year. A developer needs to design the DynamoDB table to minimize response time for those queries.
Which solution meets these requirements?
A. Create a composite primary key with Actor as the partition key and Movie as the sort key Use Year as the sort key for a global secondary index (GSI).
B. Create a composite primary key with Actor as the partition key and Year as the sort key Use Movie as the sort key for a global secondary index (GSI).
C. Create a composite primary key with Movie as the partition key and Actor as the sort key Use Year as the sort key for a global secondary index (GSI).
D. Create a simple primary key with Actor as the partition key. Use Year as the sort key for a local secondary index (LSI).
Each actor appears in several movies and can appear in multiple movies in a single year. The company ants to see which of the users' favorite actors were in the same movie and which movies were in the ame year. A developer needs to design the DynamoDB table to minimize response time for those queries.
Which solution meets these requirements?
A. Create a composite primary key with Actor as the partition key and Movie as the sort key Use Year as the sort key for a global secondary index (GSI).
B. Create a composite primary key with Actor as the partition key and Year as the sort key Use Movie as the sort key for a global secondary index (GSI).
C. Create a composite primary key with Movie as the partition key and Actor as the sort key Use Year as the sort key for a global secondary index (GSI).
D. Create a simple primary key with Actor as the partition key. Use Year as the sort key for a local secondary index (LSI).