DVA-C02 · Question #706
DVA-C02 Question #706: Real Exam Question with Answer & Explanation
The correct answer is A: Create a global secondary index (GSI). Use Location as the partition key and RegistrationDate as. Creating a global secondary index (GSI) with Location as the partition key and RegistrationDate as the sort key enables efficient querying by location and registration date using the Query operation. This avoids costly scans and supports the required filtering.
Question
An application uses an Amazon DynamoDB table to manage user profiles. A UserID attribute is the primary key of the table. The table also includes columns named Username, EmailAddress, RegistrationDate, Location, and Status. The application needs to display a list of users from a specific location who registered after a specific date. Queries on the table must be optimized for efficiency. Which solution will meet these requirements?
Options
- ACreate a global secondary index (GSI). Use Location as the partition key and RegistrationDate as
- BUse the Scan operation to retrieve the specified users. Use a filter expression for a value in the
- CCreate a local secondary index (LSI). Use Location as the partition key and RegistrationDate as
- DUse the BatchGetItem operation with a filter on the RegistrationDate column for a value that is
Explanation
Creating a global secondary index (GSI) with Location as the partition key and RegistrationDate as the sort key enables efficient querying by location and registration date using the Query operation. This avoids costly scans and supports the required filtering.
Community Discussion
No community discussion yet for this question.