- All Exams Instant Download
What should the Administrator use to assist this client?
A client has a healthy system but often sees delays in some queries because of workload concurrency limits. These limits have been carefully chosen, so the client needs a solution that will not modify them. What should the Administrator use to assist this client?A . Use a system throttle.B ....
Which benefit is achieved by creating profiles?
Which benefit is achieved by creating profiles?A . Reducing the growth of the DBC.AccessRights tableB . Managing user privileges on database objectsC . Assigning permanent space for groups of users with similar needsD . Defining spool space for groups of users with similar needsView AnswerAnswer: D Explanation: Profiles in Teradata...
Which view contains the utility usage data for the prior months?
An Administrator has been tasked with analyzing previous growth and usage patterns by utilities such as Multiload and FastLoad. The aim is to project the likely resource requirements of the existing loads in the next three to six months. In the last month, the Administrator team have started using AccountString...
How can this be accomplished?
An Administrator needs to provide end users access to data in a Native Object Store using shared credentials. How can this be accomplished?A . Define a FOREIGN TABLE with DEFINER TRUSTED security.B . Define a FUNCTION MAPPING with INVOKER TRUSTED security.C . Use an S3 1AM role or Azure SAS...
Which metrics should be examined for high values to identify the queries?
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?A...
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...
