DEA-C01 · Question #17
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
The correct answer is B. STL_ALERT_EVENT_LOG. 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 iss
Question
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?
Options
- ASTL_USAGE_CONTROL
- BSTL_ALERT_EVENT_LOG
- CSTL_QUERY_METRICS
- DSTL_PLAN_INFO
How the community answered
(50 responses)- A2% (1)
- B90% (45)
- C6% (3)
- D2% (1)
Explanation
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.
Topics
Community Discussion
No community discussion yet for this question.