A company is migrating a large on-premises NoSQL database that stores SAP-related data to Amazon DynamoDB as part of their AWS SAP environment. The database has tables with uneven access patterns, and some items are accessed infrequently but must be retained for compliance. The company wants to optimize costs without sacrificing performance. Which THREE strategies should the solutions architect recommend? (Choose THREE.)
Trap 1: Use SAP HANA's built-in TTL feature to automatically delete expired…
Incorrect. SAP HANA's TTL would delete data, violating compliance retention requirements.
Trap 2: Disable auto scaling for the SAP HANA EC2 instances to avoid…
Incorrect. Disabling auto scaling can lead to over-provisioning or under-provisioning, increasing costs or hurting performance.
- A
Use Amazon S3 Standard-Infrequent Access (S3 Standard-IA) to store infrequently accessed SAP HANA backup files.
Correct. S3 Standard-IA provides cost-effective storage for infrequently accessed backup files with fast retrieval.
- B
Use SAP HANA's built-in TTL feature to automatically delete expired compliance data.
Why wrong: Incorrect. SAP HANA's TTL would delete data, violating compliance retention requirements.
- C
Use Amazon ElastiCache for Memcached to cache frequently accessed database query results, reducing read load.
Correct. ElastiCache caches query results, reducing read load on DynamoDB and improving performance.
- D
Disable auto scaling for the SAP HANA EC2 instances to avoid unpredictable costs.
Why wrong: Incorrect. Disabling auto scaling can lead to over-provisioning or under-provisioning, increasing costs or hurting performance.
- E
Use Amazon S3 lifecycle policies to transition older compliance data to Amazon S3 Glacier for long-term retention at low cost.
Incorrect. S3 lifecycle policies to Glacier are for archival, but the data needs to be accessed occasionally; Glacier retrieval times are too slow.