Teradata 14 Database Administration

ABOUT THE EXAM

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.

REGISTRATION INFORMATION

Register for the Teradata 14 Database Administration Exam

IMPORTANT NOTICE: The Teradata Certified Professional Program (TCPP) 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.

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

CREDENTIALS

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

COST

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 TCPP Connections Group to obtain an employee voucher. You must be behind the Teradata firewall to access this page.

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

RECOMMENDED COURSES

The Teradata Certified Professional Program 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 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.

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.

POLICIES

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.