Answer-first summary for fast verification
Answer: Use Amazon DynamoDB with a composite key of location ID and timestamp for efficient data access.
The most cost-effective solution to meet these requirements is to use Amazon DynamoDB. DynamoDB provides low-latency access to real-time and historical data and can scale seamlessly without impacting performance or causing downtime. By creating a composite key using the location ID and timestamp columns, you can efficiently filter and retrieve customer data. Additionally, DynamoDB is designed to handle high demand and usage spikes without administrative overhead, making it the best fit for this use case.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A company has deployed smart meters to measure and transmit power usage data every minute to a central system. The system must store location ID and timestamp in a database, provide real-time and historical data access with low latency, and scale without performance degradation or downtime. Identify the most cost-effective solution.
A
Utilize Amazon RDS, indexing location ID and timestamp for data retrieval.
B
Use Amazon DynamoDB with a composite key of location ID and timestamp for efficient data access.
C
Leverage Amazon ElastiCache for Redis with a SortedSet structured by location ID and timestamp for quick data filtering.
D
Employ Amazon S3 for data storage, partitioned by location ID and timestamp, and Amazon Athena for querying customer data.
No comments yet.