Skip to Content

Amazon SAA-C02: Solution to read data with sub-millisecond latency and run one-time queries on historical data.

By: Author Alex Lim

Posted on  - Last updated:

Categories Exam

Question

A company hosts a multiplayer gaming application on AWS. The company wants the application to read data with sub-millisecond latency and run one-time queries on historical data. Which solution will meet these requirements with the LEAST operational overhead?

A. Use Amazon RDS for data that is frequently accessed. Run a periodic custom script to export the data to an Amazon S3 bucket.
B. Store the data directly in an Amazon S3 bucket. Implement an S3 Lifecycle policy to move older data to S3 Glacier Deep Archive for long-term storage. Run one-time queries on the data in Amazon S3 by using Amazon Athena.
C. Use Amazon DynamoDB with DynamoDB Accelerator (DAX) for data that is frequently accessed. Export the data to an Amazon S3 bucket by using DynamoDB table export. Run one-time queries on the data in Amazon S3 by using Amazon Athena.
D. Use Amazon DynamoDB for data that is frequently accessed. Turn on streaming to Amazon Kinesis Data Streams. Use Amazon Kinesis Data Firehose to read the data from Kinesis Data Streams. Store the records in an Amazon S3 bucket.

Answer

C. Use Amazon DynamoDB with DynamoDB Accelerator (DAX) for data that is frequently accessed. Export the data to an Amazon S3 bucket by using DynamoDB table export. Run one-time queries on the data in Amazon S3 by using Amazon Athena.

Explanation

Based on the question, the company wants the application to read data with sub-millisecond latency and run one-time queries on historical data. The solution should also have the least operational overhead. Among the four options, C seems to be the most suitable one. Here’s why:

  • Option A uses Amazon RDS for data that is frequently accessed, but RDS is a relational database service that may not provide sub-millisecond latency for read operations. Also, running a periodic custom script to export the data to an Amazon S3 bucket may introduce additional operational overhead and complexity.
  • Option B stores the data directly in an Amazon S3 bucket, which may not provide sub-millisecond latency for read operations either. Also, implementing an S3 Lifecycle policy to move older data to S3 Glacier Deep Archive for long-term storage may not be necessary if the company only wants to run one-time queries on historical data.
  • Option C uses Amazon DynamoDB with DynamoDB Accelerator (DAX) for data that is frequently accessed. DynamoDB is a key-value and document database service that can provide consistent, single-digit millisecond performance at any scale. DAX is a fully managed, highly available, in-memory cache for DynamoDB that can improve read performance up to 10 times and reduce read latency to microseconds. Option C also exports the data to an Amazon S3 bucket by using DynamoDB table export, which is a feature that allows exporting DynamoDB table data to S3 without writing code or provisioning infrastructure. Option C also runs one-time queries on the data in Amazon S3 by using Amazon Athena, which is a serverless interactive query service that can analyze data in S3 using standard SQL. Option C seems to meet all the requirements with the least operational overhead.
  • Option D uses Amazon DynamoDB for data that is frequently accessed, which is similar to option C. However, option D also turns on streaming to Amazon Kinesis Data Streams, which is a feature that captures item-level modifications in any DynamoDB table and durably stores the data in a Kinesis data stream. Option D also uses Amazon Kinesis Data Firehose to read the data from Kinesis Data Streams and store the records in an Amazon S3 bucket. Option D may introduce additional operational overhead and complexity by using Kinesis Data Streams and Firehose, which may not be necessary for the company’s use case.

Therefore, based on my analysis, option C is the most suitable solution for this question.

Reference

Amazon AWS Certified Solutions Architect – Associate SAA-C02 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Amazon AWS Certified Solutions Architect – Associate SAA-C02 exam and earn Amazon AWS Certified Solutions Architect – Associate SAA-C02 certification.