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?

Question

Accepted Answer

A. Look for the terminated queries in the SVL_QLOG view.

Answer

B. Look for the terminated queries in the SVL_QUERY_REPORT view.

Answer

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

Answer

D. Use a federated query to find the terminated queries.

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…

Question

Options

How the community answered

Explanation

Topics

Community Discussion