What should a database specialist do to obtain this information?

By:
In: DBS-C01
Tagged:
With: 2 Comments
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?

Look for the terminated queries in the SVL_QLOG view.

Look for the terminated queries in the SVL_QUERY_REPORT view.

Write a scalar SQL user-defined function to find the terminated queries.

Use a federated query to find the terminated queries.

Explanations:

The SVL_QLOG view contains log data for queries, including those that were terminated. It tracks query executions, including errors or terminations due to maintenance activities.

The SVL_QUERY_REPORT view provides detailed information about query execution times, but it does not contain information about terminated queries specifically.

Writing a scalar SQL user-defined function is not necessary to find terminated queries. The required information is already available in the system views like SVL_QLOG.

A federated query is used to query data across multiple databases, but it is not applicable for finding terminated queries in the context of a single Redshift cluster.

2026-03-30

2 Comments

  1. Judy
    Author

    I evaluate that the answer is:
    Look for the terminated queries in the SVL_QLOG view.

  2. Judith
    Author

    I measure that the answer is:
    Look for the terminated queries in the SVL_QLOG view.

Leave a Reply

Your email address will not be published. Required fields are marked *

thirteen + twelve =