• Teradata 14 Basics

  • Teradata 14 Basics Exam

    Exam Details

    Purpose of the Exam

    This exam will certify that the successful candidate has knowledge of the core concepts of the Teradata database and related technologies. The candidate understands relational database concepts, the major components, features, functionality, and Teradata’s data distribution and data access methods. The candidate understands operational, tactical, strategic business intelligence, and analytical processing.

    Credential Earned

    Teradata 14 Certified Professional Certification with Digital Badge

    Prerequisites, Eligibility Requirements and Recommended Experience

    This exam has no pre-requisite exam or certification requirements.

    Exam TE0-141 does not require an eligibility voucher.

    Minimum of six months experience working with Teradata technology is recommended.

    Exam Duration

    Teradata is focused on the integrity and security of its examination process. Effective June 1, 2018, the exam duration will change.

    Exams taken on or before May 31st, 2018: 1 hour 30 minutes*

    Exams taken on or after June 1st, 2018: 2 hours*

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


    English and Japanese


    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

    A failed exam may be retaken after a twenty-one calendar day waiting period. The twenty-one 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 times during a six 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-141 Teradata 14 Basics

    • Data Warehouse Architectures
      • Describe the layers of the Enterprise data warehouse architecture.
      • Identify the components of a data warehouse architecture.
      • Contrast centrally located architectures with physically distributed architectures, such as an appliance.
      • Determine the benefits of centralized data warehouses vs. noncentralized data warehouses.
      • Describe the basic concepts of Teradata Active Solutions (e.g., Active Load, Active Access, Active Events, etc.)
      • Describe the approach of building an application data model vs. Enterprise data model.
    • Relational Database Concepts
      • Define the terms associated with relational concepts.
      • Describe the advantages of a relational database.
      • Describe the differences between star schema and third normal form logical models.
      • Describe the characteristics of row vs. set processing.
    • Teradata RDBMS Components and Architecture
      • Describe the features or benefits of the Teradata technology.
      • Describe the functionality of components of the Teradata technology.
      • Identify the communication interfaces from external applications to Teradata.
      • Identify application programming interfaces.

    Keywords: AMPs, PEs, BYNET and ODBC, JDBC, MOSI, mTDP

    • Database Managed Storage
      • Explain the effects of the Primary Index on data distribution and organization.
      • Explain the effects of No Primary Index on data distribution and organization.
      • Describe the differences between Primary Index and Primary Key.
      • Describe the differences between non-partitioned, single level, and multi-level partitioned tables.
      • Identify the benefits of Teradata automatically managed storage vs. DBA manually managed distribution techniques.
      • Define perm space, spool space, and temp space.
      • Describe the concept of multi-temperature data.
      • Identify the storage optimization techniques that exist in Teradata.
      • Identify the differences between Columnar and Row storage.
    • Data Access Methods
      • State the reasons for defining a UPI (Unique Primary Index) vs. a NUPI (Non-Unique Primary Index).
      • State the reasons for defining a USI (Unique Secondary Index) vs. a NUSI (Non-Unique Secondary Index).
      • Identify the reasons for using a primary index versus no primary index.
      • Describe the trade-offs between Index access and Full Table Scans.
      • Describe the operation and/or causes of Full Table Scans.
      • State the reasons for defining a PPI (Partitioned Primary Index) and/or Multi-level Partitioned Primary Index.
      • Describe the benefits of join indexes.
      • List the types, levels, and functionality of locking provided by Teradata.
      • Identify the reasons for choosing between Columnar and row storage.
    • Data and Performance Availability Features
      • Describe hardware specific data and performance protection techniques.
      • Explain the concept of FALLBACK tables.
      • Describe how Transient Journals ensure data integrity.
      • Describe the concept of node failover.

    Keywords: journals, node failover, cliques, hot standby, RAID1

    • Teradata Tools and Utilities
      • Identify the features and functions of data integration utilities.
      • Identify the features and functions of the administering and monitoring tools available within the Teradata product suite.
      • Identify the features and functions of the access tools available within the Teradata product suite.
      • Identify the features and functions of the Teradata ARC utility.
      • Identify the tools in the Teradata Analyst Pack.
      • Identify the features and use of Unity Director.
      • Identify the features and use of Unity Data Mover.
    • Workload Management
      • Describe the characteristics of work types that Teradata supports.
      • List the purposes of workload management.
      • Describe the characteristics of response time vs. throughput.

    Keywords: response time, throughput, tactical, strategic, row vs. set processing, workload management tools (TASM, TDWM, Priority Scheduler)

    • Security and Privacy
      • Identify security mechanisms available to Teradata.
      • Identify privacy mechanisms available within Teradata.

    Keywords: LDAP, single sign-on, passwords, views, macros, UDFs, row level security

    Click for Printable Exam Objectives PDF

    Recommended Course

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

    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.

    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