
Ultimate access to all questions.
A company is utilizing an Amazon Aurora PostgreSQL DB cluster for their applications within a single AWS Region. The company's database team requires comprehensive monitoring of all data activities across all databases. Which of the following solutions would effectively achieve this objective?
A
Configure an AWS Database Migration Service (AWS DMS) change data capture (CDC) task, designating the Aurora DB cluster as the source and Amazon Kinesis Data Firehose as the target. Utilize Kinesis Data Firehose to transfer the data into an Amazon OpenSearch Service cluster for detailed analysis.
B
Initiate a database activity stream on the Aurora DB cluster to record the activity stream within Amazon EventBridge. Set up an AWS Lambda function as the target for EventBridge events. Develop the Lambda function to decrypt the EventBridge messages and disseminate all database activities to Amazon S3 for subsequent analysis.
C
Establish a database activity stream on the Aurora DB cluster to transmit the activity stream to an Amazon Kinesis data stream. Set up Amazon Kinesis Data Firehose to ingest the Kinesis data stream and dispatch the data to Amazon S3 for subsequent analysis.
D
Set up an AWS Database Migration Service (AWS DMS) change data capture (CDC) task, identifying the Aurora DB cluster as the source and Amazon Kinesis Data Firehose as the target. Employ Kinesis Data Firehose to load the data into an Amazon Redshift cluster. Execute queries on the Amazon Redshift data to ascertain database activities on the Aurora database.