CERTIFICATIONS

Teradata certificaion information copied from Teradata Corporation Links( please find below):

TERADATA CERTIFICATION PROGRAM

http://id.teradata.com/Certification/?LangType=1057&LangSelect=true

EXAM DETAILS
http://in.teradata.com/certification/TE0-141/Basics/?LangType=16393&LangSelect=true#j2

 SAMPLE QUESTIONS
https://courses.teradata.com/learning/corporate/marketing/02014_tcpp/home.htm
Teradata 14 Certified Professional Program exam tracks  

Certification Overview

The Teradata Certified Professional Program (TCPP) team, in partnership with our Teradata education team, exam development partners, premier subject matter experts and an experienced, dedicated Certification team, develop and manage all Teradata Certification tracks.
Teradata 14 Certification Track - This track includes exams covering the features and functionality of the Teradata Database 13.0, 13.10 and 14.0 (including SLES 11).
Teradata 14 Quick Reference Guide – Track highlights and information at a glance.
Teradata Certification, What’s New and How to Prepare – One hour webinar detailing the Certification process.
Teradata Certification Preparation – One page summary of resources to use for exam preparation and where to find available resources

Teradata 14 Certified Professional

A successful candidate has knowledge of the core concepts of the Teradata database and related technologies. The candidate understands relational database concepts, the major components, features, functionality, and Teradata’s data distribution and data access methods. The candidate has an understanding of operational, tactical, strategic business intelligence, and analytical processing.

Required Exam


Teradata 14 Certified Technical Specialist

A successful candidate has core knowledge and skills about Teradata Structured Query Language (SQL) using both ANSI standard conventions and Teradata extensions to the language as well as the core knowledge and skills necessary to design and implement a Teradata Database from a logical data model. The candidate understands the Teradata implementation of data distribution, space usage, data access and data manipulation processes. The candidate can implement a Teradata Database using a set of requirements.

Required Exams (must be passed in sequential order)

Upgrade Option from Teradata 12

Candidate must hold a Teradata 12 Certified Technical Specialist Certification

Teradata 14 Certified Database Administrator

A successful candidate has core knowledge and skills necessary to set up, manage, and maintain a Teradata database environment. The candidate has a thorough understanding of Teradata database concepts, object creation, system and query performance, space management, security, system parameters, workload management, capacity management, and database utilities.

Required Exams (must be passed in sequential order)

Upgrade Option from Teradata 12 (must be passed in sequential order)

Candidate must hold a Teradata 12 Certified Technical Specialist Certification

Teradata 14 Certified Solutions Developer

A successful candidate has the knowledge and skills necessary to design and write optimized applications that integrate and access data in Teradata environments. The candidate leverages the parallelism and data manipulation techniques in Teradata. The candidate makes effective choices and use of available Teradata utilities, features, and functions in developing quality solutions.

Required Exams (must be passed in sequential order)

Upgrade Option from Teradata 12 (must be passed in sequential order)

Candidate must hold a Teradata 12 Certified Technical Specialist Certification

Teradata 14 Certified Enterprise Architect

A successful candidate has knowledge and skills necessary to design enterprise data warehouse architectures with rigor centered around the Teradata environment. This includes information management, optimization, data integration (data source to database target), data protection, data governance, and information delivery strategies. This candidate will incorporate the features of Teradata to ensure integrity and optimum performance.

Required Exams (must be passed in sequential order)

Upgrade Option from Teradata 12 (must be passed in sequential order)

Candidate must hold a Teradata 12 Certified Technical Specialist Certification


Teradata 14 Certified Master

A successful candidate has the knowledge and skills necessary to be a technical authority for designing, implementing, and managing a Teradata enterprise-wide data warehouse. This individual can provide recommendations on all aspects of the data warehouse lifecycle from conceptualization through production implementation and ongoing management and support.

Required Exams (must be passed in sequential order)

Upgrade Option from Teradata 12

Candidate must hold a Teradata 12 Certified Master Credential

Teradata 14 Basics Exam

Purpose of the Exam

This exam will certify that the successful candidate has knowledge of the core concepts of the Teradata database and related technologies. The candidate understands relational database concepts, the major components, features, functionality, and Teradata’s data distribution and data access methods. The candidate has an understanding of operational, tactical, strategic business intelligence, and analytical processing.

