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?

Topic #: - All AWS Certified Database - Specialty Questions

A. Look for the terminated queries in the SVL_QLOG view.
B. Look for the terminated queries in the SVL_QUERY_REPORT view.
C. Write a scalar SQL user-defined function to find the terminated queries.
D. Use a federated query to find the terminated queries.

- Awsexamhub website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Suggested Answer:

Reference Material:

Suggested Answer:

Reference Material:

Share this post

Join the Discussion