DEA-C01 Question 288
Select 4A company uses Amazon Redshift as their data warehouse and has implemented a sophisticated ETL pipeline that loads data into Redshift clusters daily. The data engineering team wants to monitor the ETL pipeline and the Redshift cluster to ensure operational efficiency, detect anomalies, and optimize costs. Which combination of actions should the team take to achieve this?
- A
Enable Amazon Redshift Enhanced VPC Routing and monitor network traffic using VPC Flow Logs.
- B
Set up Amazon CloudWatch metrics and alarms to monitor Redshift cluster performance metrics like CPU utilization, disk space usage, and query performance.
- C
Use Amazon Redshift Advisor to get recommendations on optimizing table design, distribution keys, and sort keys.
- D
Implement AWS CloudTrail to monitor API activity and log all ETL pipeline interactions with Amazon Redshift.
- E
Schedule regular automatic table vacuuming and analyze commands to manage table statistics and reclaim storage space in Redshift.
Show answer and explanation
Correct answers: B, C, D, E
Explanation
To ensure operational efficiency and proper monitoring of both the ETL pipeline and the Redshift cluster, it’s important to use tools like CloudWatch for monitoring metrics, Redshift Advisor for optimization recommendations, and CloudTrail for auditing API interactions. Regular maintenance tasks like vacuuming and analyzing tables also ensure that the cluster remains performant. While Enhanced VPC Routing improves network traffic routing, it does not directly contribute to monitoring or operational support of the ETL pipeline or Redshift cluster.
- A. Incorrect.
This option is incorrect because Enhanced VPC Routing is used to route traffic between your Redshift cluster and other AWS services through a VPC endpoint. While it improves data routing, it does not directly help monitor ETL or Redshift cluster performance.
- B. Correct.
This option is correct because CloudWatch provides critical metrics and alarms that allow the team to monitor Redshift performance, detect anomalies, and take corrective actions in real-time.
- C. Correct.
This option is correct because Redshift Advisor provides actionable recommendations for optimizing the cluster's performance, which is crucial for operational efficiency.
- D. Correct.
This option is correct because CloudTrail logs API activity, making it useful for monitoring and auditing all interactions between the ETL pipeline and Redshift.
- E. Correct.
This option is correct because regular vacuuming and analyze commands help maintain table performance and storage efficiency in Redshift, which is an important part of operational support.