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.
I evaluate that the answer is:
Look for the terminated queries in the SVL_QLOG view.