BATCH_USER submits stored procedures, utility jobs, and other requests. All BATCH_USER work classifies into workload WD-Batch based on username criterion.System performance has slowed due to AWT exhaustion during the batch window. The Administrator determined the AWT exhaustion is due to high concurrency of stored procedure calls from BATCH_USER.How can the Administrator effectively throttle these stored procedures?
An application is consuming very high I/O on Teradata Vantage. The Administrator has been asked to identify the queries that are consuming more than 100 million IOs and are suspected of completing Full Table Scans or Large Redistribution.Which metrics should be examined for high values to identify the queries?
On a Vantage system, the data load process has recently become much slower than normal and is now running for two hours in low concurrency. During the time the process is running, theAdministrator measured the following average values from ResUsage:System CPU busy = 75%WIO = 25%Inter-AMP parallelism = 90%Average BYNET usage = 10%Which resource is most constrained?
An Administrator has set up security constraints on columns holding sensitive data through the use of profiles. A user, with an appropriate profile, then issues a select against this sensitive data.Which type of privilege is being used?
How can an Administrator monitor the data volume that is transferred for a Data Mover job via Viewpoint?
What is a use case for Data Mover?
