Teradata 14

Teradata 14 Database Administration


Covers the Features and Functionality of the Teradata Database 13.0, 13.10, and 14.0 (including SLES 11)

This exam will certify that candidate has core knowledge and skills necessary to set up, manage, and maintain a Teradata database environment. The candidate has a thorough understanding of Teradata database concepts, object creation, system and query performance, space management, security, system parameters, workload management, capacity management, and database utilities.


Register for the Teradata 14 Database Administration Exam

To register visit home.pearsonvue.com/teradata.
For a list of regional phone numbers visit home.pearsonvue.com/teradata/contact/.

IMPORTANT NOTICE: The Teradata Certification will be discontinuing the Teradata 14 certification exams (TE0-141 through TE0-147) on December 31, 2019. After that time, the exams will be no longer be offered.

register now

Minimum of 18 months of hands-on experience with Teradata database administration is recommended.


Successful completion of this exam will earn you a Teradata 14 Certified Database Administrator Certification with a digital badge.


The cost of Teradata exams varies by exam, location, and currency. Please visit home.pearsonvue.com/teradata to find the price of an exam. Teradata Employees can visit the Teradata Certification Connections Group to obtain an employee voucher. You must be behind the Teradata firewall to access this page.


This exam is 2.25 hours in length.


Successful completion of the Teradata 14 Basics Exam (TE0-141), plus Teradata 14 SQL Exam (TEO-142), plus Teradata 14 Physical Design and Implementation (TE0-143) OR Teradata 14 Bridge from Teradata 12 (TE0-14B) are prerequisites for this exam.

For more details regarding specific exam objectives, download this PDF.

system software setup and parameters

Identify the functionality provided by DBSControl. Identify the functionality provided by ctl. Identify the functionality provided by DIP. Identify the functionality of the RECONFIG Utility.

user and security management

Given a scenario, identify the effects of granting access rights. Given a scenario, identify the effects of revoking access rights. Explain the options for limiting access rights table growth. Given a scenario, identify the correct use of views to limit row or column accessibility. Given a scenario, identify the process to locate a security violation, security breach, or password violation. Given a scenario, determine how roles should be used in relation to security management. Given a scenario, determine how profiles should be used. Identify the methods of user authentication. Identify a situation where row level security is appropriate. Identify the new constraints for row level security (readclassification UDF).

session management

Given a scenario, identify the steps to solve session management problems. Given a scenario using a web-based, mainframe, or BI application, identify the function that reduces authentication time. Given a shared userid scenario, identify the feature that uniquely identifies the user. Identify the usage and benefits of a trusted session. Given a scenario, analyze response time and throughput.

load and extract

Given a scenario, identify which load utility to use. Identify the unique features of Teradata Parallel Transporter.
Determine how to control utility limits. Given a load utility failure, determine recovery procedures.

system administration tools

Given a scenario, identify the management and maintenance tool that should be used (Teradata Administrator, Viewpoint, Teradata Multi-System Manager (TMSM), etc). Given a scenario, identify the analysis tool that should be used (Show Locks, Recovery Manager, Teradata Index Wizard, Teradata Statistics Wizard, Teradata System Emulation Tool, Teradata Visual Explain, Locking Logger, etc. Given a scenario, identify the resource that should be used to assess the situation (SQL hash functions, Access Logging, Data Dictionary, ResUsage, DBQL, etc.). Identify the functionality provided by Ferret.

system workload analysis and management

Given a scenario including a system bottleneck, identify tools/resources to determine the cause of the bottleneck.
Explain the collection and analysis of AMPUsage data in problem resolution. Given a scenario, identify which ResUsage tables to use for problem identification.
Given a scenario, identify alternative workload management methods and parameters that the Priority Scheduler can use for a system running SLES 11. Given a scenario, identify the Database Query Log (DBQL) tables and logging options that should be used to resolve the problem. Given a scenario, identify the Workload Designer features that should be used for a system running SLES 11. Identify the account string expansion characters that should be used to capture the appropriate level of data. Identify characteristics of AMP Worker Tasks (AWTs). Identify the capability of the Workload Designer tool for analyzing and managing workloads for systems running SLES 11.

performance optimization

Describe the benefits of capturing, creating, and maintaining an historical operational repository from Dictionary tables.
Given a scenario of aborting a rollback, identify the impact on the table. Identify the benefits, features and utilizations of Extrapolated and propagated statistics. Given a scenario, identify the type of statistics to use. Given a query and the resulting rows in DBQL, identify potential areas for improvement. Identify characteristics of a tactical query.
Identify causes of poor query performance. Identify causes of poor system performance. Identify conditions when collecting multiple statistics in a single request would be beneficial.

capacity management and planning

Identify the inputs that need to be collected for future capacity planning. Identify what is monitored to diagnose immediate capacity shortfalls. Identify the causes of a system running out of disk space. Given a scenario, identify potential solutions to capacity shortages. Calculate the space needed for tables and subtables. Given a scenario, identify the implication of adding compression. Identify methods for conserving disk space.

business continuity

Given a scenario including a type of data protection, identify how the data will be protected or recovered. Describe the features and functions of the archive, recovery, restore, and copy operations. Describe the features and functions of Online Archive. Describe the features and functions of Partition Archive and Restore. Given a scenario including a component failure and protection types, identify which data is available. Describe the features and functions of the online reconfiguration utility.

object maintenance

Identify the impact of altering table attributes and constraints.
Given a scenario, identify the outcome of partition maintenance. Identify the archive and recovery implications of user defined functions, table functions, user defined types, and stored procedures. Identify maintenance implications of triggers. Identify the actions taken using object use count


The Teradata Certification partners with the Teradata Education Network to provide Teradata courseware and curriculum that specifically relates to each certification level. You can view course descriptions and schedules, and enroll online. Several courses are offered as web-based training (WBT) courseware for your convenience.
Teradata Application Utilities
Teradata Parallel Transporter
Teradata Warehouse Management
Teradata Warehouse Administration

Teradata Employees only: visit the Teradata internal Teradata Certification Connections site for more information on recommended Teradata training. (You must be logged in to the Teradata network).


Teradata has created sample questions, that are freely available, to help you prepare for the exam. These sample questions are not intended to duplicate exam questions and are provided for guidance only.

Access Teradata 14 Sample Questions


Documentation: Search and access Teradata installation, programming, operations and service guides, and reference manuals.
Software Downloads: are available through Teradata Developers Exchange to help you prepare through hands on application.


Exam Administration Policies

Before registering for the exam, familiarize yourself with retaking an exam, recertification of an exam, and the order required for the Teradata Database Certification Track. 

View Policies

Security and Privacy Policies

We take your security and privacy very seriously. Learn more about how we're actively ensuring Teradata Certification integrity and what Teradata considers to be a violation.

View Policies

  • Exam Administration Policies
  • Security and Privacy Policies