An Amazon Redshift data warehouse team wants to detect anomalies that the query optimizer flags as potential performance problems. Which system table view should be used to log these optimizer-identified anomalies?
Choose an answer
Tap an option to check your answer.
Correct answer: STL_ALERT_EVENT_LOG.
Why this is the answer
The STLALERTEVENTLOG table records information about events that might indicate potential problems or anomalies within the Redshift cluster, including those identified by the query optimizer. This makes it the correct choice for detecting performance issues flagged by the optimizer. STLUSAGECONTROL tracks usage limits and control events, not performance anomalies. STLQUERYMETRICS provides detailed runtime metrics for queries, which can be used for performance analysis but doesn't specifically log optimizer-identified anomalies. STLPLANINFO contains information about query execution plans, useful for understanding how queries run but not for logging alerts.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed