
Ultimate access to all questions.
You are tasked with maintaining a data pipeline that processes customer data for a large e-commerce platform. The pipeline uses Amazon Redshift for data warehousing and AWS Glue for ETL jobs. Recently, the pipeline has been experiencing performance issues. What steps would you take to diagnose and improve the performance of this pipeline?
A
Increase the number of nodes in the Amazon Redshift cluster and monitor the performance using Amazon CloudWatch.
B
Reduce the frequency of the ETL jobs and use Amazon Macie to scan for sensitive data to optimize data handling.
C
Implement AWS CloudTrail to log all API calls and analyze the logs to identify bottlenecks.
D
Optimize the ETL scripts by using more efficient data transformations and parallel processing techniques, then monitor the performance using Amazon CloudWatch.