Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. TeraData
  5. TDVAN5

TeraData TDVAN5 Exam
Vantage Administration (Page 6 )

Updated On: 12-Feb-2026
Page 3 of 16
PDF with 72 Questions

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?

  1. Offline
  2. Skip statistics
  3. Online
  4. Dictionary Only

Answer(s): C

Explanation:

An Online backup strategy allows the database to remain accessible and operational while the backup is taking place. This means that users can continue to modify data, and the system can remain available without requiring downtime. It is a common approach for mission-critical systems that need to maximize uptime.
Offline would require the system or certain tables to be unavailable during the backup process, which is not suitable for a system that needs to remain available. Skip statistics refers to skipping the backup of statistics on database objects and does not relate to whether the system can be updated during the backup.
Dictionary Only involves backing up only the system catalog or dictionary data, not the actual table data, and would not fulfill the requirement of a comprehensive backup while allowing updates.



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?

  1. Use the Query Spotlight Viewpoint portlet to deprioritize the queries.
  2. Use the Flex Throttle option.
  3. Use a TASM system filter.
  4. Use the Query Log Viewpoint portlet to identity and abort the harmful queries.

Answer(s): C

Explanation:

Teradata Active System Management (TASM) allows the system administrator to control and manage query workload in real-time. A TASM system filter can be used to prevent or deprioritize certain types of queries, such as product joins or poorly written queries, that are consuming excessive resources. This approach ensures that problematic queries do not harm the overall system performance.
Query Spotlight Viewpoint portlet focuses on identifying and managing individual queries but does not provide the same level of proactive filtering and control as TASM system filters. Flex Throttle is useful for controlling the concurrency of queries, but it doesn't specifically address preventing or managing product joins in a way that would directly resolve the issue with poorly written SQL.
Query Log Viewpoint portlet would help in identifying and aborting harmful queries, but it's a reactive approach rather than a proactive solution like using TASM system filters.



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?

  1. The default profile setting for the user will be reset to NULL.
  2. Password attributes defined at the system level in DBCSecurityDefaultsV will apply
  3. The system will show a warning message.
  4. SPOOL and DEFAULT DATABASE specifications for the dropped profile will still apply to the user.

Answer(s): B

Explanation:

When a profile is dropped, the users who were associated with that profile will no longer have the specific resource and configuration settings defined by that profile. Instead, the system-level default settings, such as those specified in DBC.SecurityDefaultsV, will apply to the users. This includes password attributes and other system-wide settings.
Option A (The default profile setting for the user will be reset to NULL) is not accurate, as the system will revert to the default settings rather than leaving values unset.

Option C (The system will show a warning message) does not typically occur when a profile is dropped. The system will manage the transition without user-facing warnings at login. Option D (SPOOL and DEFAULT DATABASE specifications for the dropped profile will still apply to the user) is incorrect because once the profile is dropped, its settings no longer apply to the users who were associated with it.
Thus, the correct outcome is that system-level attributes defined in DBC.SecurityDefaultsV will govern the users' settings moving forward.



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?

  1. Increase the relative weight of the tactical tier.
  2. Disable the expedite option of the workloads in the SLG Tier level 1.
  3. Increase the number of AWTs.
  4. Adjust the limits of awt concurrency in the tactical tier using DBS control.

Answer(s): A

Explanation:

In a TASM (Teradata Active System Management) environment, the relative weight of different tiers (such as tactical, SLG, or background) determines the amount of CPU and I/O resources allocated to each tier. Increasing the relative weight of the tactical tier would prioritize these workloads, giving them more resources relative to other tiers and improving their response time. Option B (Disable the expedite option of the workloads in the SLG Tier level 1) might alleviate some resource pressure from SLG Tier 1 workloads, but it doesn't directly improve the prioritization or resource allocation for tactical workloads.
Option C (Increase the number of AWTs) is not applicable because the system already has reserved AWTs for tactical workloads, and AWT (AMP Worker Task) availability is likely not the bottleneck here. Simply increasing the number of AWTs without addressing the core CPU and I/O resource allocation will not improve tactical workload response. Option D (Adjust the limits of AWT concurrency in the tactical tier using DBS control) might provide marginal improvements but won't have a significant impact on overall resource prioritization. It focuses more on concurrency management than directly improving workload performance through resource allocation.



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?

  1. Use an aggregate join index with columns FaultCode, ModelType, as well as an appropriate aggregate function.
  2. Use a sparse join index with columns FaultCode and ModelType, as well as an appropriate filter function.
  3. Use a NUSI on VehicleEvent.FaultCode and a NUSI on Vehicle.ModelType
  4. Use a single table join index on VehicleEvent hashed by FaultCode and another single table join index on Vehicle hashed by ModelType.

Answer(s): 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:
A . Use an aggregate join index with columns FaultCode, ModelType, as well as an appropriate aggregate function.
Aggregate Join Index: This type of join index will pre-join the tables VehicleEvent and Vehicle on

VehicleId and store the results of frequently queried aggregations (in this case, counts by FaultCode and ModelType). It would significantly reduce the need to perform full joins and aggregations at query time, saving both CPU and I/O resources.
Option B: A sparse join index is useful for selective filtering but does not offer aggregation. Since the query involves counting (aggregation), the aggregate join index is more suitable. Option C: Creating Non-Unique Secondary Indexes (NUSIs) on FaultCode and ModelType would help speed up searches for those columns, but it won't help with the pre-aggregation or frequent joins that are consuming the majority of the resources.
Option D: Creating separate single table join indexes for FaultCode and ModelType on different tables won't improve the performance of the aggregation and join-heavy query, because the problem stems from the frequent joins and aggregations, not just individual table access.






Post your Comments and Discuss TeraData TDVAN5 exam prep with other Community members:

Join the TDVAN5 Discussion