Vantage Administrator Exam

ARCHIVE MANAGEMENT — 7%
Through scenario-based questioning, candidates should be able to identify the considerations that should be evaluated when scheduling an archive through Backup and Recovery (BAR) management. 

DATABASE DESIGN AND INDEXING — 9%
Candidates should be able to identify the features and functionality of row and column partitioning, temporal offerings, proper indexing strategy for a table, as well as identify the types and effectiveness of various compression options. 

PERFORMANCE MANAGEMENT — 14%
Through scenario-based questioning, candidates need to identify options, features, and functionality of statistics collections.  

SPACE MANAGEMENT — 8%
Candidates should be able to identify the methods and processes to manage and monitor permspace, temp, and spool space.

DATABASE MANAGEMENT - 12%
Through scenario-based questioning, candidates should be able to identify the access rights and privileges that should be granted to a database, table, or view. This includes metrics and system performance factors.

CAPACITY PLANNING — 8%
Candidates should be able to identify the source of disk space data for capacity planning and understand the limitations of the proposed data set.

DATABASE TOOLS AND UTILITIES — 8%
Through scenario-based questioning, candidates should be able to  identify the optimal tool or utility to remediate a problem or accomplish a task. Data Labs, Studio Suite, and Viewpoint are referenced in these scenarios.

SECURITY MANAGEMENT AND AUDITING — 10%
Candidates will be able to identify features, functionality and benefits of access logging and logonoff view.

USER ADMINISTRATION — 11%
Through scenario-based questioning, candidates should understand the ins and outs of user security requirements, limitations, and associated benefits of assigning privileges.

WORKLOAD MANAGEMENT - 13%
Through scenario-based questioning, candidates should be able to identify the TIWM and TASM workload management components that should be used.