Which S3 encryption, replication, and serverless SQL design has least overhead?
A company wants to move its application to a serverless solution. The serverless solution needs to analyze existing data and new data by using SQL. The company stores the data in an Amazon S3 bucket. The data must be encrypted at rest and replicated to a different AWS Region. Which solution will meet these requirements with the LEAST operational overhead?
Community Insight
The exam tests whether you can separate serverless SQL from Amazon RDS and recognize SSE-S3 plus CRR as lower overhead than building a new KMS multi-Region key bucket; the trap is assuming KMS multi-Region keys are mandatory for CRR.
This SAA-C03 question tests the least-overhead way to encrypt, cross-Region replicate, and SQL-query data in Amazon S3. It establishes that configuring CRR on the existing bucket with SSE-S3 and querying through Amazon Athena (C) avoids new-bucket migration and KMS key management.
Many learners pick A because they believe CRR requires KMS multi-Region keys, but SSE-S3-encrypted objects can be replicated with CRR and need no KMS key policy or multi-Region key administration.
Community Discussion (20 comments)
Comments & Corrections
No comments yet — spotted an error or have a note? Share it below.
Expert Analysis
Why the Answer Is Correct
Option C keeps the existing S3 bucket, so there is no new bucket creation or data reload. SSE-S3 provides encryption at rest with S3-managed keys, and CRR supports SSE-S3-encrypted objects without KMS key policy or multi-Region key management, which keeps operational overhead lowest. Amazon Athena is serverless and runs SQL directly over S3, satisfying the requirement to analyze both existing and new data. This combination best matches the question's explicit least-operational-overhead constraint.Why the Other Options Are Wrong
A adds a new bucket and a data-loading step, and SSE-KMS multi-Region keys add key administration even though CRR does not require them when SSE-S3 is used. B and D use Amazon RDS, which is not serverless and requires database capacity, schema, and ongoing management; RDS also does not directly query S3 objects with SQL. D layers KMS multi-Region keys on top of RDS, increasing both key and database overhead. Although C does not spell out the destination bucket, a CRR configuration necessarily names one; its key differentiators are no migration and SSE-S3.Community Comment Notes
LeonSauveterre's reasoning is sound: using the existing bucket helps "eliminate the need to create a new bucket and load data into it," and RDS is not serverless. FlyingHawk and dce7e4b focus on KMS multi-Region keys, but AWS documentation treats those as one supported pattern for SSE-KMS replication, not a mandatory requirement for all CRR. tch and yangbo correctly note that SSE-S3 is the default, simpler encryption choice; the key exam point is that SSE-S3 does not block cross-Region replication.Official Reference
Exam Strategy
When "least operational overhead" appears, first eliminate options that require new buckets, data reloads, or RDS management. Then confirm the remaining option uses a serverless query engine and an encryption method that CRR supports without extra key-policy work.
Frequently Asked Questions
Why doesn't CRR require KMS multi-Region keys with SSE-S3?
S3 CRR supports SSE-S3 objects and encrypts replicas with S3-managed keys, so no KMS key policy or multi-Region key administration is needed.
Why is Amazon RDS wrong for querying S3 data here?
RDS is a managed relational database, not a serverless query engine over S3, and it adds instance, schema, and database operations that Athena avoids.
Related Analysis
Practice All SAA-C03 Questions
Access 120 questions with complete answers and detailed explanations.
View Full SAA-C03 Practice Test →