A logistics enterprise is designing a real-time global shipment tracking system. The system must process high-frequency status updates (OLTP NoSQL) from delivery agents across two primary regions: and . Read and write operations must be supported locally in both regions with sub- latency, automatically resolving write conflicts based on the latest physical timestamp. The disaster recovery requirements specify a Recovery Time Objective (RTO) of less than and a Recovery Point Objective (RPO) of less than . Furthermore, the raw tracking telemetry must be exported hourly to an Amazon S3 bucket located in a centralized analytics AWS account within a separate AWS organization. Corporate security policies require all data at rest to be encrypted. To prevent unauthorized access, the encryption keys must support cross-account policy delegation, and the destination S3 bucket must enforce secure transport. Which database and storage architecture meets these requirements with the lowest operational complexity?
- Deploy Amazon DynamoDB global tables replicated between and , encrypted using regional Customer Managed Keys (CMKs) in AWS KMS. Configure an Amazon EventBridge Scheduler rule to trigger an AWS Lambda function hourly that reads from DynamoDB and writes to the centralized S3 bucket. Ensure the S3 bucket in the analytics account is encrypted using a Customer Managed Key (CMK) owned by the analytics account with a key policy allowing cross-account access, and its bucket policy denies `s3:PutObject` requests without secure transport or the correct KMS encryption headers.Answer
- BDeploy Amazon Aurora Global Database PostgreSQL with write forwarding enabled from to . Encrypt the database clusters using default AWS-managed KMS keys (`aws/rds`). Configure Aurora Auto Scaling on the reader instances in the secondary region to handle scaling and write latency. Export data hourly to the centralized S3 bucket encrypted with the AWS-managed KMS key (`aws/s3`) by delegating cross-account access through an IAM role policy in the source account.
- CDeploy a single-region Amazon DynamoDB table in encrypted with a Customer Managed Key (CMK). Configure Amazon S3 Cross-Region Replication (CRR) to replicate hourly table backups to to implement a Pilot Light disaster recovery strategy. Run a cron job on an Amazon EC2 instance to export the DynamoDB table data hourly, encrypt it using the default AWS-managed S3 key (`aws/s3`), and transfer it to the S3 bucket in the centralized analytics account.
- DDeploy Amazon DynamoDB global tables replicated between and , encrypted using the default AWS-managed KMS key (`aws/dynamodb`). Configure a centralized S3 bucket in the analytics account encrypted with the AWS-managed KMS key (`aws/s3`). Configure an AWS Glue ETL job to run hourly, fetching data from DynamoDB and writing to the S3 bucket. Add a cross-account IAM policy to the Glue execution role in the source account to allow access to the target S3 bucket and its AWS-managed KMS key.