SAP-C02 · Question #592
SAP-C02 Question #592: Real Exam Question with Answer & Explanation
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.
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
Explanation
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.
Common mistakes.
- A. 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.
- C. 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.
- D. 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
Reference. https://docs.aws.amazon.com/AmazonElastiCache/latest/red-ug/WhatIs.html
Community Discussion
No community discussion yet for this question.