Teradata TDVAN5 Exam Questions

Question 6 of 72

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?

A.

Offline

B.

Skip statistics

C.

Online

D.

Dictionary Only

Question 7 of 72

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?

A.

Use the Query Spotlight Viewpoint portlet to deprioritize the queries.

B.

Use the Flex Throttle option.

C.

Use a TASM system filter.

D.

Use the Query Log Viewpoint portlet to identify and abort the harmful queries.

Question 8 of 72

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?

A.

The default profile setting for the user will be reset to NULL.

B.

Password attributes defined at the system level in DBC.SecurityDefaultsV will apply.

C.

The system will show a warning message.

D.

SPOOL and DEFAULT DATABASE specifications for the dropped profile will still apply to the user.

Question 9 of 72

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?

A.

Increase the relative weight of the tactical tier.

B.

Disable the expedite option of the workloads in the SLG Tier level 1.

C.

Increase the number of AWTs.

D.

Adjust the limits of awt concurrency in the tactical tier using DBS control.

Question 10 of 72

At a large car manufacturer, huge volumes of diagnostic data for cars are collected in the following table:
Exam TDVAN5: Question 10 - Image 1

The master data for each car is stored in the following table:
Exam TDVAN5: Question 10 - Image 2

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.

Answer: A -
Explanation:
To improve the runtime and resource consumption for a query that returns the number of events by FaultCode and ModelType from the two tables VehicleEvent and Vehicle, the most appropriate action would be: