nerdexam
Amazon

DEA-C01 · Question #294

A company needs a solution to store and query product data that has variable attributes. The solution must support unpredictable and high-volume queries with single-digit millisecond latency, even…

The correct answer is A. Use an Amazon DynamoDB table with on-demand capacity to store product data. Store products. Amazon DynamoDB with on-demand capacity is designed to handle unpredictable, high-volume request patterns and sudden traffic spikes while maintaining single-digit millisecond latency. Using Product ID as the table’s primary key enables efficient item retrieval by the primary…

Data Store Management

Question

A company needs a solution to store and query product data that has variable attributes. The solution must support unpredictable and high-volume queries with single-digit millisecond latency, even during sudden traffic spikes. The solution must retrieve items by a primary identifier named Product ID. The solution must allow flexible queries by secondary attributes named Category and Brand. Which solution will meet these requirements?

Options

  • AUse an Amazon DynamoDB table with on-demand capacity to store product data. Store products
  • BUse Amazon Aurora with a Multi-AZ deployment to store product data. Use read replicas. Create
  • CUse an Amazon OpenSearch Serverless cluster with dynamic scaling to store product data. Index
  • DUse Amazon ElastiCache (Redis OSS) and Amazon S3 to store product data. Use Amazon

How the community answered

(20 responses)
  • A
    85% (17)
  • B
    5% (1)
  • D
    10% (2)

Explanation

Amazon DynamoDB with on-demand capacity is designed to handle unpredictable, high-volume request patterns and sudden traffic spikes while maintaining single-digit millisecond latency. Using Product ID as the table’s primary key enables efficient item retrieval by the primary identifier, and global secondary indexes on Category and Brand provide flexible, low-latency queries on those secondary attributes.

Topics

#DynamoDB#NoSQL#Database Selection#Scalability

Community Discussion

No community discussion yet for this question.

Full DEA-C01 Practice