DBS-C01 Monitoring and Troubleshooting Practice Question
A company is using Amazon Redshift for data warehousing. The operations team notices that queries are running slower than usual. Which Amazon Redshift system view should be used to identify the queries that are consuming the most resources?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
STL_QUERY
STL_QUERY (option B) is the correct system view because it stores detailed information about query execution, including resource consumption. This allows the operations team to identify which queries are consuming the most resources. The other options are incorrect: SVV_VACUUM_PROGRESS (option A) shows the progress of vacuum operations, not query performance. PG_TABLE_DEF (option C) shows table definitions. STV_TBL_PERM (option D) shows table permissions, not query resource usage.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
SVV_VACUUM_PROGRESS
Why it's wrong here
SVV_VACUUM_PROGRESS shows vacuum progress, not query consumption.
- ✓
STL_QUERY
Why this is correct
STL_QUERY records all query execution details, including duration and resource usage.
- ✗
PG_TABLE_DEF
Why it's wrong here
PG_TABLE_DEF shows table schema, not performance.
- ✗
STV_TBL_PERM
Why it's wrong here
STV_TBL_PERM shows permissions, not query performance.
Go deeper
Related to this question
About these practice questions
This DBS-C01 question is part of Courseiva's 1,663-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DBS-C01 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DBS-C01 exam.