DEA-C01 Practice Question 66: Full Text Search DynamoDB Catalog
AWS Certified Data Engineer – Associate (DEA-C01) · Test 7 · question 6 of 10
A retailer keeps its product catalog in Amazon DynamoDB, which serves key-based lookups well. The business now wants a search box that supports free-text queries over product descriptions, ranks results by relevance, and reflects product updates in near real time. The team does not want to change how the catalog is written. Which approach meets these requirements?
Show answer and explanation
Answer:
Amazon OpenSearch Service runs OpenSearch, a *"search and analytics engine"*, as a managed cluster, and it offers *"integration with Amazon S3, Amazon Kinesis, and Amazon DynamoDB for loading streaming data into OpenSearch Service."* Changes made to the DynamoDB table (for example through DynamoDB Streams) are replicated into an index in near real time, and the application searches that index. The catalog's write path stays unchanged, and DynamoDB keeps serving key lookups (option D).
- A is wrong because an index on a key attribute supports equality and range conditions on that key. It cannot provide tokenized free-text matching or relevance ranking. - B is wrong because a Scan reads every item in the table and applies the filter afterward. It is slow and expensive on a large catalog and still offers no relevance ranking. - C is wrong because a nightly export makes search results up to a day old, which violates the near-real-time requirement. LIKE scans are also not relevance-ranked.
Reference: What is Amazon OpenSearch Service?