TDVAN5 Vantage Administration Exam Dumps

1. There is a call center application that repetitively sends tactical queries to Vantage These queries use a few small tables that are joined on the primary index column.

The following maps are defined in the system:

* TD_GlobalMap

* TD_Map1

* TD_DataDictionaryMap

* TD_1AmpSparseMap_1Node

What can be done to optimize these queries?

2. Which workload management technique should the Administrator use to reject all QueryGrid

queries during a pre-defined critical batch state?

3. 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?

4. Which benefit is achieved by creating profiles?

5. What is a use case for Data Mover?

6. 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 used?

7. 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 be taken by the Administrator to assist this client?

8. The Administrator has dropped a profile which was associated with a group of users.

What will happen when one of the users from the group logs on to the database?

9. 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 action should the Administrator take?

10. At a large car manufacturer, huge volumes of diagnostic data for cars are collected in the following table:





The master data for each car is stored in the following table:





Many reports require data from both tables by joining via column VehicleId.

A very frequently performed query on the system returns the number of events by FaultCode and ModelType. This query consumes many CPU and I/O resources each day.

Which action should the Administrator take to improve the runtime and resource consumption for this query?

A. Use an aggregate join index with columns FaultCode, ModelType, as well as an appropriate aggregate function.

B. Use a sparse join index with columns FaultCode and ModelType, as well as an appropriate filter function.

C. Use a NUSI on VehicleEvent.FaultCode and a NUSI on Vehicle.ModelType

D. Use a single table join index on VehicleEvent hashed by FaultCode and another single table join index on Vehicle hashed by ModelType.

11. 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?

12. 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?

13. 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?

14. 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?

15. 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?

16. An Administrator needs to provide end users access to data in a Native Object Store using shared credentials.

How can this be accomplished?

17. 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?

18. 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?

19. 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?

20. 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.)

21. 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?

22. How can an Administrator monitor the data volume that is transferred for a Data Mover job via Viewpoint?