Teradata database

DBA Exam

about the exam

Covers features and functionality of the Teradata Database through release 16.10.

This exam establishes candidate has core knowledge and skills necessary to manage archives, plan capacity requirements, identify optimal database and table design including indexing options, use database tools and utilities, manage performance and usage data, produce security auditing reports, monitor and manage database space, administer users, manage system logging options, manage database privileges, and identify relevant workload management components.

  • Exam Details
  • Exam objectives
  • Exam Prep
RECERTIFICATION REQUIREMENTS

DBA certification expires in three years. Pass the same exam to maintain this certification or earn the Teradata Database Advanced DBA certification. Earning this certification extends the Teradata Database Associate certification expiration date.

RECOMMENDED EXPERIENCE 

A minimum of one to three years hands-on experience with Teradata Database and applications is recommended.

CREDENTIALS

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

PREREQUISITES

Successfully passing the Associate Exam is a prerequisite. Any candidate with a Teradata 14 certification may bypass this exam. Those with a bypass exam do not earn that certification.

DURATION

This exam allows 2 hours 45 minutes 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. Bulk discount vouchers for 10 or more exams can be purchased through Pearson VUE.

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

ARCHIVE MANAGEMENT — 7% 

Through scenario-based questioning, candidates should be able to identify the considerations that should be evaluated when scheduling an archive through Backup and Recovery (BAR) management. 

CAPACITY PLANNING — 8%

Candidates should be able to identify the source of disk space data for capacity planning and understand the limitations of the proposed data set.

DATABASE DESIGN AND INDEXING — 9%

Candidates should be able to identify the features and functionality of row and column partitioning, temporal offerings, proper indexing strategy for a table, as well as identify the types and effectiveness of various compression options. 

DATABASE TOOLS AND UTILITIES — 8%

Through scenario-based questioning, candidates should be able to  identify the optimal tool or utility to remediate a problem or accomplish a task. Data Labs, Studio Suite, and Viewpoint are referenced in these scenarios.

PERFORMANCE MANAGEMENT — 14%

Through scenario-based questioning, candidates need to identify options, features, and functionality of statistics collections.  

SECURITY MANAGEMENT AND AUDITING — 10%

Candidates will be able to identify features, functionality and benefits of access logging and logonoff view.

SPACE MANAGEMENT — 8%

Candidates should be able to identify the methods and processes to manage and monitor permspace, temp, and spool space.

USER ADMINISTRATION — 11%

Through scenario-based questioning, candidates should understand the ins and outs of user security requirements, limitations, and associated benefits of assigning privileges.

DATABASE MANAGEMENT - 12%

Through scenario-based questioning, candidates should be able to identify the access rights and privileges that should be granted to a database, table, or view. This includes metrics and system performance factors. 

WORKLOAD MANAGEMENT - 13%

Through scenario-based questioning, candidates should be able to identify the TIWM and TASM workload management components that should be used. 

PREPARING FOR YOUR EXAM

The Teradata Certified Professional Program partners with the Teradata Education Network to provide Teradata courses and curriculum that relate to each exam.

These courses are recommended and not required. Taking or passing any of these courses does not guarantee passing of any TCPP certification exam.

Additional training may be needed in order to cover all of the objectives on the exam. You can view course descriptions and schedules, and enroll online.​

SOFTWARE DOWNLOADS

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

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.

  • Policies

Exam Administration Policy

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 Policy
  • Security and Privacy Policies

Registration Information

Register for the Teradata Database DBA Exam

To get registered for the Teradata Database DBA Exam, visit home.pearsonvue.com/teradata and select exam: TDBL2-16.10 DBA Exam.
Testing begins July 17.

bypass this exam

Already Certified in Teradata 14?

Teradata 14 Database Administrator and Master certification holders can bypass the Associate and Developer Exam to take the next track progression exam—Advanced DBA.