nerdexam
Amazon

SAP-C02 · Question #592

A company wants to migrate its on-premises application to AWS. The database for the application stores structured product data and temporary user session data. The company needs to decouple the…

The correct answer is B. Create an Amazon RDS DB instance to host the product data. Configure a read replica for the DB. The company needs to decouple structured product data from temporary user session data, provide cross-region disaster recovery, and achieve the highest performance, especially for session data.

Submitted by valeria.br· Mar 6, 2026Migrate Workloads and Modernize Solutions

Question

A company wants to migrate its on-premises application to AWS. The database for the application stores structured product data and temporary user session data. The company needs to decouple the product data from the user session data. The company also needs to implement replication in another AWS Region for disaster recovery. Which solution will meet these requirements with the HIGHEST performance?

Options

  • ACreate an Amazon RDS DB instance with separate schemas to host the product data and the
  • BCreate an Amazon RDS DB instance to host the product data. Configure a read replica for the DB
  • CCreate two Amazon DynamoDB global tables. Use one global table to host the product data. Use
  • DCreate an Amazon RDS DB instance to host the product data. Configure a read replica for the DB

How the community answered

(56 responses)
  • A
    5% (3)
  • B
    82% (46)
  • C
    2% (1)
  • D
    11% (6)

Why each option

The company needs to decouple structured product data from temporary user session data, provide cross-region disaster recovery, and achieve the highest performance, especially for session data.

ACreate an Amazon RDS DB instance with separate schemas to host the product data and the

Using separate schemas within the same RDS instance for session data will not provide the "HIGHEST performance" compared to a dedicated in-memory cache like ElastiCache.

BCreate an Amazon RDS DB instance to host the product data. Configure a read replica for the DBCorrect

An Amazon RDS DB instance is suitable for structured product data with a cross-region read replica for disaster recovery, while Amazon ElastiCache for Redis, an in-memory data store, provides the highest performance and lowest latency for temporary user session data, effectively decoupling the data types.

CCreate two Amazon DynamoDB global tables. Use one global table to host the product data. Use

While Amazon DynamoDB global tables offer decoupling and cross-region replication, ElastiCache for Redis generally provides lower latency and higher throughput for temporary session data, making it a better fit for the "HIGHEST performance" requirement for this specific data type.

DCreate an Amazon RDS DB instance to host the product data. Configure a read replica for the DB

Amazon DynamoDB is a high-performance database, but for temporary, high-volume user session data, an in-memory store like Amazon ElastiCache for Redis often delivers superior performance characteristics, especially concerning latency, thereby not being the *MOST* performant option.

Concept tested: Database selection, disaster recovery, performance optimization

Source: https://docs.aws.amazon.com/AmazonElastiCache/latest/red-ug/WhatIs.html

Community Discussion

No community discussion yet for this question.

Full SAP-C02 Practice