Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 40 discussion

B STL_ALERT_EVENT_LOG records any alerts/notifications related to queries or user-defined performance thresholds. This would capture optimizer alerts about potential performance issues. STL_PLAN_INFO provides detailed info on execution plans. The optimizer statistics and warnings provide insight into problematic query plans. STL_USAGE_CONTROL limits user activity but does not log anomalies. STL_QUERY_METRICS has execution stats but no plan diagnostics. By enabling alerts and checking STL_ALERT_EVENT_LOG and STL_PLAN_INFO, the data engineer can best detect and troubleshoot queries flagged by the optimizer as problematic before they impair performance. This meets the requirement to catch potential long running queries.

https://docs.aws.amazon.com/redshift/latest/dg/r_STL_ALERT_EVENT_LOG.html

Control table is related to usage control metrics and doesn't focus on performance issues or anomalies related to query optimization. It's more about usage limits and controls.

this table records alerts that are generated by the Amazon Redshift system when it detects certain conditions that might indicate performance issues. These alerts are triggered by the query optimizer when it detects suboptimal query plans or other issues that could affect performance.

https://docs.aws.amazon.com/redshift/latest/dg/cm_chap_system-tables.html STL_ALERT_EVENT_LOG table view to meet this requirement. This system table in Amazon Redshift is designed to record anomalies when a query optimizer identifies conditions that might indicate performance issues