Answer-first summary for fast verification
Answer: Increase the number of nodes in the Amazon Redshift cluster and monitor the performance using Amazon CloudWatch.
Increasing the number of nodes in the Amazon Redshift cluster can improve the performance of the data pipeline by distributing the workload more effectively. Monitoring the performance using Amazon CloudWatch allows for real-time adjustments and ensures that any improvements are sustained.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
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.