AWS Certified Developer Associate DVA-C02 Practice Question
When architecting a table in Amazon DynamoDB to catalog customer interactions that occur at various points in time, with the necessity to retrieve entries based on individual customer and specific date ranges, what key schema should the developer implement to support this access pattern efficiently?
Implement a single unique identifier for all interactions without additional keys.
Utilize only the time parameter of the interactions as the table's partition key without considering customer-specific sorting.
Design the table with a partition element for individual customer reference and a sort element capturing the time aspect of interactions.
Rely solely on the customer reference for the table's partition key without incorporating a sort element.
The developer should employ a composite primary key with two elements: a partition element that represents the individual customer, and a sort element that aligns with the chronological aspect of the interactions. This approach enables the table to isolate data per customer while allowing sorted and range-based retrieval within the confines of each customer's data set. A design with a singular identifier disregards the query needs by customer and date. A primary key based solely on the customer element would fail to account for multiple interactions and lead to poor distribution of data, whereas focusing on chronological elements alone could lead to similarly skewed data distribution due to concurrent interactions across customers.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is a composite primary key in DynamoDB?
Open an interactive chat with Bash
Why is it inefficient to use a single unique identifier as a key for DynamoDB?
Open an interactive chat with Bash
How does using a partition key and sort key improve query performance?
Open an interactive chat with Bash
AWS Certified Developer Associate DVA-C02
Development with AWS Services
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .