Teradata 14

Minimum of five plus years broad-based, diverse hands-on experience with the Teradata Database, platforms, tools and utilities is recommended.

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

Successful completion of the Teradata 14 Basics Exam (TE0-141), plus Teradata 14 SQL Exam (TE0-142), plus Teradata 14 Physical Design and Implementation (TE0-143), plus Teradata 14 Database Administration (TE0-144), plus Teradata 14 Solutions Development (TE0-145), and Teradata 14 Enterprise Architecture (TE0-146) are prerequisites for this exam OR if a candidate holds a Teradata 12 Certified Master Credential, they can upgrade from Teradata 12.

The Comprehensive Mastery exam (TE0-147) is a restricted access exam requiring an eligibility voucher that must be provided during the registration process. Download the eligibility voucher from the Teradata Certification Tracking System and then register at Pearson VUE using both the eligibility voucher and credit card to pay the exam fee.

This exam is 3 hours and 20 minutes in length.

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.

Utilize system and workload level events in TASM. Define, set up and apply workloads, exception rules, throttles, and SLES 11 Priority Scheduler. Evaluate workload behavior and utilization in SLES 11. Identify and solve AWT exhaustion problems. Control utility session usage across multiple application areas. Evaluate and implement workload management on the appliance on the SLES 11 platform.

Use statistics collection effectively and appropriately. Use DBQL to identify performance optimization opportunities. Identify when to use and how to implement indexes (PI, SI, JI, AJI, PPI, etc.). Evaluate query performance and implement performance optimizations.

Identify when to use and how to implement columnar. Identify when to use and how to implement partitioning (PPI and MLPPI). Identify when to use Temporal.

Estimate resource requirements for an application. Evaluate the usage and effects and the monitoring of compression. Evaluate the usage, effects and the monitoring of system capacity.

Utilize and optimize data load strategies within and across multiple applications. Identify areas for data integrity improvements. Identify methods to improve single-system availability. Determine methods and processes to route queries and synchronize data in a multi-system environment.

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.
Introduction to the Teradata Database
Teradata SQL
Teradata Advanced SQL
Physical Database Design
Physical Database Tuning
Teradata Application Utilities
Teradata Parallel Transporter
Teradata Warehouse Administration
Teradata Warehouse Management
Teradata Application Design and Development

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

Visit the Teradata internal Certification Connections site for more information on recommended Teradata training. You must be behind the Teradata firewall to access this page.

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.