Amazon Web Services SAP-C02 Exam With Confidence Using Practice Dumps

Option B is correct because S3 conditional writes using If-Match and ETags provide optimistic concurrency control. The application reads the object, obtains the current ETag, and submits the update only if the object still has that ETag. If another user’s write completed first, the ETag changes and the later write fails instead of overwriting the first successful update. A Lambda function can detect failed S3 write responses and send retry or conflict-resolution messages to Amazon SQS. Option A enables versioning, which preserves object history but does not prevent conflicting writes from succeeding. Option C misuses Object Lock, which is designed for retention and write protection, not collaborative editing. Option D adds distributed locking and batch processing complexity and is not appropriate for real-time document edits.

D is correct becauseRDS for PostgreSQLsupportsforeign data wrappers (FDW)that allow querying remote Oracle databases. WithAWS Schema Conversion Tool (SCT)andDatabase Migration Service (DMS), schema and data can be migrated effectively.AWS Direct Connectensures secure, private connectivity to on-prem databases. Cron jobs can be run via EventBridge or external orchestration.

A doesn ' t support relational/spatial querying.

B doesn’t support FDW or spatial types.

C introduces unnecessary complexity.

With the DeletionPolicy attribute you can preserve or (in some cases) backup a resource when its stack is deleted. You specify a DeletionPolicy attribute for each resource that you want to control. If a resource has no DeletionPolicy attribute, AWS CloudFormation deletes the resource by default. To keep a resource when its stack is deleted, specify Retain for that resource. You can use retain for any resource. For example, you can retain a nested stack, Amazon S3 bucket, or EC2 instance so that you can continue to use or modify those resources after you delete their