Credential Earned

Teradata 14 Certified Professional Certification with Digital Badge

Exam Duration

1 hour 30 minutes*
*The exam duration shown is the amount of time allowed for answering exam questions. The Test Delivery Provider may add time to your total appointment to provide the opportunity to get seated, read the Non-Disclosure Agreement (NDA) and complete the tutorial (if applicable) before you start the exam.  

Language

English and Japanese

Cost

The cost of Teradata exams vary by exam, location and currency. Please visit www.pearsonvue.com/teradata to find the price of an exam where you are located.
Teradata Employees visit the TCPP Connections Group to obtain an employee voucher. (You must be behind the Teradata firewall to access this page)

Prerequisites, Eligibility Requirements and Recommended Experience

This exam has no pre-requisite exam or certification requirements.
Exam TE0-141 does not require an eligibility voucher.
Minimum of 6 months experience working with Teradata technology is recommended.

How to Register

Online - visit www.pearsonvue.com/teradata  
For a list of regional phone numbers visit www.pearsonvue.com/teradata/contact/

Retake Policy

A failed exam may be retaken after a 21 calendar day waiting period. The 21 calendar day waiting period begins from the date of the failed exam attempt.
You will be required to schedule a new appointment and pay for the exam.
You may attempt an exam a maximum of three (3) times during a six (6) month period.

Re-taking the same Teradata 14 exam after passing that exam will not be allowed.

Teradata 14 Certification Exams Objectives

The high level objectives represent the general content areas. The more detailed information below the objective indicates representative topic areas. All Teradata 14 functions and features that fall within the stated objective areas are eligible topics on an exam.

TE0-141 Teradata 14 Basics

  • Data Warehouse Architectures
    • Describe the layers of the Enterprise data warehouse architecture.
    • Identify the components of a data warehouse architecture.
    • Contrast centrally located architectures with physically distributed architectures, such as an appliance.
    • Determine the benefits of centralized data warehouses vs. noncentralized data warehouses.
    • Describe the basic concepts of Teradata Active Solutions (e.g., Active Load, Active Access, Active Events, etc.)
    • Describe the approach of building an application data model vs. Enterprise data model.
     
  • Relational Database Concepts
    • Define the terms associated with relational concepts.
    • Describe the advantages of a relational database.
    • Describe the differences between star schema and third normal form logical models.
    • Describe the characteristics of row vs. set processing.
     
  • Teradata RDBMS Components and Architecture
    • Describe the features or benefits of the Teradata technology.
    • Describe the functionality of components of the Teradata technology.
    • Identify the communication interfaces from external applications to Teradata.
    • Identify application programming interfaces.
     
Keywords: AMPs, PEs, BYNET and ODBC, JDBC, MOSI, mTDP
  • Database Managed Storage
    • Explain the effects of the Primary Index on data distribution and organization.
    • Explain the effects of No Primary Index on data distribution and organization.
    • Describe the differences between Primary Index and Primary Key.
    • Describe the differences between non-partitioned, single level, and multi-level partitioned tables.
    • Identify the benefits of Teradata automatically managed storage vs. DBA manually managed distribution techniques.
    • Define perm space, spool space, and temp space.
    • Describe the concept of multi-temperature data.
    • Identify the storage optimization techniques that exist in Teradata.
    • Identify the differences between Columnar and Row storage.
     
  • Data Access Methods
    • State the reasons for defining a UPI (Unique Primary Index) vs. a NUPI (Non-Unique Primary Index).
    • State the reasons for defining a USI (Unique Secondary Index) vs. a NUSI (Non-Unique Secondary Index).
    • Identify the reasons for using a primary index versus no primary index.
    • Describe the trade-offs between Index access and Full Table Scans.
    • Describe the operation and/or causes of Full Table Scans.
    • State the reasons for defining a PPI (Partitioned Primary Index) and/or Multi-level Partitioned Primary Index.
    • Describe the benefits of join indexes.
    • List the types, levels, and functionality of locking provided by Teradata.
    • Identify the reasons for choosing between Columnar and row storage.
     
  • Data and Performance Availability Features
    • Describe hardware specific data and performance protection techniques.
    • Explain the concept of FALLBACK tables.
    • Describe how Transient Journals ensure data integrity.
    • Describe the concept of node failover.
     
