You are in charge of maintaining an Oracle database in RDS. The development team tells you that the database instance needs to communicate with a new S3 bucket. For example, it should be able to save the backup files to S3, and at the same time, it can fetch Oracle Data Pump files from the same bucket when required. To connect the database instance with the particular S3 bucket successfully, which options are the prerequisites? (Select TWO.)

Answer options:

A.Configure an IAM role with a policy that allows to read and write the S3 bucket objects. Associate the role with the RDS instance.
B.Create a parameter group that includes the parameter of the IAM S3 service role name. Attach the parameter group with the DB instance.
C.Configure a new DB subnet group. Link the DB instance with the subnet group.
D.For the new S3 bucket, ensure the Block Public Access settings are turned off. Enable the public access for the S3 bucket or add the S3 endpoint for the bucket.
E.Create an option group that includes the S3_INTEGRATION option. Associate the DB instance with the option group.

Correct Answer – A, E
About how to transfer files between RDS Oracle and S3, please refer to the reference in https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/oracle-s3-integration.html.
Option A is CORRECT: Because the IAM role is required to allow the DB instance to interact with the S3 bucket.
Option B is incorrect: Because parameter group is not a necessary condition for this scenario.
Option C is incorrect: Because a new subnet group is not required. The default subnet group also works.
Option D is incorrect: Because the S3 bucket does not need public access. The RDS and S3 can communicate with each other under the same VPC.Option E is CORRECT: Because an option group that includes the S3_INTEGRATION option should be attached with the DB instance. Check the below screenshot on how to add the S3_INTEGRATION option to the option group: