AWS Certified Data Engineer – Associate (DEA-C01) — Question 34

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?

Answer options

• A. STL_USAGE_CONTROL
• B. STL_ALERT_EVENT_LOG
• C. STL_QUERY_METRICS
• D. STL_PLAN_INFO

Correct answer: B

Explanation

The correct answer is B, as the STL_ALERT_EVENT_LOG table records alerts related to performance issues identified by the query optimizer. The other options do not specifically log anomalies or alerts about performance, making them unsuitable for this requirement.