Monitoring Vantage |
12% |
This section of the exam measures the skills of IT professionals such as system administrators and database administrators. It covers how to effectively use Viewpoint to investigate system conditions, monitor external queries, and administer both Viewpoint and monitored systems. Additionally, candidates will need to identify constrained system resources and monitor data movement jobs using Viewpoint. |
Performance Management |
23% |
This section of the exam evaluates the skills of IT professionals like performance engineers and database administrators. It focuses on strategies for managing statistics, implementing DBQL logging, and using performance data to troubleshoot and resolve system issues. Candidates are required to understand logging data, optimize queries, assign tables to hash maps, apply advanced indexing strategies, and consider performance implications for table and column design, as well as data access from external sources. |
Security Management & Auditing |
9% |
This section of the exam measures the skills of IT professionals such as security administrators and database managers. It covers the features, functionality, and benefits of access logging and advanced security configurations. Candidates will also learn how to use system log tables for security auditing, understand database and object-level privileges, and configure security for external data access. |
User Administration |
9% |
This section evaluates the skills of system administrators and security managers in meeting user security requirements through roles and proxy access configurations. Candidates will also learn about the functionality and benefits of profiles, as well as the key attributes that should be set for a new user. |
Database Management |
17% |
This section tests the skills of database administrators in managing access rights and advanced analytic functions. It covers logging benefits, privilege types, and the impact of changing global parameters on user sessions. Candidates will also identify recovery tasks after system restarts, determine optimal backup and restore strategies, assess future capacity needs, and manage advanced data types in Vantage table designs. Additionally, it includes managing perm space, temp space, and spool space. |
Workload Management |
18% |
This section assesses the ability of IT professionals, including workload managers and performance engineers, to use TASM features for workload management. It covers classification criteria, filters, throttles, exceptions, and utility management. Candidates will also learn to manage workloads accessing external data, such as NOS and QueryGrid, create dynamic rules using the state matrix, manage advanced analytics workloads, and apply workload management methods and prioritization |
Integration |
12% |
This section tests the skills of database administrators and integration specialists in utilizing integration tools like QueryGrid and NOS. It covers the benefits, features, and functionality of QueryGrid, the database objects supporting its implementation, and the performance implications of accessing NOS and foreign servers. Candidates will also explore the functionality of Data Mover, including job scheduling and error handling, and how it impacts performance during data transfers. |
Official Information |
|
https://www.teradata.com/university/certification/vantage-certifications/administration-exam |