nerdexam
AmazonAmazon

DBS-C01 · Question #300

DBS-C01 Question #300: Real Exam Question with Answer & Explanation

Sign in or unlock DBS-C01 to reveal the answer and full explanation for question #300. The question stem and answer options stay visible for context.

Submitted by kavita_s· Mar 6, 2026Monitoring and Troubleshooting

Question

A company uses an Amazon Redshift cluster to support its business intelligence (BI) team. The cluster has a maintenance window that overlaps with some business report jobs that run long- running queries on the cluster. During a recent maintenance window, the cluster went offline and restarted for an update. The BI team wants to know which queries were terminated during the maintenance window. What should a database specialist do to obtain this information?

Options

  • ALook for the terminated queries in the SVL_QLOG view.
  • BLook for the terminated queries in the SVL_QUERY_REPORT view.
  • CWrite a scalar SQL user-defined function to find the terminated queries.
  • DUse a federated query to find the terminated queries.

Unlock DBS-C01 to see the answer

You've previewed enough free DBS-C01 questions. Unlock DBS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Amazon Redshift#query logging#terminated queries#system views
Full DBS-C01 PracticeBrowse All DBS-C01 Questions