NCR Teradata TDVAN5 Vantage Administration Exam Online Training
NCR Teradata TDVAN5 Online Training
The questions for TDVAN5 were last updated at Apr 20,2025.
- Exam Code: TDVAN5
- Exam Name: Vantage Administration Exam
- Certification Provider: NCR Teradata
- Latest update: Apr 20,2025
An Administrator has been given a task to generate a list of users who have not changed their password in the last 90 days.
Which DBC view should be used to generate this list?
- A . DBC.LOGONOFFV
- B . DBC.USERSV
- C . DBC.SECURITYDEFAULTSV
- D . DBC.ACCESSLOGV
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 . Use Query Group Viewpoint gortjet to change the throttle limit temporally.
- C . Use Flex Throttle option.
Use Query Monitor Viewpoint portlet to change query workloads.
Given a user creation request on a 10-AMP system:
CREATE USER hr_user AS PERM = 100e9 SKEW = 10 PERCENT, SPOOL = 100e9 SKEW = 20 PERCENT;
How does the SKEW factor affect the user’s Perm space, assuming the total space consumed is under the specified perm space limit?
- A . The per AMP limit of any AMP can reach 20 GB.
- B . The per AMP limit of 100 GB can be breached up to 10 percent.
- C . The per AMP limit of 10 GB can be breached to any percent.
- D . The per AMP limit of any AMP can reach 11 GET
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 expansion on all user accounts and have started maintenance jobs to housekeep system data older than seven years. Two years ago, the following command was issued on the system: BEGIN QUERY LOGGING WITH ALL ON ALL;
No other logging commands have been issued.
Which view contains the utility usage data for the prior months?
- A . AMPUsageV
- B . LogOnOffV
- C . QryLogUtilityV
- D . QryLogV
A middle-tier application server logs on to the database as TrustedUser and submits requests on behalf of application end users. The server is shared by Finance and Human Resources groups and uses ProxyUser query band to identify end users to the database. Each group needs access to its own sensitive data, so the Administrator has created two separate roles with the appropriate permissions.
What is the best way to control access to each group’s sensitive data?
- A . Define the roles as external and use the ProxyRole query band to specify one role.
- B . Grant both roles to TrustedUser, and add the ProxyRole query band to specify one role.
- C . Specify the appropriate role for each end user in a grant connect through statement.
- D . Include both roles in the grant connect through statement, and use ProxyRole in the query band to select the appropriate role.
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 token rather than User and Password.
- D . Grant users access to a shared AUTHORIZATION object.
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 SKEW
- B . QRY_C because of UII
- C . QRY_B because of IO SKEW
- D . QRY_A because of PJI
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?
- A . Create a utility limit, classify on username = BATCH_USER and utility = Stored Procedure, and set the limit.
- B . Define an AWT resource limit, classify on username = BATCH_USER and utility = Stored Procedure, and set the limit.
- C . Create a new workload, classify on username = BATCH_USER and statement type = CALL, and set a throttle.
- D . Define a system throttle, classify on username = BATCH_USER and stored procedure = *.*, and set the limit.
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 . MAXAMPIO and PJI
- B . TOTALIOCOUNT and PJI
- C . I/O SKEW % and UII
- D . REQPHYSIO and UII
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.)
Latest TDVAN5 Dumps Valid Version with 72 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
