TDVAN5 practice question 15 of 15

A group of batch queries that rely on QueryGrid to source data from a cloud Vantage system has failed and requires urgent investigation. Which…

Full set: 72 questions
A group of batch queries that rely on QueryGrid to source data from a cloud Vantage system has failed and requires urgent investigation. Which Viewpoint portlet should be used to initially investigate the reason for this problem? A group of batch queries that rely on QueryGrid to source data from a cloud Vantage system has failed and requires urgent investigation. Which Viewpoint portlet should be used to initially investigate the reason for this problem?
Answer options
A: Query Spotlight
B: Alert Viewer Correct answer
C: Productivity
D: Completed Queries
Correct Answer:
B. Alert Viewer
Explanation

The Alert Viewer portlet is the most appropriate starting point for this investigation. When a group of queries fails simultaneously, especially those dependent on an external system via QueryGrid, it strongly suggests a systemic issue rather than an error in each individual query. The Alert Viewer is designed to display system-level events, errors, and status changes. A failure in the QueryGrid connector, a network connectivity problem, or an issue with the remote cloud Vantage system would generate a system alert, providing the fastest path to identifying the root cause of the widespread failure.

Why Incorrect

A. Query Spotlight: This portlet is used for monitoring active, currently running queries. Since the batch queries have already failed, they will no longer be visible here.
C. Productivity: This portlet provides historical analysis of workload performance and trends over time. It is not designed for immediate, real-time troubleshooting of specific query failures.
D. Completed Queries: While this portlet (within Query Monitor) shows failed queries and their specific error codes, it is a secondary step. The initial investigation should check for a single systemic cause affecting the entire group, which is the function of the Alert Viewer.

References

1. Teradata® Viewpoint User Guide, 17.20 (B035-2206-017K), Chapter 5: Monitoring System Health and Status, "Alert Viewer". The guide states, "The Alert Viewer portlet displays alerts that have been set up in the Teradata system... Alerts are generated when system conditions meet or exceed thresholds, or when certain events occur." This confirms its role in flagging system-wide problems, such as a QueryGrid connector failure, which would be the most likely cause for a group of queries failing.

2. Teradata® Viewpoint User Guide, 17.20 (B035-2206-017K), Chapter 6: Monitoring Queries, "Query Spotlight". The documentation specifies, "Query Spotlight is a tool for monitoring the progress of queries while they are running on the database." This explicitly excludes queries that have already completed or failed.

3. Teradata® Viewpoint User Guide, 17.20 (B035-2206-017K), Chapter 6: Monitoring Queries, "Query Monitor". This section details how to view sessions by state, including those that are "Aborted/Error". While this allows viewing the error text for an individual failed query, the Alert Viewer is the primary tool for identifying a single event that caused a group of queries to fail.

Scroll to Top