2024 NCR Teradata TDVAN5 Exam Dumps Questions

NCR Teradata certification is a highly valuable and sought-after certification for IT professionals seeking to enhance their knowledge and expertise. TDVAN5 exam is specifically designed to validate the skills required to configure and maintain the Vantage Master 2.0 platform, which is widely used by businesses around the world. These TDVAN5 exam dumps questions are specifically designed to help you prepare for the exam by testing your knowledge and providing you with valuable insights into the types of questions that you will encounter. Test free NCR Teradata TDVAN5 exam questions below.

Page 1 of 3

1. A suite of development jobs have been mistakenly executed at a time when a long-running critical job is being run. The business has decided to allow the development jobs to run if they do not block the critical job. An Administrator has been tasked with recording any delays experienced throughout the execution of this critical job and to abort any of the development jobs if they block it.

Which Viewpoint portlet could the Administrator use for this purpose?

Query Session

Query Monitor

Show Locks

Lock Display

 Loading...

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

QRY_D because of CPU SKEW

QRY_C because of UII

QRY_B because of IO SKEW

QRY_A because of PJI

 Loading...

3. The Administrator has just created a new database object on a Vantage system.

Which privilege is NOT automatically granted to that database on itself?

CREATE AUTHORIZATION

CREATE MACRO

CREATE PROCEDURE

CREATE TRIGGER

 Loading...

4. There is corruption in a table in the DBC database.

Which action should the Administrator take to restore the table?

Perform a SYSINIT, and restore the corrupted table.

Set the corrupted AMP offline, and restore the entire system.

Set the corrupted AMP offline, and restore the corrupted table.

Perform a SYSINIT, and restore the entire system.

 Loading...

5. An Administrator is working through a set of tasks to set up a new Vantage system. The current task is to set up alerts to trigger BTEQ scripts to run when certain conditions are met.

Which action should an Administrator take?

Define a delivery setting to run SQ

Ensure the SMTP host is using TL

Configure an action set specifying BTE

Specify BTEQ in a SNMP Trap.

 Loading...

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

Define the roles as external and use the ProxyRole query band to specify one role.

Grant both roles to TrustedUser, and add the ProxyRole query band to specify one role.

Specify the appropriate role for each end user in a grant connect through statement.

Include both roles in the grant connect through statement, and use ProxyRole in the query band to select the appropriate role.

 Loading...

7. A system in Viewpoint is regularly reported as being in a critical state due to a lack of available AWT. No flow control is observed on the system. The Administrator identified that this is due to a recently completed cloud migration for the system that increased the number of available AWT from 80 to 120.

Which process task is required to set up the system in Viewpoint to address this problem?

Configure the AWT Info data collector with the updated setting of 120 maximum AW

Increase by 40 the degraded and critical thresholds for the AWT in the system health setup portlet.

Update the performance data collection portlet job that collects resource usage data with the 120 maximum AWT value.

Adjust the system alert that has been configured for AWT to the recommended critical threshold of 92.

 Loading...

8. A table that contains about two billion records is showing a bad response time for range-based queries on the order date column and frequently projects 10 out of 100 columns. The Administrator decides to convert the table to a column and row partitioned table.

Which resource is constrained?

I/O

CPU

AWT

Space

 Loading...

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

Inherited

Ownership

Automatic

Assigned

 Loading...

10. Which QueryGrid connector can only be a target?

Hive

Oracle

Presto

Teradata

 Loading...

Page 2 of 3

11. A capacity planner wants to keep a record of the number of rows that are added and deleted from certain tables over time and would like to obtain this information without having to change the application itself.

Which DBQL option should be enabled?

USECOUNT

EXPLAIN

OBJECTS

VERBOSE XMLPLAN

 Loading...

12. Which spool threshold can an Administrator set to define workload management exception criteria?

Maximum Spool Rows

Spool Skew

Hot AMP Spool

Max Spool Space By AMP

 Loading...

13. An Administrator received reports that a high priority business intelligence (BI) report is failing. This report is a large transaction comprised of multiple SQL statements. Analysis revealed that a TASM filter is rejecting one of the SQL statements in the transaction, and this is causing the entire report to fail.

