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.

  • EXAM DETAILS
  • EXAM OBJECTIVES
  • EXAM PREP
RECOMMENDED EXPERIENCE

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

CREDENTIALS

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

PREREQUISITES

Successfully completing the Teradata 14 Basics Exam (TE0-141), plus Teradata 14 SQL Exam (TEO-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. Upgrade paths from Teradata 12 are available. 

DURATION

This exam is 1.75 hours in length.

COST

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

GENERAL CONCEPTS

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

SYSTEM PLANNING AND SPACE MANAGEMENT

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.

OPTIMIZATION

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.

DATA INTEGRATION (DATA SOURCE TO DATABASE TARGET)

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.

DATA PROTECTION

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.

DATA GOVERNANCE

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.

INFORMATION DELIVERY STRATEGIES

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.

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 Application Utilities
Teradata Parallel Transporter
Teradata Warehouse Administration
Teradata Warehouse Management
Teradata Application Design and Development

SAMPLE QUESTIONS

Sample questions provide an example of the format and types of questions on the actual Teradata Certification exams. The practice 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.
 

teradata employees

Visit the Teradata internal TCPP Connections site for more information on recommended Teradata training. (You must be logged in to the Teradata network).
 

  • POLICIES

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 TCPP integrity and what Teradata considers to be a violation. 

View Policies

  • Exam Administration Policies
  • Security and Privacy Policies

REGISTRATION INFORMATION

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

Register Now