TERADATA DATABASE

Advanced Developer BETA Exam

About the exam

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

The Advanced Developer Exam is available in BETA format and has a limited number of testing opportunities. If you are interested in taking the beta exam, email the Teradata Certified Professional Program (TCPP) team. If seats are available, your credentials will be reviewed, and an invitation will be emailed to you.

This exam establishes that the candidate has the knowledge and skills necessary to; identify optimal archive and restore strategies, analyze system resource trends to plan for future requirements, identify optimal database and table design, translate logical data model to physical data model, administer and setup Viewpoint, identify and use collected data to isolate and resolve performance issues, identify the benefits of advanced security configurations, use the advanced space management features, create user definitions to meet advanced data access requirements, troubleshoot performance and system issues, design and implement workload management.

important beta exam information and faqs 
  • You must obtain an eligibility voucher before registration.
  • Registration and testing for beta exams is completed through Pearson VUE, and may not be offered at all testing centers. Contact Pearson VUE to locate the closest available testing center. Fees are discounted price and collected at registration. Use your unique Teradata (TDC) testing ID during the registration process.
  • You must complete a brief survey before the exam to help determine overall knowledge level and experience of all beta testers. The information is used collectively, not individually, is confidential, and will be used for beta statistical purposes only. Survey information is not scored or used to determine overall score.
  • Beta exams contain more questions than live exams. Responses are used to determine the validity of each question and contribute to the live exam. Candidates taking a beta exam will be scored on the same set of questions as candidates taking the live version of the exam.
  • Comments will be collected on individual questions during the exam. As a beta candidate, you are encouraged to provide feedback during the exam.
  • Results will be collected and analyzed after the beta period ends. Your exam results will be sent by email early in 2019. 
  • Passing a beta exam is equivalent to passing a live version of the exam and the certification will be awarded after all requirements have been met. 
  • A candidate may take a specific beta exam one time only. Candidates must wait until the live version is available to retake the exam.
  • Reference materials to prepare for the beta exam and the Developer Beta Exam Objectives are available.

For more information, download the BETA Exam FAQs, or email TCPP.

REGISTRATION INFORMATION

Register for the Certified Advanced Developer BETA Exam

Registration for the Advanced Developer BETA Exam opens on September 1, 2018 and testing is held September 20, 2018 to December 14, 2018.

All BETA exams must be completed during this testing window. Registration is online through our testing vendor, Pearson VUE. For a list of regional phone numbers visit home.pearsonvue.com/teradata/contact/

Bypass options 

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 to take the next track progression exam—Advanced Developer.

There is no bypass for the Advanced Developer Exam. You must pass this exam to achieve Teradata Database certification. 

  • exam details
  • exam objectives
  • Exam Prep
RECOMMENDED EXPERIENCE 

It is recommended that candidates have 2-3 years of Teradata Database experience.

CREDENTIALS

Successful completion of this exam will earn you a Teradata Database Advanced Developer Certification with a digital badge once all other certification requirements are met.

PREREQUISITES

There are no prerequisites for participating in the beta exam. Successfully passing the Associate and Developer Exams are prerequisites for testing when this exam is live. All requirements must be met for a certification to be awarded. 

COST

The beta exam is offered at $75, a significant discount off the live exam cost.

RECERTIFICATION REQUIREMENTS

Advanced Developer certification expires in three years. Pass the same exam to maintain this certification. Earning this certification extends the Teradata Database Associate and Developer certification expiration dates.

duration

5 hours for BETA exam questions.

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

solution development process and considerations - 19%

Teradata's solution development process and considerations including types and purposes of indexes, partitioning strategies, logical and physical database design, roles, profiles, and privileges, and statistics.

transaction processing and lock management - 10%

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. 

ACCESS LAYER AND DATA DELIVERY STRATEGIES - 12%

Access layer and data delivery strategies.

DATA INTEGRATION STRATEGIES - 12%

Data integration strategies including MLOADX, optimal load strategies, and data integration into temporal and columnar tables.

SOLUTION OPTIMIZATION - 14%

Solution optimization including the tuning process including improving an existing application, designing and populating effective performance testing environments, MAPS, and identifying performance tuning considerations.

ADVANCED SQL CONCEPTS - 33%

Advanced SQL concepts including syntax, usage, and characteristics of macros, stored procedures, permanent tables, table level attributes, CREATE TABLE AS, Referential Integrity, indexes, views, triggers,  temporary tables, regular expressions, functions, usage and characteristics of column level attributes, data types, constraints, joins, subqueries, syntax usage and characteristics of ALTER TABLE, SELECT, INSERT, UPDATE, DELETE, and MERGE statements.

preparing for your exam

  • The Teradata Certified Professional Program partners with the Teradata Education Network 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 TCPP 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.

  •  

  • policies

Exam Administration Policies

Before your exam, review our policies on exam sequencing, recertification, retaking exams, banning, and reinstatement.

VIEW EXAM 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 SECURITY POLICIES

  • Exam Administration Policies
  • Security and Privacy Policies