Teradata database

Associate Exam

About the exam

Covers the Features and Functionality of the Teradata Database Through Release 16.00.

This exam will certify that the successful candidate has knowledge of the core concepts of the Teradata Database. The candidate understands relational database concepts, the major components, core features and functionality, security and privacy, and Teradata data distribution and data access methods—including a basic understanding of Teradata Tools and Utilities.

REGISTRATION INFORMATION

Register for the Teradata Database Associate Exam

To register for the Teradata Database Associate Exam, visit home.pearsonvue.com/teradata and select exam: TDBL 1:16.00 Associate Exam.

Starting April 1, 2019, candidates will be able to register and take the Associate Exam either in a Pearson Vue test center or remotely, at their home or office. FAQs and additional information on this option is available. 

Bypass this Exam

Already Certified in Teradata 14?

All Teradata 14 certification holders can bypass the Associate Exam and take any Teradata Database job role exam—DBA, Developer, or System Architect.
 

  • Exam Details
  • Exam Objective
  • Exam Prep
RECERTIFICATION REQUIREMENTS

Associate Certification expires after five years, requiring another passing grade on the same exam or passage of another exam in the track.

RECOMMENDED EXPERIENCE 

No Teradata Database hands-on experience is expected.

CREDENTIALS

Successful completion of this exam will earn you a Teradata Database Certified Associate certification with a digital badge.

PREREQUISITES

This exam does not have any prerequisites

DURATION

This exam allows 75 minutes for answering exam questions whether you are testing in a Pearson Vue test center or with a remote proctor.

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. Bulk discount vouchers for 10 or more exams can be purchased through Pearson VUE. 

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

DATABASE CONCEPTS – 16% 

Candidates should have an understanding of relational concepts, the characteristics of a relational database and dimensional model, as well as an understanding of the use cases for deploying relational and dimensional models.

DATA WAREHOUSE ARCHITECTURE – 17%

Candidates should be able to identify the high-level concepts and major components of the data warehouse architecture, deployment options, implementation types, and the data flow of data warehouses. 

ARCHITECTURE AND COMPONENTS – 21%

Candidates should understand the flow of data from source to consumption, identify the features and benefits, and the purpose of both physical and logical components of the Teradata Database. 

DATA DISTRIBUTION AND ACCESS – 19%

Candidates should be able to identify use cases of Primary, Secondary, and Join indexes, the impact the Primary Index has on data distribution, and the differences between Primary Index and Primary Key. 

SECURITY AND PRIVACY – 19%

Candidates should be able to identify user privacy and security mechanisms available to the Teradata Database, features for managing user privileges, and functions and types of authentication.

TERADATA TOOLS AND UTILITIES – 14%

Candidates must be able to identify the common access tools available within the Teradata client tools and their uses. This includes Teradata Studio Express, Teradata App Center and BTEQ.

RECOMMENDED COURSES

The TCPP partners with Teradata Education Network to provide courses that relate to each exam.

SAMPLE QUESTIONS

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

TERADATA EMPLOYEES ONLY

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

SOFTWARE DOWNLOADS

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

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