Question 1

Which description accurately characterizes the use of external authentication for Vantage?

Accepted Answer

C

Explanation: Teradata Vantage allows for the integration of user authorization with an external directory service, such as LDAP or Active Directory. This is accomplished by creating a database role and mapping it to a specific group within the directory using the AS EXTERNAL NAME clause. When a user who is a member of that external group authenticates to Vantage, they are automatically granted the permissions of the corresponding database role for the duration of their session. This feature centralizes user authorization management within the directory, simplifying administration.

Question 2

An Administrator needs to provide end users access to data in a Native Object Store using shared credentials. How can this be accomplished?

Accepted Answer

D

Explanation: In Teradata Vantage, the AUTHORIZATION object is the designated mechanism for storing credentials used to access external systems, including Native Object Stores (NOS). To facilitate shared access, an administrator creates a single AUTHORIZATION object containing the required credentials. Subsequently, the administrator grants the USAGE privilege on this specific AUTHORIZATION object to the relevant end-users or roles. When these users query a foreign table that references this AUTHORIZATION object, Teradata Vantage uses the stored, shared credentials to access the data in the object store. This centralizes credential management and provides a secure method for shared access.

Question 3

There is corruption in a table in the DBC database. Which action should the Administrator take to restore the table?

Accepted Answer

C

Explanation: This action is appropriate for a scenario where table corruption is localized to a single Access Module Processor (AMP), often due to a hardware issue like a disk failure. In such cases, the system may take the faulty AMP offline to isolate the problem. The administrator's subsequent task is to recover the data on that AMP. For tables without Fallback protection, this involves restoring the affected table from the last known good backup. This targeted approach is preferred as it minimizes system downtime and impact compared to a full system restore, adhering to the principle of least impact for recovery.

Question 4

A Vantage customer is using the Hive Connector in QueryGrid to access a foreign server and push the
processing onto the Hadoop Cluster. The Vantage Administrator is concerned about the performance
implication of the temporary space that is consumed by these queries during execution.
What must the Vantage Administrator investigate?

Accepted Answer

C

Explanation: When using Teradata QueryGrid with pushdown processing to a foreign server like Hadoop/Hive, temporary space is consumed on both the Vantage system and the foreign system. On the Vantage side, intermediate or final result sets returned from the foreign server consume the user's spool space. On the Hadoop/Hive side, complex operations that are pushed down may require the creation of temporary tables. The location for these temporary tables is specified by the temporary database name property within the QueryGrid link definition. An administrator concerned about performance and space consumption must investigate both of these aspects to manage resources effectively.

Question 5

A Vantage instance includes the following four databases:
Tables Database contains base tables and associated index subtables
Upsert_Database: contains views and other objects to support base table modifications
Query Database: contains views and other objects supporting queries and reporting
Development_Database: contains objects supporting development of new data applications
The Administrator needs to add a new user that will perform batch-level functions.
Which action should the Administrator take to achieve this goal?

Accepted Answer

B

Explanation: Batch-level functions, such as data loading with Teradata Parallel Transporter (TPT) or legacy utilities, frequently require the creation of temporary work, error, or staging tables within the target database. The CREATE TABLE privilege is essential for these operations. In Teradata, the best practice for managing permissions is to bundle privileges into roles and then grant those roles to users. By setting the user's default role to one that possesses the CREATE TABLE privilege on the TablesDatabase, the administrator correctly and efficiently enables the user to perform the required batch tasks.

Question 6

Which benefit is achieved by creating profiles?

Accepted Answer

D

Explanation: A Teradata profile is a database object that defines a set of attributes that can be assigned to multiple users. This simplifies administration by allowing common settings to be managed in one place. One of the key attributes that can be defined within a profile is the SPOOL space limit. This allows an administrator to set a consistent spool space allocation for a group of users who have similar query processing needs, rather than defining it individually for each user.

Question 7

Users are complaining that queries in their workload are taking too long. The Administrator suspects
that workload management may be throttling the queries.
Which table should be analyzed to confirm this suspicion?

Accepted Answer

B

Explanation: The ResUsageSawt (Scheduler Activity by Workload Type) table is specifically designed to monitor the activity of the Teradata workload management scheduler. It provides aggregated data at the workload level for specific time intervals. To confirm if queries are being throttled, an administrator would analyze the DelayTime and DelayCount columns in this table. These columns directly measure the total time and the number of requests that were held in a delay queue due to system or workload throttles, providing clear evidence of throttling's impact on the workload.

Question 8

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?

Accepted Answer

B

Explanation: The scenario describes tactical queries joining a few small tables on their primary index (PI). The most effective optimization for this workload is to eliminate all data movement and communication between AMPs during query execution. Assigning the tables to TD1AmpSparseMap1Node forces all rows of these tables onto a single AMP. Using the same colocation name for all tables is crucial; it informs the Teradata Optimizer that rows with the same PI value across these tables are physically stored together on that single AMP. This allows for a direct, highly efficient local join on one AMP, completely avoiding data redistribution steps and network overhead, which is ideal for the sub-second response times required by tactical queries.

