Teradata 14

Teradata 14 Enterprise Architecture

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 knowledge and skills necessary to design enterprise data warehouse architectures with rigor centered around the Teradata environment. This includes information management, optimization, data integration (data source to database target), data protection, data governance, and information delivery strategies. This candidate will incorporate the features of Teradata to ensure integrity and optimum performance.


Register for the Teradata 14 Enterprise Architecture Exam

To register visit home.pearsonvue.com/teradata and select exam TE0-146.
For a list of regional phone numbers visit home.pearsonvue.com/teradata/contact/.

IMPORTANT NOTICE: The Teradata Certification 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.

Register Now

A minimum of 3 years hands-on experience with designing and implementing Teradata databases and applications is recommended.


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


Successfully completing the Teradata 14 Basics Exam (TE0-141), plus Teradata 14 SQL Exam (TE0-142), plus Teradata 14 Physical Design and Implementation (TE0-143), OR the Teradata 14 Bridge from Teradata 12 Exam (TE0-14B) plus the Teradata 14 Solutions Development (TE0-145) are prerequisites for this exam. 


This exam is 1.75 hours 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.

For more details regarding specific exam objectives, download this PDF.


Given a scenario, discuss how to use Teradata workload management to satisfy service level goals. Determine the operational aspects that need to be considered in implementing a data warehouse architecture. Given a scenario, determine how to create and manage a representative test environment. Given a scenario, determine which capacity factors to consider prior to promoting an application into production. Given a scenario to manage excessive history and/or obsolete data, determine the methods for archiving and deleting data from an application. Identify the characteristics of a Teradata Analytic architecture framework (staging, 3NF, and Semantic).


Given a system planning and space management scenario, including application characteristics, configure a database architecture (e.g., space, performance, and CPU requirements). Given a scenario, determine the appropriate system hardware configuration. Given a scenario, identify the potential system and application availability characteristics including active data warehousing that can affect a database architecture. Given a scenario, describe the shared resource requirements and their impact on the overall database architecture and its performance. Describe the features and function of TVS.


Given a scenario, determine which Teradata system resources should be used to assist in analyzing and improving performance tuning. Given a scenario where a query is running slowly, determine improvement options. Given a scenario with a heavily loaded system, describe the process of balancing and reserving system resources. Given a scenario, determine the tools within the Teradata Analyst Pack that are applicable for planning system expansion and workload optimization. Given a scenario, determine the inputs necessary to establish a query management and workload policy. Given a scenario, determine the effects of database optimization techniques (including techniques on tables or indexes). Given a scenario, determine the application characteristics that affect table design and the use of the different types of advanced indexes. Given a scenario, determine optimization techniques that should be used to manage a high-volume tactical workload. Given a scenario, determine the effects of embedded (nested) views.


Given a scenario, determine the trade-offs between an ETL or ELT design. Given a scenario, identify data integration requirements that affect a database architecture. Describe how the Logical Data Model (LDM) is valuable in designing an integrated data architecture. Determine the application characteristics and other factors that affect table design, including types of advanced indexes. Given a Logical Data Model (LDM), determine what needs to be added to create an Extended LDM in order to choose the appropriate indexes. Describe how the Physical Data Model (PDM) is valuable in designing an integrated data architecture. Identify the application performance impact of database design when implementing Referential Integrity (RI and soft RI). Describe the roles of client software in a Teradata environment. Describe connectivity options supported by the Teradata environment. Describe the TTU client operating environments supported by the Teradata environment. Given a scenario, identify the appropriate approach for data movement. Given a system restart scenario, identify the impact on data integration jobs. Given a scenario where multiple business subject areas and their supporting applications are being integrated in the data warehouse, determine where surrogate keys would be a choice. Given a scenario, determine the appropriate method for integrating data from a real-time source.


Describe the options to secure access to the database. Describe the methods available to meet privacy requirements within an application that contains personally identifiable information. Given a scenario, determine the appropriate backup and recovery approach. Describe options and considerations for single system availability. Given a scenario, determine the security objects and requirements needed to organize the database user environment. Identify the available methods to meet user access auditing requirements.


Define the purpose and benefits of master data management in an enterprise architecture. Identify the benefits of data governance on a growing enterprise data warehouse environment. Identify the benefits of metadata capture on a growing enterprise data warehouse environment.


Given a scenario, determine which alternative is the best choice: in-database analytics, external processing, ROLAP technology, or External Cube technology. Given a scenario, determine when summary tables are necessary. Identify the objects and characteristics of a semantic layer and/or data model. Identify what needs to be considered when developing a data mart solution. Describe the functions of exporting data from a Teradata environment. Describe the implications of designing and managing an ad-hoc environment. Determine options that are available to ensure that business critical reporting requirements are met. Determine strategies that are available to migrate applications from an EDW to another system. Given a scenario, design a recommended view architecture.


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.
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 logged in to the Teradata network).


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.


Exam Administration Policies

Before your exam, review our policies on exam sequencing, recertification, retaking exams, banning, and reinstatement.

View Policies

Security and Privacy Policies

We take your security and privacy very seriously. Learn more about how we're actively ensuring Teradata Certification integrity and what Teradata considers to be a violation. 

View Policies

  • Exam Administration Policies
  • Security and Privacy Policies