CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. TeraData
  5. TDVAN5

Free TDVAN5 Exam Braindumps (page: 9)

Page 8 of 19
PDF with 72 Questions

Users are complaining that queries in their workload are taking too long. The Administrator suspects that workload management may be throttling the queries.
Which table should be analyzed to confirm this suspicion?

  1. ResUsageSps
  2. ResUsageSawt
  3. DBQLogTbl
  4. DBQLStepTbl

Answer(s): B

Explanation:

The ResUsageSawt table captures information related to AMP Worker Task (AWT) usage and workload throttling. If queries are being throttled due to workload management, this table will provide relevant data, including details about tasks that may be waiting due to AWT limits or other resource constraints.
Option A (ResUsageSps) focuses on stored procedure statistics and may not provide direct insight into query throttling.

Option C (DBQLogTbl) logs query-level statistics but does not directly capture information about throttling due to workload management.
Option D (DBQLStepTbl) contains detailed information about query execution steps but, like DBQLogTbl, it does not provide information about throttling.



The Administrator has just created a new database object on a Vantage system.
Which privilege is NOT automatically granted to that database on itself?

  1. CREATE AUTHORIZATION
  2. CREATE MACRO
  3. CREATE PROCEDURE
  4. CREATE TRIGGER

Answer(s): A

Explanation:

When a new database object is created in Teradata Vantage, certain object creation privileges (such as CREATE MACRO, CREATE PROCEDURE, and CREATE TRIGGER) are typically granted automatically to the database or user who created the object.
However, the CREATE AUTHORIZATION privilege, which allows a user to create an authorization object (used for external authentication to external systems, such as a cloud storage service), is not automatically granted. This privilege requires an explicit grant.



A suite of development jobs have been mistakenly executed at a time when a long-running critical job is being run. The business has decided to allow the development jobs to run if they do not block the critical job. An Administrator has been tasked with recording any delays experienced throughout the execution of this critical job and to abort any of the development jobs if they block it.
Which Viewpoint portlet could the Administrator use for this purpose?

  1. Query Session
  2. Query Monitor
  3. Show Locks
  4. Lock Display

Answer(s): D

Explanation:

The Lock Display portlet in Teradata Viewpoint provides detailed information about database locks. It allows the Administrator to monitor if any queries or jobs are causing lock contention that could block the critical job. Using this portlet, the Administrator can see if the development jobs are creating locks that delay or block the critical job. If such blocking is detected, the Administrator can take action, such as aborting the development jobs.
Option A (Query Session) shows information about active sessions but is not focused on lock contention and blocking.
Option B (Query Monitor) allows the monitoring of query performance and workloads but doesn't specifically focus on lock contention.
Option C (Show Locks) can display current lock information, but Lock Display provides a more comprehensive tool for monitoring and managing lock-related issues.



An Administrator notices that a system appears to be near capacity and needs to access a dictionary to assess that AMPs are entering into flow control.
Which dictionary should be accessed for this purpose?

  1. DBC.SessionInfoV
  2. DBC.ResUsageSawt
  3. DBAMPUsage
  4. DBC.ResUsageSldv

Answer(s): B

Explanation:

The DBC.ResUsageSawt view provides detailed information about the resource usage of AMP Worker Tasks (AWTs), including whether AMPs are experiencing flow control. Flow control occurs when AMPs are overwhelmed and need to throttle the workload, and this view tracks metrics related to AWT usage and system resource contention, which would indicate when AMPs are under strain. Option A (DBC.SessionInfoV) provides information about current user sessions but does not provide insights into AMP-level flow control or resource usage. Option C (DBC.AMPUsage) provides general statistics about AMP usage but doesn't give detailed information about flow control or AWT usage.
Option D (DBC.ResUsageSldv) tracks statistics related to logical disk usage but isn't focused on AMP flow control.






Post your Comments and Discuss TeraData TDVAN5 exam with other Community members:

TDVAN5 Discussions & Posts