How can the Administrator effectively throttle these stored procedures?
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...
Which query is producing this result?
An Administrator has been presented with these performance metrics from the DBQLOGTBL table for four queries: The Administrator needs to identify which query is suspected to be causing a full table scan or large redistribution. Which query is producing this result?A . QRY_D because of CPU SKEWB . QRY_C because...
Which action should the Administrator take?
An Administrator has been asked to improve the response time of the workloads in the tactical tier. Workloads are in all tiers of TASM. They are at CPU and I/O capacity, and they have AWT reserved for tactical. The Administrator begins by analyzing the data and the workload prioritization. Which...
Which resource is constrained?
A table that contains about two billion records is showing a bad response time for range-based queries on the order date column and frequently projects 10 out of 100 columns. The Administrator decides to convert the table to a column and row partitioned table. Which resource is constrained?A . I/OB...
Which backup strategy should be used?
An Administrator manages a Vantage system that is continually updated. The system is critical to the business and must be available as much as possible. The Administrator decides to use a backup strategy that will allow changes to tables while a backup is in progress. Which backup strategy should be...
What is the maximum payload size for CSV and JSON data formats that the NOS_READ function can read, when it is based on the LATIN character set?
What is the maximum payload size for CSV and JSON data formats that the NOS_READ function can read, when it is based on the LATIN character set?A . 16 MBB . 32 MBC . 2GBD . 8GBView AnswerAnswer: B Explanation: When using the NOS_READ function in Teradata to read data...
An Administrator is configuring an alert service on a Vantage system and must define threshold levels and triggers for the alerts
DRAG DROP An Administrator is configuring an alert service on a Vantage system and must define threshold levels and triggers for the alerts. Match the Administrator's portlet to the correct use definition. (Each answer is used once.) View AnswerAnswer:
Which action should be taken by the Administrator to assist this client?
A client is having many problems with a poorly written SQL. They have product joins running against large tables, and this is causing severe performance issues. The Administrator needs to help the client avoid the harm to the system that is being caused by running these queries. Which action should...
Which recommendation will help the merge step?
A customer is complaining that the creation of a large table in the lab environment is getting stuck in the merge step. The customer is using the following command to create the table: CREATE TABLE ... AS (SELECT * ...) WITH DATA Which recommendation will help the merge step?A ....
Which workload management feature should the Administrator use?
An Administrator needs to enforce a security policy which prohibits the use of an application's username from being used by certain query clients. Which workload management feature should the Administrator use?A . Flex ThrottleB . Utility SessionC . ExceptionD . FilterView AnswerAnswer: D Explanation: Filters in Teradata workload management allow...