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 questionsThe 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.
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.
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.
Keep practicing
Take the free TDVAN5 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other TDVAN5 practice questions
- Question 1Which description accurately characterizes the use of external authentication for Vantage?
- Question 2An Administrator needs to provide end users access to data in a Native Object Store using…
- Question 3There is corruption in a table in the DBC database. Which action should the Administrator…
- Question 4A Vantage customer is using the Hive Connector in QueryGrid to access a foreign server an…
- Question 5A Vantage instance includes the following four databases: Tables Database contains base t…
- Question 6Which benefit is achieved by creating profiles?
