
Answer-first summary for fast verification
Answer: STL_ALERT_EVENT_LOG
The `STL_ALERT_EVENT_LOG` system table in Amazon Redshift records anomalies and alerts generated when the query optimizer identifies conditions that might indicate performance issues. It is the appropriate system table for investigating and tracking down queries that may be running inefficiently.
Author: Ritesh Yadav
Ultimate access to all questions.
Question 13 A data engineering team is using an Amazon Redshift data warehouse for operational reporting. The team wants to prevent performance issues that might result from long-running queries. A data engineer must choose a system table in Amazon Redshift to record anomalies when a query optimizer identifies conditions that might indicate performance issues. Which table views should the data engineer use to meet this requirement?
A
STL_USAGE_CONTROL
B
STL_ALERT_EVENT_LOG
C
STL_QUERY_METRICS
D
STL_PLAN_INFO
No comments yet.