Sybase ASE 15 Certification

Just found the Sybase ASE 15 Certification with Exam Topics –

http://www.sybase.co.uk/support/education/professionalcertification/adaptiveserverenterprise/adminassociate150

ADAPTIVE SERVER ENTERPRISE 15.0 ADMINISTRATOR ASSOCIATE CERTIFICATION

Certification Exam Title: Sybase Certified Adaptive Server Administrator Associate (Version 15.0)
Passing Grade: 70%
Number of Multiple Choice Questions: 60
Exam Number: 510-025
Exam Duration: 90 Minutes

STUDY GUIDELINES

Section 1 – Adaptive Server Enterprise Overview (4 questions – 6%)

  • Understand Adaptive Server Enterprise Architecture
  • Understand the purpose of each system database
  • Describe the use of each system table
  • Understand Sybase utilities

Section 2 – Adaptive Server Enterprise New Features 15.0 (9 questions – 15%)

  • Understand the use of the new features in Adaptive Server Enterprise 15.0
  • Understand the new Query Optimization feature
  • Understand changes to Dump and Load
  • Describe any new utility features
  • Describe significant SQL changes
  • Understand how to create computed columns, indexes on computed columns and describe function based Indexes
  • Understand scrollable cursors such as cursor sensitivity, scrolling the worktable, and global variable usage
  • Describe the performance monitoring, diagnosis, and statistics such as query processing metrics, streamlined trace flags, XML format trace output, GUI Plan Viewer, changes to update statistics, and changes to sp_sysmon
  • Understand extensible new limits for new Adaptive Server Enterprise 15.0 datatypes such as bigint, unsigned int, smallint, unitext, unsigned bigint

Section 3 – Configuration, Upgrade & Installation (4 questions – 6%)

  • Understand how to manage Adaptive Server Enterprise 15.0 configuration parameters
  • Understand how to install and upgrade Adaptive Server Enterprise 15.0 from a previous version
  • Understand the environment variables used by Adaptive Server Enterprise 15.0
  • Understand server page sizes

Section 4 – Resource Allocation (4 questions – 6%)

  • Understand the use of file systems, raw partitions, and the dsync clause
  • Describe the partitioning of tables and indexes
  • Be familiar with how to plan, create and manage devices and databases
  • Have knowledge of capacity planning and system limits: for example, devices, databases, segments and transaction logs
  • Understand the system tables related to capacity planning
  • Understand how to manage tables and the details of the alter table subcommands
  • Understand the purposes of the Last Chance Threshold and Freespace Threshold, such as  how do you make use of them
  • Be acquainted with how to recreate the DDL from reading the storage-related system tables
  • Understand storage space requirements
  • Have knowledge of table creation and structure

Section 5 – Database and Logs (7 questions – 13%)

  • Describe how to manage databases and transaction logs
  • Understand how to perform logical database rebuilds
  • Understand how to use segments for performance and capacity planning
  • Understand the purposes and uses of system- and user-defined segments
  • Understand Relaxed Size Limitations
  • Understand Large Identifiers
  • Understand Version Migration
  • Understand the standard Adaptive Server Enterprise datatypes that are not included in Section 2

Section 6 – Backup and Recovery (6 questions – 11%)

  • Experience with how to manage the database and transaction log dumps
  • Understand how dumps are processed and what types of dump and load functionality is available in Adaptive Server Enterprise 15.0
  • Understand Cross-Platform Dump and Load
  • Understand dump compression
  • Understand how to perform dumps and loads for standby access
  • Understand how to enable up to the minute recovery
  • Understand all of the following: backup production databases, truncate the transaction log, recover from disasters, protect the master database, and use Sybase mirrorin

Section 7 – Cache Management (4 questions – 7%)

  • Understand how Adaptive Server Enterprise 15.0 manages memory, such as data cache(s), procedure cache sizing, and when are pages written to disk
  • Understand how to configure data caches and buffer pools
  • Describe the Statement Cache

Section 8 – Security (5 questions – 8%)

  • Be familiar with Adaptive Server Enterprise’s password security features
  • Understand how to manage passwords
  • Describe how to grant and revoke privileges in a granular fashion
  • Understand the use of system roles and user-defined roles and their precedence
  • Understand the difference and precedence between groups and user-defined roles
  • Understand the use of proxy authorization
  • Understand the use of access rules

Section 9 – Transaction Management (3 questions – 5%)

  • Understand transaction Management in Adaptive Server Enterprise, such as commits, rollbacks, locks, and deadlocks
  • Understand how isolation levels are implemented and when to use each one of them
  • Understand implicit and explicit transactions and transaction modes
  • Understand the difference between transactions and checkpoints
  • Understand the transaction log and minimally logged operations
  • Understand how Adaptive Server Enterprise manages pages in memory
  • Describe the use of the BCP utility

Section 10 – Dynamic Reconfiguration (4 questions – 6%)

  • Understand dynamic (re)configuration
  • Have knowledge of which configuration parameters are static or dynamic
  • Understand how dynamic (re)configuration uses memory

Section 11 – Parallel Performance (3 questions – 5%)

  • Have knowledge of how to keep partition statistics up-to-date
  • Understand how to read and interpret columns statistics and how to keep them up to date
  • Understand how to defragment tables efficiently
  • Be familiar with the various table-based and index-based access methods
  • Understand how to enable and utilize parallel processing

Section 12 – Locking and Concurrency (3 questions – 5%)

  • Understand the different lock types and their use by T-SQL commands
  • Understand how different locking schemes work and how to use them
  • Understand how to diagnose lock contention
  • Understand the effect of different lock types, as well as lock schemes on application concurrency
  • Understand lock promotion

Section 13 – Object Resource Management (3 questions – 5%)

  • Describe how to use table partitioning and the criteria for table partitioning
  • Describe the steps involved in creating partitions
  • Understand partition skew and how to rebalance a partitioned table
  • Understand how to keep partition statistics up-to-date
Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s