TERADATA 14

Teradata 14 Basics

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 the 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 has understands operational, tactical, strategic business intelligence, and analytical processing.  

  • EXAM DETAILS
  • EXAM OBJECTIVES
  • EXAM PREP
RECOMMENDED EXPERIENCE

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

CREDENTIALS

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

PREREQUISITES

This exam has no pre-requisite exam or requirements.

DURATION

This exam allows two (2) hours for answering exam questions. 

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.

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.

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.

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

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.

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.

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.

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

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 and privacy mechanisms available to Teradata.
Keywords: LDAP, single sign-on, passwords, views, macros, UDFs, row level security 

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

SAMPLE QUESTIONS

The TCPP team has created sample questions to help you prepare for the exam. Access the Teradata Database Sample Questions here.

SOFTWARE DOWNLOADS

Available through Teradata Developers Exchange to help you prepare with hands on application.

TERADATA EMPLOYEES ONLY

Log on to the Teradata network and the TCPP Connections site for recommended training.

  • POLICIES

Exam Administration Policies

Before registering for the exam, familiarize yourself with retaking an exam, recertification of an exam, and the order required for the Teradata 14 Certification track. 

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

To register for the Teradata 14 Basics Exam,
visit home.pearsonvue.com/teradata and select exam TEO-141.
For a list of regional phone numbers visit home.pearsonvue.com/teradata/contact/.

bypass this exam

Already Certified in Teradata 12?

Teradata 12 Technical Specialist, Database Administrator, Solution Developer, Enterprise Architect and Master certification holders can bypass the Basics, SQL, and Physical Design and Implementation Exam to take the Teradata 14 Bridge from Teradata 12 Exam (TE0-14B). Certifications are not awarded for exams that are bypassed.