Question 9

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.) https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/TERADATA_TDVAN5/page_15_img_1.jpg

Accepted Answer

Explanation: Workload Designer: This portlet is the interface for Teradata Workload Management (TASM/TIWM). Administrators use it to define Rulesets and Exceptions . An "exception" is a specific workload event (e.g., a query running too long) that can be configured to trigger an alert . Server Management: This portlet provides a view of the physical and virtual infrastructure (CMICs, nodes). It specifically handles Server Management summary alerts related to hardware or OS-level health. Performance Data Collection: This portlet configures which data metrics are harvested from the system. Specific data collectors include "Job" (e.g., for specific job metrics) and "Database Space" (for perm/spool space usage). Enabling these collectors is the prerequisite "configuration" required to trigger alerts based on these metrics. Monitored Systems: By elimination and functional hierarchy, this matches the general definition of adding alerts to a system . The Monitored Systems portlet is where systems are added to Viewpoint, and it serves as the foundational setup where alert connectivity and system-level monitoring rules are initialized (often linking to the Alert Setup service).

Question 10

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?

Accepted Answer

B

Explanation: When a profile assigned to a user is dropped, the Profile attribute for that user in the DBC.UsersV view is set to NULL. Upon the user's next logon, the system applies the system-level defaults for any attributes that would have been controlled by the profile. This includes password attributes such as expiration, complexity, and lockout rules, which are defined in the DBC.SysSecDefaults table and are visible through the DBC.SecurityDefaultsV view. The logon process will succeed, but with these system-wide security settings enforced.

Question 11

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?

Accepted Answer

C

Explanation: Flex Throttles are a feature within Teradata Active System Management (TASM) specifically designed to manage workload concurrency dynamically. When a workload with a Flex Throttle enabled reaches its concurrency limit, it can "borrow" unused Amp Worker Task (AWT) slots from the system. This allows the workload to temporarily exceed its defined limit to process queries that would otherwise be delayed, without requiring a permanent modification to the carefully chosen base concurrency limit. This directly addresses the client's need for flexibility while maintaining their established workload rules.

Question 12

Which statement accurately characterizes privileges?

Accepted Answer

C

Explanation: In the Teradata security model, the database or user that contains an object is considered its immediate owner. This ownership confers all privileges on that object automatically and implicitly. For example, the Sales database inherently has all privileges (SELECT, INSERT, etc.) on the Sales.Products table. These ownership privileges are fundamental to the system and do not require an explicit GRANT statement to be issued. The system automatically recognizes the owner's rights to the objects within its space.

Question 13

Which compression format is supported by NOS?

Accepted Answer

B, C

Explanation: Teradata Native Object Store (NOS) supports reading compressed data directly from external object stores using the READNOS table operator. The COMPRESSION parameter within this function explicitly specifies the supported decompression codecs. According to official Teradata Vantage documentation, the valid values for this parameter include 'ZLIB' and 'SNAPPY'. These formats can be used to decompress data from file types like CSV and JSON. While NOS can read complex file formats like Parquet and ORC which have their own internal compression schemes (often using Snappy or ZLIB), the question specifically asks for supported compression formats that can be directly specified.

Question 14

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?

Accepted Answer

C

Explanation: An online backup strategy is specifically designed for high-availability systems where continuous operation is critical. This method allows backup operations to run concurrently with user transactions, including DML changes (inserts, updates, deletes) to the tables being backed up. The system achieves this by placing read locks on the data blocks, which prevents structural changes (DDL) but permits ongoing data modifications. This ensures the database remains accessible and operational for business users during the backup process, directly meeting the administrator's requirements for a continually updated, business-critical system.

Question 15

A group of batch queries that rely on QueryGrid to source data from a cloud Vantage system has
failed and requires urgent investigation.
Which Viewpoint portlet should be used to initially investigate the reason for this problem?
A group of batch queries that rely on QueryGrid to source data from a cloud Vantage system has
failed and requires urgent investigation.
Which Viewpoint portlet should be used to initially investigate the reason for this problem?

Accepted Answer

B

Explanation: The Alert Viewer portlet is the most appropriate starting point for this investigation. When a group of queries fails simultaneously, especially those dependent on an external system via QueryGrid, it strongly suggests a systemic issue rather than an error in each individual query. The Alert Viewer is designed to display system-level events, errors, and status changes. A failure in the QueryGrid connector, a network connectivity problem, or an issue with the remote cloud Vantage system would generate a system alert, providing the fastest path to identifying the root cause of the widespread failure.

Free Teradata TDVAN5 Actual Exam Questions