
Answer-first summary for fast verification
Answer: Using Amazon DynamoDB, set up a table with a composite primary key of title and release year, and add a global secondary index on genre and title.
The correct answer is A. Using Amazon DynamoDB with a primary key consisting of the title and release year allows efficient retrieval of data for a specific movie by its title and release year. Additionally, creating a global secondary index with the genre as the partition key and the title as the sort key allows efficient querying of all movies in a specific genre. This setup also accommodates the storage of variable cast and crew details due to DynamoDB's flexible schema.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How should a developer configure a data store to manage movie information, including title, release year, genre, and variable cast and crew details, while supporting queries by specific title and year, all titles, and genre?
A
Using Amazon DynamoDB, set up a table with a composite primary key of title and release year, and add a global secondary index on genre and title.
B
Using Amazon DynamoDB, set up a table with a composite primary key of genre and release year, and add a global secondary index on title.
C
Utilize an Amazon RDS table structured with title as the primary key and columns for release year and genre.
D
Utilize an Amazon RDS table with title as the primary key, storing all additional details in a JSON column.
No comments yet.