Crucial Exams

AWS Certified Solutions Architect Professional SAP-C02 Practice Question

A manufacturing company ingests temperature and vibration readings from 50,000 factory-floor sensors at a rate of 100,000 records per second. Engineers need dashboard queries with sub-second latency for the most recent 15 minutes of data and daily analytics jobs that examine the past 12 months. The operations team does not want to provision or manage database servers and wants to keep storage costs low for data that is rarely queried after the first week.

Which modernization approach best meets these requirements while aligning with AWS's purpose-built database strategy?

  • Move the data to Amazon Aurora PostgreSQL, create daily partitions by date, add read replicas for dashboards, and archive month-old partitions to Amazon S3 with custom scripts.

  • Migrate the workload to Amazon Timestream and set a 7-day memory-store and 365-day magnetic-store retention policy.

  • Stream the sensor data into Amazon Redshift Serverless via Amazon Kinesis Data Firehose and use Short Query Acceleration (SQA) for dashboards.

  • Replace PostgreSQL with Amazon DynamoDB using deviceId as the partition key and timestamp as the sort key, enable TTL for 7-day expiry, and query data with PartiQL.

AWS Certified Solutions Architect Professional SAP-C02
Accelerate Workload Migration and Modernization
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot