AWS Certified Database – Specialty — Question 213

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?

Answer options

• 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.

Correct answer: A

Explanation

The correct answer is A because the SVL_QLOG view contains information about queries that have been executed, including those that were terminated. The other options are incorrect as the SVL_QUERY_REPORT view does not specifically track terminated queries, writing a scalar SQL user-defined function is unnecessary for this task, and federated queries are not relevant to retrieving this information.