Crucial Exams

AWS Certified Solutions Architect Professional SAP-C02 Practice Question

A global e-commerce company is redesigning its product-catalog service. The new architecture must:

  1. Sustain up to 500 000 writes per second during vendor bulk uploads.
  2. Return catalog items with single-digit-millisecond latency to web and mobile clients.
  3. Let analysts run complex ad-hoc SQL queries across the entire catalog once per hour without affecting the transactional workload.
  4. Minimize operational overhead and ongoing cost.

Which approach will meet these requirements MOST effectively?

  • Store the catalog in sharded Amazon DocumentDB clusters. Use AWS Glue jobs to copy the data hourly to Amazon S3 and query it with Amazon Redshift Spectrum.

  • Store the catalog in Amazon DynamoDB using on-demand capacity. Enable point-in-time recovery and schedule hourly DynamoDB table exports to Amazon S3. Analysts query the exported data in S3 with Amazon Athena.

  • Deploy Amazon Aurora MySQL with provisioned writer and multiple read replicas. Take hourly automated snapshots, load them into Amazon Redshift with AWS DMS, and let analysts query the Redshift cluster.

  • Persist catalog documents in Amazon OpenSearch Service with UltraWarm storage. Use the OpenSearch SQL plugin for both transactional reads and analytic queries.

AWS Certified Solutions Architect Professional SAP-C02
Design for New Solutions
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