Vantage System Architect 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 architect solutions with rigor centered around the Advanced SQL Engine and its interactions with the surrounding ecosystem. This includes system architecture concepts, information management and data governance, performance design and optimization, data integration, data security, system protection, data residency and portability, information delivery, and workload management. FAQs related to this exam and certification can be found here.
Register for the System Architect Exam
Starting October 1, 2019, to register for the System Architect Exam, visit home.pearsonvue.com/teradata and select exam: TDBL 6:16.20 System Architect Exam.
Candidates are able to register and take the System Architect 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 any Teradata 14 certification can bypass the Associate Exam and go directly to the System Architect exam. In those cases, passing the System Architect exam will earn you the System Architect certification. If you are not eligible to bypass the Associate exam, you will have to take the exam in order to earn the System Architect certification.
There is no bypass for the System Architect exam. All candidates are required to take this exam (and prerequisites) if they wish to obtain the System Architect certification.
It is recommended that candidates have more than five (5) years of Teradata ecosystem and Advanced SQL Engine experience and more than three (3) years where system architecture has been part of your job role.
Successful completion of this exam earns a Vantage Certified System Architect Certification with a Digital Badge once all certification requirements are met.
There is NO expiration for this certification.
Passing the Associate Exam is the prerequisite for the System Architect Exam. Candidates who hold any Teradata 14 certification, can bypass the Associate exam.
If you are not eligible to bypass the Associate exam, you will have to take the exam in order to earn the System Architect certification. All requirements must be met for a certification to be awarded.
This exam allows 1 hours and 45 minutes for answering exam questions.
The cost of the Teradata System Architect 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.
SYSTEM ARCHITECTURE CONCEPTS - 14%
Candidates should be able to identify the purposes of different types of metadata, the characteristics of conceptual modeling, the uses and benefits of logical and physical models, strategies for managing system expansion and contraction, the components of an analytic ecosystem and given a scenario, identify the logical model that should be created, how to use an extended logical data model, the strategies to extend traditional application deployment and how to architect a non-production environment.
INFORMATION MANAGEMENT AND DATA GOVERNANCE - 11%
Candidates should be able to identify the benefits of effective master data management and given a scenario, identify which loading strategy should be used, which Teradata data acquisition tool(s) should be used, how to create data for a non-production environment, and the data retention, placement, and archive strategies that should be used.
PERFORMANCE DESIGN - 16%
Candidates should be able to, given a scenario, identify physical design choices for indexes, join indexes, row partitioning, column partitioning, time series data, data types, which statistics should be collected and how often for optimal performance and identify the compression options that should be used along with identifying how to manage tables and their relationship to the MAPS feature.
ARCHITECTING FOR SYSTEM PERFORMANCE - 5%
Candidates should be able to identify the benefits of Teradata Virtual Storage and Teradata Intelligent Memory and given a scenario, identify the Unity components and strategy that should be used.
DATA INTEGRATION - 11%
Candidates should be able to, given a scenario, identify appropriate data transformation strategy(ies), the appropriate method level to organize tightly, loosely and non-coupled data, when and how surrogate keys should be generated or when natural keys should be used, the strategy that should be used to achieve the correct level of data granularity, the design considerations when using complex data types, when integrating temporal data and when integrating geospatial data and including a data model method, identify the benefits and tradeoffs.
DATA SECURITY - 7%
Candidates should be able to identify the security considerations for multi-system environments, the use cases for secure zones and given a scenario, identify which user authentication mechanism should be used, database mechanisms for controlling access to data and how roles can be used to manage privileges for groups of users.
DATA PROTECTION AND SYSTEM AVAILABILITY - 11%
Candidates should be able to, given a scenario, identify the backup and recovery strategy that should be used, design considerations in multi-system data replication and loading, and for disaster recover as well as identify features that provide system protection.
DATA RESIDENCY AND PORTABILITY - 3%
Candidates should be able to, given a scenario, identify the considerations for connectivity and data latency for multiple platforms including those hosted in multiple countries.
INFORMATION DELIVERY - 10%
Candidates should be able to, given a scenario, identify the appropriate business intelligence architectures and the use cases where QueryGrid is beneficial, for different access layers, where sandboxes should be used and where physicalization of the access layer or a dependent datamart is beneficial.
WORKLOAD MANAGEMENT - 12%
Candidates should be able to identify capabilities, benefits and tradeoffs of WM COD, how to leverage workload management using various concepts and given a scenario, how to leverage workload management using state matrix to meet service level goals.
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 55048 Teradata Parallel Transporter
- WBT 55812 Creating Data Mover Jobs
- WBT 53054 Data Stream Architecture
- WBT 51409 Backup and Restore using Teradata Data Stream Architecture
- WBT 56720 Implementing MAPS - the Basics
- WBT 57211 Teradata Unity Architecture
- WBT 49905 Introduction to Temporal Tables
- WBT 56458 Teradata QueryGrid 2.0 Technical Overview
- WBT 56851 Teradata Viewpoint and Data Lab Introduction and Update (16.00 and 16.10)
- WBT 39365 Introduction to Teradata Active System Management (TASM)
- WBT 57993 Introduction to TIWM/Workload Management Portlets
The Teradata Certification team has created sample questions to help you prepare for the exam. Access the System Architect Sample Questions here.
RECOMMENDED COURSES AND DOCUMENTATION CONTINUED
- 9038 Teradata Factory: Vantage Advanced SQL Engine
- 56941 Teradata Parallel Transporter: Vantage Advanced SQL Engine
- 57040 Teradata Database Administration: Vantage Advanced SQL Engine
- 36916 Vantage: Optimizing Advanced SQL Engine through Workload Management
- Teradata User Documentation Teradata Database 16.20
- Teradata Tools and Utilities 16.20
- B035-3150-117K Data Stream Architecture User Guide
- B035-1208-162K Primary time index
- B035-1094-161K Teradata Database Design
- B035-2520-048K Unity
- B035-1100-161K Security Management
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.