Keywords: journals, node failover, cliques, hot standby, RAID1
  • Teradata Tools and Utilities
    • Identify the features and functions of data integration utilities.
    • Identify the features and functions of the administering and monitoring tools available within the Teradata product suite.
    • Identify the features and functions of the access tools available within the Teradata product suite.
    • Identify the features and functions of the Teradata ARC utility.
    • Identify the tools in the Teradata Analyst Pack.
    • Identify the features and use of Unity Director.
    • Identify the features and use of Unity Data Mover.
     
  • Workload Management
    • Describe the characteristics of work types that Teradata supports.
    • List the purposes of workload management.
    • Describe the characteristics of response time vs. throughput.
     
Keywords: response time, throughput, tactical, strategic, row vs. set processing, workload management tools (TASM, TDWM, Priority Scheduler)
  • Security and Privacy
    • Identify security mechanisms available to Teradata.
    • Identify privacy mechanisms available within Teradata.
     
Keywords: LDAP, single sign-on, passwords, views, macros, UDFs, row level security

Recommended Course

The Teradata Certified Professional Program partners with the Teradata Education Network to provide Teradata courseware and curriculum that specifically relates to each certification level. You can view course descriptions and schedules, and enroll online. Several courses are offered as web-based training (WBT) courseware for your convenience.
Teradata Employees only: visit the Teradata internal TCPP Connections site for more information on recommended Teradata training. (You must be logged in to the Teradata network).

Resources & Preparation Materials

Teradata Certification App (TCaPP)

The TCaPP App is free and provides instant access to: program information, tutorials, Authorized Study Guides, practice question packs, exam registration and results from the convenience of your smartphone or tablet.
Download the App for Android or iOS.

Authorized Study Guide

Authorized Teradata Certification Study Guides are available to support your Teradata Certification goals. Each guide provides focused content, simplified examples and explanations around key objective areas, and help in determining topics for further study prior to sitting for your Teradata Certification exams. The guides are intended as a study companion for individuals who have completed recommended Teradata training courses and who have the suggested experience using Teradata Database technology.
Teradata 14 Certification Study Guide
Note: The Teradata Certification Study Guides and Apps are the only authorized study guide publications in the market. The Teradata Certified Professional Program partners with Cerulium Corporation to author the Teradata Certification Study Guides and develop mobile applications.

Sample Questions

Sample questions are designed to give you an example of the format and types of questions on the actual Teradata Certification exams. The sample questions are not intended to duplicate items on the actual exams. Questions are rotated and will be slightly different each time.  
The sample questions are offered on-line free of charge and are not “scored” or tracked. Practice at your own pace and as often as you want.  
More sample questions are available for purchase through the Teradata Certification App (TCaPP) and end of chapter questions are included with the Authorized Study Guides.

Documentation and Downloads

Documentation: Search and access Teradata installation, programming, operations and service guides, and reference manuals.
Software Downloads: are available through Teradata Developers Exchange to help you prepare through hands on application.

6 comments:

  1. rmouniak27 June 2018 at 18:23

    Learned a lot of new things from your post ,It's amazing article
    Sql server DBA Online Course India

    ReplyDelete
  2. ASTSTraining28 July 2018 at 21:54

    Thank you for sharing valuable information.This article is very useful for me valuable info about
    Teradata Online Training.keep updating.........

    ReplyDelete
  3. Folks IT30 March 2021 at 13:19

    Teradata Developer Training Get practical exposure on creating and managing the databases and become a master in data analytics from folks IT.

    ReplyDelete
  4. taranstech4 June 2021 at 17:27

    I appreciate for sharing such a nice information on Microsoft SQL Certification

    ReplyDelete
  5. Gayathri Infra23 November 2021 at 16:58

    nice article, we are selling realestate propertys at Gayathrie Farmlands

    ReplyDelete
  6. Blogger24 October 2023 at 16:39

    We sell any brand marked cards! Do not be afraid to ask if we sell a certain brand. Visit here: Marking cards

    ReplyDelete

Subscribe to: Posts (Atom)