• Teradata 14 Comprehensive Mastery

  • Teradata 14 Comprehensive Mastery Exam (TE0-147)

    Exam Details

    Purpose of the Exam

    This exam will certify that the successful candidate has the knowledge and skills necessary to be a technical authority for designing, implementing, and managing a Teradata enterprise-wide data warehouse. This individual can provide recommendations on all aspects of the data warehouse lifecycle from conceptualization through production implementation and ongoing management and support.

    The Comprehensive Mastery exam is a unique exam in the Teradata Certification Track. Candidates taking this exam will be given a scenario to read and analyze. They will then be presented questions requiring that the candidate understand and apply knowledge from that scenario to answer the questions.

    Credential Earned

    Teradata 14 Certified Master Certification with Digital Badge

    Prerequisites, Eligibility Requirements and Recommended Experience

    Prerequisite Exams

    The Comprehensive Mastery exam (TE0-147) is a restricted access exam requiring an eligibility voucher that must be provided during the registration process. Candidates eligible for this exam will automatically receive an email notification from the Teradata Certification Tracking System. This email provides information and instructions about retrieving an eligibility voucher from the Teradata Certification Tracking System prior to scheduling exam TE0-147. To check your eligibility, log in to the Teradata Certification Tracking System.

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

    Upgrade Option from Teradata 12

    Candidate must hold a Teradata 12 Certified Master Credential

    Exam Duration

    3 hours 20 minutes*

    *The exam duration shown is the amount of time allowed for answering exam questions. The Test Delivery Provider may add time to your total appointment to provide the opportunity to get seated, read the Non-Disclosure Agreement (NDA) and complete the tutorial (if applicable) before you start the exam.  




    The cost of Teradata exams vary by exam, location and currency. Please visit www.pearsonvue.com/teradata to find the price of an exam where you are located.

    Teradata Employees visit the TCPP Connections Group to obtain an employee voucher. (You must be behind the Teradata firewall to access this page)

    How to Register

    Online - visit www.pearsonvue.com/teradata  

    For a list of regional phone numbers visit www.pearsonvue.com/teradata/contact/

    Retake Policy

    The Teradata 14 Comprehensive Mastery Exam (TE0-147) can be attempted an unlimited number of times, subject to a maximum of two testing attempts in a six month period. You may not re-take the Comprehensive Mastery Exam once you have passed it. An eligible candidate may request an eligibility voucher twenty-one days or more after his/her latest Comprehensive Mastery Exam testing date, subject to the restriction of two attempts in a six month period.

    Teradata 14 Certification Exams Objectives

    The high level objectives represent the general content areas. The more detailed information below the objective indicates representative topic areas. All Teradata 14 functions and features that fall within the stated objective areas are eligible topics on an exam.

    TE0-147 Teradata 14 Comprehensive Mastery

    • Workload Management
      • 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.
    • Performance Management and Query Optimization
      • 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.
    • Database Design
      • 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.
    • Configuration/Space Management and Capacity Planning
      • 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.
    • Data Management and Integration
      • 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.

    Additional Exam References

    The following list of references may assist as you study for the Teradata 14 Comprehensive Mastery Exam. This is not a comprehensive list and should be used in conjunction with the formal training and experience recommendations. References may be downloaded from the Teradata Information Products website http://www.info.teradata.com/.

    TE0-147 Teradata 14 Comprehensive Mastery Exam

    Database Design, Release 14.0 B035-1094-111A
    Database Administration, Release 14.0 B035-1093-111A
    SQL Data Definition Language Syntax and Examples, Release 14.0 B035-1144-111A
    Temporal Table Support, Release 14.0 B035-1182-111A
    Release Summary, Release 14.0 B035-1098-111A
    Teradata Parallel Transporter Reference, Release 14.00 B035-2436-071A
    Performance Management, Release 13.10 B035-1097-109A
    Unity Director User Guide, Release 14.00 B035-2520-013K
    Teradata Viewpoint User Guide, Release 14.01 B035-2206-112KA

    Click for Printable Exam Objectives and Additional References PDF

    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.

    • 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 Employees only: visit the Teradata internal TCPP Connections site for more information on recommended Teradata training. (You must be logged in to the Teradata network).

    Sample Questions

    The Teradata sample questions are designed to give you an example of the format and types of questions on the actual Teradata Certification exams. The sample questions are not intended to duplicate items on the actual exams. Questions are rotated and will be slightly different each time.  

    The sample questions are offered on-line free of charge and are not “scored” or tracked. Practice at your own pace and as often as you want. Please note since this exam is comprehensive all underlying exam sample questions can be used.  

    Access Teradata 14 Sample Questions  

    Documentation and Downloads

    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.

    Back to Top