Which workload management adjustment could the Administrator take to prevent this report from failing?

Add the application ID for the report to the filter Bypass list.

Define a new workload for the high priority report.

Enable prevent mid-transaction throttle delay.

Add exclusion criteria for multistatement requests to the filter.

 Loading...

14. An Administrator reports a power user running a query that is consuming significant CPU in a final step product join and impacting other users due to the high priority of the workload.

Upon contacting the user in the application team, they are advised that the query is a request from the CEO and needs to be completed. The team decides to remediate the situation by changing the workload to a lower priority.

Which Viewpoint portlet should be used to make this adjustment?

Workload Designer

Application Queries

Query Monitor

Workload Health

 Loading...

15. On a Vantage system, the data load process has recently become much slower than normal and is now running for two hours in low concurrency. During the time the process is running, the Administrator measured the following average values from ResUsage:

System CPU busy = 75%

WIO = 25%

Inter-AMP parallelism = 90%

Average BYNET usage = 10%

Which resource is most constrained?

CPU

I/O

BYNET

Parallelism

 Loading...

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

queries during a pre-defined critical batch state?

An exception that includes the following Foreign Servers: TD_SYSFNLI

QGInitiatorExport TD_SYSFNLI

QGInitiatorlmport TD_SYSFNLI

QGRemoteExport TD_SYSFNLI

QGRemotelmport

A filter that includes the following functions: TD_SYSFNLI

QGInitiatorExport TD_SYSFNLI

QGInitiatorlmport TD_SYSFNLI

QGRemoteExport TD_SYSFNLI

QGRemotelmport

An exception that excludes the following Foreign Servers: TD_SYSFNLI

QGInitiatorExport TD_SYSFNLI

QGInitiatorlmport TD_SYSFNLI

QGRemoteExport TD_SYSFNLI

QGRemotelmport

A filter that excludes the following functions: TD_SYSFNLI

QGInitiatorExport TD_SYSFNLI

QGInitiatorlmport TD_SYSFNLI

QGRemoteExport TD_SYSFNLI

QGRemotelmport

 Loading...

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

The per AMP limit of any AMP can reach 20 G

The per AMP limit of 100 GB can be breached up to 10 percent.

The per AMP limit of 10 GB can be breached to any percent.

The per AMP limit of any AMP can reach 11 GET

 Loading...

18. Which benefit is achieved by creating profiles?

Reducing the growth of the DB

AccessRights table

Managing user privileges on database objects

Assigning permanent space for groups of users with similar needs

Defining spool space for groups of users with similar needs

 Loading...

19. A web application executes millions of tactical queries on different tables of a large Vantage system, as shown below:





The most frequent query of the application is using the following SQL with this variable parameter:





The application owner requested to check for optimizations to improve the runtime of the query.

What should the Administrator suggest in this situation?

Create a sparse join index on Receiptline, with CustomerNumber as an input parameter.

Create a NUSI on Receiptline on each of the columns: ProductTypeId, OrderTypeId, VendorId.

ALTER the tables ProductType and OrderType to use a sparse map that includes only a subset of the AMPs.

Instead of directly accessing table Receiptline. a global temporary table should be used, that needs to contain prefiltered rows with CustomerNumber = .

 Loading...

20. An analytics team uses a multibillion row table that is relevant to a great number of queries with different filters and joins. The Administrator needs to identify an effective strategy to collect statistics on this table.

Which statistics should be collected?

Full-table

[Dynamic AMP Sample

Sampled

Summary

 Loading...

Page 3 of 3

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

By accessing the Completed Queries portlet and selecting the Data Mover job

By using the Data Mover portlet accessing the log tab

By viewing the job statistics tab of the Performance Data Collection portlet

By submitting the datamove status -job_name command in the remote console

 Loading...

22. Business users are regularly joining a common set of columns from parquet external data to existing dimension tables. An Administrator needs to improve the performance of these queries where they filter on common columns.

Which strategy can be used to improve performance?

Row partition the parquet table on the filter columns.

Change the primary index of the foreign server to the filtering columns.

Create a foreign server to access the data with column partitioning.

Create a multi-table join index to cover the joined data.

 Loading...

 Loading...