Vantage Certified Associate Exam 2.3

About the Exam

Covers the Features and Functionality of Vantage 2.3 and the Advanced SQL Engine Through Release 17.10.

The Associate Exam will certify that the successful candidate has knowledge of the core concepts of Vantage 2.3 and the Advanced SQL Engine. The candidate understands relational database concepts, the major components, core features and functionality, security and privacy, and Teradata data distribution and data access methods—including a basic understanding of Teradata Tools and Utilities. FAQs related to this exam and certification can be found HERE.

REGISTRATION INFORMATION

Register for the Vantage Associate BETA Exam


To register for the Associate Beta Exam, visit home.pearsonvue.com/teradata and select exam: TDVAN1 Associate Beta Exam.

Candidates are able to register and take the Associate Beta Exam either in a Pearson Vue test center or remotely, at their home or office. FAQs and additional information on this option are available. This exam is open for registration on October 21, 2021, and may be taken from November 1, 2021 - January 13, 2022.

  • Exam Details
  • Exam Objectives
  • Exam Prep
RECERTIFICATION REQUIREMENTS

There is NO expiration for this certification.

RECOMMENDED EXPERIENCE 

No Advanced SQL Engine hands-on experience is expected.

CREDENTIALS

Successful completion of this exam will earn you a Vantage Certified Associate 2.3 certification with a digital badge.

PREREQUISITES

This exam does not have any prerequisites.

DURATION

This beta exam allows 90 minutes for answering exam questions whether you are testing in a Pearson Vue test center or with a remote proctor.

COST

The cost of Teradata Associate Beta Exam is $75. Please contact certification.teradata@teradata.com for the voucher.

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

GENERAL CONCEPTS – 19% 

Candidates should have an understanding of relational concepts, the characteristics of a relational database and dimensional model, as well as an understanding of the use cases for deploying relational and dimensional models.

DATA WAREHOUSE ARCHITECTURE – 19%

Candidates should be able to identify the high-level concepts and major components of the data warehouse architecture, deployment options, implementation types, the data flow of data warehouses and the reasons for deploying a data warehouse architecture as well as the scalability options on Cloud and the integration options with Cloud service providers.

TERADATA ADVANCED SQL ENGINE ARCHITECTURE AND COMPONENTS – 24%

Candidates should understand the flow of data from source to consumption, identify the features and benefits, and the purpose of the logical components of the Advanced SQL Engine, the features and benefits and the definitions of objects in the Advanced SQL Engine, be able to identify space classification and how space is used, be able to identify the components of a table definition and the purpose of workload management.

DATA DISTRIBUTION AND ACCESS – 12%

Candidates should be able to identify use cases of Primary, Secondary, and Join indexes, the impact the Primary Index has on data distribution, the differences between Primary Index and Primary Key, the types, levels and functionality of locking and the purpose and components of the access layer.

SECURITY AND PRIVACY – 14%

Candidates should be able to identify user privacy and security mechanisms available to the SQL Engine, features for managing user privileges, and functions and types of authentication.

TERADATA TOOLS AND UTILITIES – 12%

Candidates must be able to identify the common data integration techniques and their uses, the features and functions of the administering and monitoring tools and the common access tools available within the Teradata client tools and their uses. This includes Teradata Studio Express and BTEQ.

RECOMMENDED COURSES

In development. Please note that most exam objectives have not changed and candidates may consider reviewing the database courses (previously available for the Associate exam) available here and here.  Check back for the updated database courses by December 2021. In addition, a FREE, updated Introduction to Vantage web-based training course is also available!

SAMPLE QUESTIONS

In development. Please note that most exam objectives have not changed and candidates may consider reviewing the sample questions available for the Associate Exam.

TERADATA EMPLOYEES ONLY

Log on to the Teradata network and the Teradata Sharepoint site for recommended training.

SOFTWARE DOWNLOADS

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

  • Policies

Exam Administration Policies

Before registering for the exam, familiarize yourself with retaking an exam, recertification of an exam, and the order required for the Vantage Certification Track.

View Policies

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.

View Policies

  • Exam Administration Policies
  • Security and Privacy Policies

Chart of Teradata Certification paths from Associate to Master