Exam AWS Certified Database - Specialty topic 1 question 291 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 291
Topic #: 1

[All AWS Certified Database - Specialty Questions]

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?

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.

Show Suggested Answer

Suggested Answer: A 🗳️

by rdiaz at March 26, 2023, 4:10 p.m.

Disclaimers:

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

Comments

Submit Cancel

rdiaz

Highly Voted 2 years, 3 months ago

Selected Answer: A

https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_QLOG.html

upvoted 5 times

Mintwater

2 years, 3 months ago

table column - abported: " If a query was stopped by the system or canceled by the user, this column contains 1. If the query ran to completion, this column contains 0. Queries that are canceled for workload management purposes and subsequently restarted also have a value of 1 in this column."

upvoted 2 times

...

MultiAZ

Most Recent 1 year, 6 months ago

Selected Answer: A

SVL_QLOG view

upvoted 1 times

...

Pranava_GCP

1 year, 10 months ago

Selected Answer: A

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

upvoted 2 times

...

backbencher2022

2 years, 3 months ago

Selected Answer: A

A is the correct option. We can query SVL_QLOG table to check for aborted queries select query, elapsed, trim(label) querylabel from svl_qlog where aborted=1;

upvoted 2 times

...