Buy on Amazon now!
Buy on Appl iBooks now!
Buy on Kobo books now!

Teradata Certification Enterprise Architecture Guide (V14)

The Teradata Certification Enterprise Architecture Study Guide is designed for those who are interested in becoming a Teradata Certified Enterprise Architect. Through detailed examples, and explanations this guide prepares the reader to take the Teradata 14 Enterprise Architecture Exam.

  •  Database Architecture
  • Connectivity Options and Protocols
  • Logical and Physical Modeling
  • Security Techniques and Options
  • Workload Management
  • Application Development Approaches
  • System Planning and Space Management
  • Data Integration
  • Information Delivery Strategies
  • Data Migration and Governance
  • Master Data Management
  • Measuring, Improving, and Maintaining Performance

The Teradata 14 Certification Study Guides are the only Teradata authorized study publications. Cerulium Corporation partners with Teradata and the Teradata Certified Professional Program to author the Teradata 14 Certification Study Guides.

Teradata 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.”*

Teradata Certification Enterprise Architecture Exam TEO-146 is required for:

  • Teradata Certified Enterprise Architect
  • Teradata Certified Master

 


Chapter 1: The Teradata Certified Professional Program              

  • Pursue Teradata Certification with Confidence™
  • Your Teradata 14 Certification Upgrade Roadmap
  • Certification… Knowledge Building to Mastery
  • Path to Teradata 14 Mastery
  • Exam Registration
  • Where to Find More Information

Chapter 2 – Architecture             

  • Teradata Certification Enterprise Architecture Objectives
  • Before You Begin
  • Nodes
  • Operating System
  • Dual Systems
  • Cliques
  • Hot Standby Node
  • Space Allocation
  • TVS
  • Databases
  • Tables
  • Fallback
  • Indexes
  • Chapter 2: Practice Questions

Chapter 3 – Client Environment

  • Teradata Certification Enterprise Architecture Objectives
  • Before You Begin
  • TTU
  • Connectivity Protocols
  • Connectivity Options
  • Chapter 3: Practice Questions

Chapter 4 – LDM/PDM  

  • Teradata Certification Enterprise Architecture Objectives
  • Before You Begin
  • 3NF LDM to PDM
  • Data Volatility
  • ELDM Template
  • Semantic Layer
  • PDM Changes to LDM
  • Chapter 4: Practice Questions

Chapter 5 – Security      

  • Teradata Certification Enterprise Architecture Objectives
  • Before You Begin
  • Logons
  • Users
  • Passwords
  • Profiles
  • Lightweight Directory Access Protocol (LDAP)
  • Access Rights
  • Roles
  • Encryption
  • Stored Procedures
  • Personally Identifiable Information (PII)
  • Network Security
  • Access Logging/Monitoring
  • Account Strings
  • Views
  • Chapter 5: Practice Questions

Chapter 6 – Workload Management       

  • Teradata Certification Enterprise Architecture Objectives
  • Before You Begin
  • Teradata Active Systems Management
  • Viewpoint Workload Designer
  • Priority Scheduler
  • Resource Partitions and Performance Groups
  • Schmon Utility
  • Teradata Workload Analyzer
  • Teradata Query Scheduler
  • Teradata Unity Director
  • Chapter 6: Practice Questions

Chapter 7 – Application Deployment     

  • Teradata Certification Enterprise Architecture Objectives
  • Before You Begin
  • Test Environments
  • Capturing Authoritative Data
  • Estimating Space Requirements
  • Production System Impact
  • Measuring Changes
  • Chapter 7: Practice Questions

Chapter 8 – System Planning and Space Management  

  • Teradata Certification Enterprise Architecture Objectives
  • Before You Begin
  • Transient Journal
  • Dictionary Tables
  • CRASHDUMP
  • PDE DUMP
  • Archive and Recovery Utility (ARC)
  • Archive Strategies
  • Minimizing User Impact
  • Determining Space Shortages
  • PACKDISK
  • Shared Resources
  • Ingesting Data – Planning for growth
  • Chapter 8: Practice Questions

Chapter 9 – Data Integration      

  • Teradata Certification Enterprise Architecture Objectives
  • Before You Begin
  • FastLoad
  • MultiLoad
  • FastExport
  • TPump
  • BTEQ
  • Teradata Parallel Transporter
  • SQL Merge
  • NUPI
  • Partitioned DML
  • Teradata Columnar
  • Recursive Views
  • Metadata Management
  • Chapter 9: Practice Questions

Chapter 10 – Data Migration       

  • Teradata Certification Enterprise Architecture Objectives
  • Before You Begin
  • Data Marts
  • Strategies
  • BTEQ
  • TPT
  • ARC
  • Dual System Architecture
  • Costs
  • Security
  • Privacy
  • Data Governance
  • Master Data Management (MDM)
  • Change Control Management
  • Chapter 10: Practice Questions

Chapter 11 – Measuring Performance    

  • Teradata Certification Enterprise Architecture Objectives
  • Before You Begin
  • SLA Statistics
  • Index Choices
  • DBQL
  • ResUsage
  • Specifying ResUsage Tables and Logging Rates
  • Full Table Scans
  • AmpUsage
  • Explain
  • Joins
  • Analytical Processing Choices
  • Chapter 11: Practice Questions

Chapter 12 – Improving Performance     

  • Teradata Certification Enterprise Architecture Objectives
  • Before You Begin
  • Teradata Index Wizard
  • Teradata Statistics Wizard
  • Teradata Visual Explain
  • Teradata System Emulation Tool (TSET)
  • System Resources
  • Dictionary Objects
  • ELT vs. ETL
  • Compression
  • Surrogate Keys
  • Changing Indexes
  • Queries and Joins
  • Summary Data
  • Chapter 12: Practice Questions

Chapter 13 – Maintaining Performance 

  • Before You Begin
  • Ad hoc Environment
  • Tactical and Workload Consistency
  • Chapter 13: Practice Questions

 

Paperback: 339 pages
Publisher: Cerulium Corporation (2014)
ISBN: 978-0989400558

In Stock: Yes

* http://www.teradata.com/Certification

2017-03-23T17:58:47+00:00