Vantage Advanced Administrator Exam
IMPORTANT NOTE: This exam is NO LONGER available after December 31, 2022!
Covers features and functionality of the Advanced SQL Engine through release 16.10.
This exam establishes 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. FAQs related to this exam and certification can be found here.
Register for the Vantage Advanced Administrator Exam
To register for the Advanced Administrator Exam, visit home.pearsonvue.com/teradata and select exam: TDBL 3:16.10 Advanced Administrator/Advanced DBA Exam.
Candidates are able to register and take the Advanced Administrator 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 Database Administrator and Master certification holders can bypass the Associate and Administrator Exam to take the next track progression exam—Advanced Administrator.
There is no bypass for the Advanced Administrator Exam.
Exam details
RECERTIFICATION REQUIREMENTS
There is NO expiration for this certification.
CREDENTIALS
Successful completion of this exam will earn you a Vantage Certified Advanced Administrator certification with a digital badge.
DURATION
This exam allows 130 minutes (including administration time)
RECOMMENDED EXPERIENCE
A minimum of two to three years hands-on experience with Advanced SQL Engine and applications is recommended.
PREREQUISITES
Successfully passing the Associate and Administrator Exams are prerequisites. Any candidate with a Teradata 14 certification may bypass this exam. Those with a bypassed exam, do not receive the actual certification. Only those taking and passing the certification exam receive that certification.
COST
The cost of the Teradata Advanced Administrator Exam is $299. 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.
ARCHIVE MANAGEMENT - 8%
Given a scenario, identify the optimal archive strategy (Backup and Recovery (BAR)) for a database object or system. Given a scenario, identify the optimal restore strategy for a database object or system under failure conditions or unique restoration requirements. Given a scenario, identify appropriate use of DSA. (This includes DSE and DSU)
DATABASE DESIGN AND INDEXING - 12%
Given a scenario, identify the optimal implementation of row and/or column partitioning. Given a scenario, identify optimal ANSI temporal implementation. Given a scenario, identify the proper advanced indexing strategy for a table. Given a scenario, identify the optimal compression strategy (for example: MVC, ALC, BLC, columnar compression, temperature-based compression, and fallback only copy). Identify the technique used for a given layer (for example: modeling techniques per layered framework (acquisition, integration, access). Identify the features and implications of using advanced data types and enhanced table design options (for example: JSON and BSON).
WORKLOAD MANAGEMENT - 15%
Through scenario-based questioning, candidates should be able to identify: TIWM solution, TASM solution, and how to use Query Banding, throttles, exceptions, and utility workload limits for workload management.
SPACE MANAGEMENT - 8%
Identify the features, functionality, and benefits of global space accounting. Identify the purpose of FreeSpace Percent and which utilities benefit from it. Given a scenario, identify the advanced space management utility that should be used.
DATABASE MANAGEMENT - 12%
Given a scenario, identify the system macro that execute privilege is required to be granted. Given a scenario, identify how to project when requested resources will exceed defined thresholds. Given a performance troubleshooting scenario, identify the likely cause of the problem and how to identify it. Identify the effects on a user session of changing a DBS control parameter. Identify reasons to have a planned system restart. Identify how to monitor an unplanned system restart. Given a scenario, identify the process that can be used to identify and repair a corrupted table. Identify the details that are required to create a QueryGrid Foreign Server. Identify QueryGrid performance considerations. Identify the features, functionality, and benefits of MAPS.
CAPACITY PLANNING - 10%
Given a scenario of increased customer demand, identify major system resource trends and future capacity needs. Given a scenario, analyze system CPU and system I/O data for capacity planning purposes. Given a scenario, analyze AWT usage data for capacity planning purposes. Given a scenario, analyze session data for capacity planning purposes.
DATABASE TOOLS AND UTILITIES - 7%
Given a scenario, identify the process that should be used to setup and administer a Viewpoint system (for example: LDAP configuration, Viewpoint (cache) database backup, user definition, roles definition, and alert infrastructure). Given a scenario, identify the process that should be used to setup and administer a monitored system (for example: system definition, data collectors, alert setup, and remote console).
SECURITY MANAGEMENT AND AUDITING - 8%
Identify the features, functionality and benefits of secure zones. Identify the features, functionality and benefits of advanced security configurations (for example: TD Wallet, LDAP, Kerberos, SSO, logon rules, IP Filter, etc.).
USER ADMINISTRATION - 7%
Given a scenario, identify how to meet specific 3-tier data access requirements. Identify the features and components of account string expansion and where and why it is used. Given a scenario, identify how to protect certain data values from unauthorized access.
PERFORMANCE MANAGEMENT - 13%
Given a scenario, identify the optimal statistics to collect, implement, and manage (for example: Statistics Manager, Auto statistics jobs [recollect, analyze]). Identify the features, functionality, and benefits of Teradata Intelligent Memory (TIM). Given a scenario, identify the source of the data (for example: XML and XML Lock Table). Given a scenario, identify what ResUsage data is used to isolate the cause of a performance issue. Given a scenario, identify the process, methodology, and tools to troubleshoot a blocking condition. Given a scenario, identify how to analyze and remediate sub-optimal queries. Given a scenario, identify the implications in performance and efficiency when moving tables from one MAP to another. Given a scenario, identify the effects of partition locking. Given a scenario, identify how to implement load isolation.
Exam prep
PREPARING FOR YOUR EXAM
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.
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.
- WBT 26348 Introduction to the Teradata Database
- WBT 53054 Teradata Data Stream Architecture (DSA)
- WBT 56458 Teradata Query Grid 2.0 Technical Overview
- WBT 56792 Introduction to ANSI Temporal Tables
- WBT 51409 Backup and Restore using Teradata Data Stream Architecture (DSA)
- WBT 49905 Introduction to Temporal Tables
- WBT 51253 Automated Statistics Management
- WBT 51283 In-Memory the Intelligent Way with Teradata Intelligent Memory
- WBT 56720 Implementing MAPS - the Basics
- WBT 54172 Teradata Database 15.10 Overview
- WBT 39365 Introduction to Teradata Active System Management
- WBT 57993 Introduction to TIWM/Workload Management Portlets (Webcast)
- WBT 56458 Teradata QueryGrid 2.0 Technical Overview
SOFTWARE DOWNLOADS
Available through Teradata Developers Exchange to help you prepare with hands on application.
SAMPLE QUESTIONS
The Teradata Certification team has created sample questions to help you prepare for the exam. Access the Advanced Administrator Sample Questions here.
RECOMMENDED COURSES AND DOCUMENTATION CONTINUED
- Advanced Administrator Guide
- 57040 Teradata Database Administration: Vantage Advanced SQL Engine
- 36916 : Vantage: Optimizing Advanced SQL Engine through Workload Management
- 56941 Teradata Parallel Transporter: Vantage Advanced SQL Engine
- B035-3150-117K Data Stream Architecture User Guide
- B035-1093-161K Database Administration Release 16.10
- B035-1094-161K Teradata Database Design
- B035-2206-067K: Teradata Viewpoint User Guide Release 16.10
- B035-1099-161K: Teradata Database Resource Usage Macros and Tables
- B035-1100- 161K: Teradata Database Security Administration
- B035- 1149-161K SQL Data Definition Language, TD 16.10
- B035-5991-201K Teradata QueryGrid Installation and User Guide Release 2.01
- B035-1197-161K Teradata Workload Management
- B035-1091-162K Database Introduction
- B035-1093-162K Database Administration 16.20
- B035-1142-161K Partition Locking
- B035-1100-162K NewSQL Engine Security Administration
Policies
Exam administration policies
Before your exam, review our corporate 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.
