Answer-first summary for fast verification
Answer: 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.
Option B is the correct answer. Starting a database activity stream on the Aurora DB cluster and capturing the activity stream in Amazon EventBridge offers seamless integration. EventBridge's powerful filtering capabilities allow selective monitoring of specific events or patterns. Additionally, it provides flexible delivery, with the ability to trigger AWS Lambda functions that can decrypt EventBridge messages and store all database activities in Amazon S3 for further analysis. This serverless architecture reduces operational overhead and S3 provides cost-effective storage for long-term analysis.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
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.