• Teradata 14 Database Administration

  •  

    Teradata 14 Database Administration Exam (TE0-144)

    Exam Details

    Purpose of the Exam

    This exam will certify that the successful 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.

    Credential Earned

    Teradata 14 Certified Database Administrator Certification with Digital Badge

    Exam Duration

    2 hours 15 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.  

    Language

    English

    Cost

    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)

    Prerequisites, Eligibility Requirements and Recommended Experience

    Prerequisite Exams

    Upgrade Path from Teradata 12 Prerequisite Exam (must hold Teradata 12 Certified Technical Specialist)

    Exam TE0-144 does not require an eligibility voucher.

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

    How to Register

    Online - visit www.pearsonvue.com/teradata  

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

    Retake Policy

    A failed exam may be retaken after a 21 calendar day waiting period. The 21 calendar day waiting period begins from the date of the failed exam attempt.

    You will be required to schedule a new appointment and pay for the exam.

    You may attempt an exam a maximum of three (3) times during a six (6) month period.

    Re-taking the same Teradata 14 exam after passing that exam will not be allowed.

    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-144 Teradata 14 Database Administration

    • 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.

    Click for Printable Exam Objectives 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.

    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).

    Resources & Preparation Materials

    Teradata Certification App (TCaPP)

    The TCaPP App is free and provides instant access to: program information, tutorials, Authorized Study Guides, practice question packs, exam registration and results from the convenience of your smartphone or tablet.

    Download the App for Android or iOS.

    Authorized Study Guide

    Authorized Teradata Certification Study Guides are available to support your Teradata Certification goals. Each guide provides focused content, simplified examples and explanations around key objective areas, and help in determining topics for further study prior to sitting for your Teradata Certification exams. The guides are intended as a study companion for individuals who have completed recommended Teradata training courses and who have the suggested experience using Teradata Database technology.

    Teradata 14 Certification Study Guide

    Note: The Teradata Certification Study Guides and Apps are the only authorized study guide publications in the market. The Teradata Certified Professional Program partners with Cerulium Corporation to author the Teradata Certification Study Guides and develop mobile applications.

    Sample Questions

    Access Teradata 14 Sample Questions  

    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.  

    More sample questions are available for purchase through the Teradata Certification App (TCaPP) and end of chapter questions are included with the Authorized Study Guides.

    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