Q31 — AWS DEA-C01 Ch.1

Question 31 of 100 | ← Chapter 1

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

Correct Answer: B. STL_ALERT_EVENT_LOG

Explanation

在AmazonRedshift中，STL_ALERT_EVENT_LOG这个系统表用于记录当查询优化器识别到可能表明存在性能问题的条件时产生的异常情况。A选项STL_USAGE_CONTROL主要用于控制资源使用。C选项STL_QUERY_METRICS提供有关查询的指标信息，但并非专注于性能异常的记录。D选项STL_PLAN_INFO涉及查询计划的信息。综上所述，选择B选项STL_ALERT_EVENT_LOG能够满足记录查询性能异常的需求。