
Ultimate access to all questions.
In a web application utilizing Amazon DynamoDB, with 'artists' and 'songs' tables configured with 'artistName' as the partition key in both, and 'songName' additionally as the partition key in the 'songs' table, how can a developer efficiently retrieve multiple songs and artists with minimal network traffic and ensure optimal performance?
A
Execute a BatchGetItem operation for both tables, utilizing songName/artistName pairs for the 'songs' table and artistName for the 'artists' table.
B
Implement a local secondary index on the 'songs' table with artistName as the partition key, then conduct query operations filtering by songName for each artist.
C
Use BatchGetItem for the 'songs' table with songName/artistName pairs and separately for the 'artists' table with artistName.
D
Conduct Scan operations on both tables, applying filters for songName/artistName in the 'songs' table and artistName in the 'artists' table.