Vantage Developer Exam
IMPORTANT NOTE: This exam is NO LONGER available after December 31, 2022!
Covers the features and functionality of the Advanced SQL Engine through release 16.20.
A successful candidate has the knowledge and skills necessary to design and write optimized SQL that acquires, integrates and accesses data in Teradata environments. They have knowledge of database design concepts and indexing strategies for query and ETL development. Successful candidates can effectively use the Advanced SQL Engine features, tools and utilities. FAQs related to this exam and certification can be found here.
To register for the Developer Exam
To register for the Developer Exam, visit home.pearsonvue.com/teradata and select exam: TDBL 4:16.20 Developer Exam.
Candidates are able to register and take the Developer Exam either in a Pearson Vue test center or remotely, at their home or office. FAQs and additional information on this option are available.
Already Certified in Teradata 14?
Candidates who hold Teradata 14 Technical Specialist, Solutions Developer, Enterprise Architect, Database Administrator, and Master certifications can bypass the Associate and Developer Exam and take the next track progression exam—Advanced Developer.
Exam details
RECOMMENDED EXPERIENCE
It is recommended that candidates have approximately one (1) year of Advanced SQL Engine experience.
CREDENTIALS
Successful completion of this exam will earn you a Vantage Certified Developer Certification with a Digital Badge once all certification requirements are met.
RECERTIFICATION REQUIREMENTS
There is NO expiration for this certification.
PREREQUISITES
Passing the Associate Exam is the prerequisite for the Developer Exam. All requirements must be met for a certification to be awarded.
DURATION
This exam allows 130 minutes (including administration time)
COST
The cost of the Teradata Developer Exam is $249. Please visit home.pearsonvue.com/teradata for details. Bulk discount vouchers for 10 or more exams can be purchased through Pearson Vue.
Exam objectives
For more details regarding specific exam objectives, download this PDF.
BASIC SQL CONCEPTS – 40%
Candidates should understand basic SQL concepts including syntax, characteristics of macros, stored procedures, permanent tables, table level attributes, CREATE TABLE AS, referential integrity, indexes, views, triggers, temporary tables, regular expressions, functions, characteristics of column level attributes, data types, constraints, joins, subqueries, syntax usage, characteristics of SELECT, INSERT, UPDATE, DELETE, and MERGE statements.
SOLUTION DEVELOPMENT PROCESS AND CONSIDERATIONS – 17%
Candidates should have a good understanding of Teradata's solution development process and considerations including types and purposes of indexes, partitioning strategies, logical and physical database design, roles, profiles, and privileges.
ACCESS LAYER AND DATA DELIVERY STRATEGIES – 3%
Candidates should understand access layer and data delivery strategies.
TRANSACTION PROCESSING AND LOCK MANAGEMENT – 10%
Candidates should understand Teradata's transaction processing and lock management including types of locking and lock levels, implications of using different transaction modes, differences between transaction, request, and statement, and impact of session characteristics on requests.
SOLUTION OPTIMIZATION – 16%
Candidates should understand solution optimization including the tuning process including improving an existing application, designing and populating effective performance testing environments, using DBQL data, and identifying performance tuning considerations.
DATA INTEGRATION STRATEGIES – 14%
Candidates should understand data integration strategies including TPT LOAD, EXPORT, UPDATE, and STREAM operators, optimal load strategies, and BTEQ and Teradata Studio Suite.
Exam prep
PREPARING FOR YOUR EXAM
The Teradata Certification partners with the Teradata University to provide Teradata courseware and curriculum that relates to each exam.
Please note that these courses are recommended and not required. Taking or passing a course does not guarantee passing of any Teradata Certification exam.
Additional training may need to be taken in order to cover all of the objectives on the exam. You can view course descriptions and schedules, and enroll online.
SAMPLE QUESTIONS
The Teradata Certification team has created sample questions to help you prepare for the exam. Access the Developer Sample Questions here.
RECOMMENDED COURSES AND DOCUMENTATION
The provided links to these FREE courses are for Guest users. If you are already registered in Teradata University, login to your account and search on any of the Course numbers.
Policies
Exam administration policies
Before your exam, review our policies on exam sequencing, recertification, retaking exams, banning, and reinstatement.
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.
