Exam AWS Certified Database - Specialty topic 1 question 153 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 153
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company released a mobile game that quickly grew to 10 million daily active users in North America. The game's backend is hosted on AWS and makes extensive use of an Amazon DynamoDB table that is configured with a TTL attribute.
When an item is added or updated, its TTL is set to the current epoch time plus 600 seconds. The game logic relies on old data being purged so that it can calculate rewards points accurately. Occasionally, items are read from the table that are several hours past their TTL expiry.
How should a database specialist fix this issue?

A. Use a client library that supports the TTL functionality for DynamoDB.
B. Include a query filter expression to ignore items with an expired TTL.
C. Set the ConsistentRead parameter to true when querying the table.
D. Create a local secondary index on the TTL attribute.

Show Suggested Answer

Suggested Answer: B 🗳️

by toppic26 at Nov. 15, 2021, 4:27 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

toppic26

Highly Voted 3 years, 6 months ago

Answer is B https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/howitworks-ttl.html

upvoted 8 times

...

Satprave

Most Recent 2 years, 7 months ago

Selected Answer: B

B Items that have expired, but haven’t yet been deleted by TTL, still appear in reads, queries, and scans. If you do not want expired items in the result set, you must filter them out. To do this, use a filter expression that returns only items where the Time to Live expiration value is greater than the current time in epoch format. For more information, see Filter expressions for scan.

upvoted 2 times

...