Description

  • This certification path will validate your capability as a well-trained technologist prepared to help your client or partner manage SAP Sybase Adaptive Server Enterprise database. Armed with an understanding of database administration, you can implement this knowledge for your projects as a technology consultant

Topic Areas

Please see below the list of topics that may be covered within this certification and the courses that cover them. Its accuracy does not constitute a legitimate claim; SAP reserves the right to update the exam content (topics, items, weighting) at any time.

Backup> 12%

Plan and perform backups. Explain the advanced backup techniques.

Database Server Configuration> 12%

Configure Server behaviour and memory

Tuning8% – 12%

Explain how make parallel tunning. Describe tuning with the Logical Process Manager.

Transactions8% – 12%

Manipulate data using Transact-SQL functions. Use Transactions to maintain data consistency. Explain how to isolate Data with Locks.

Architecture and Installation8% – 12%

Introduce ASE and explainhow servers are installed.

Maintenance8% – 12%

Use extraction utilities. Explain the automatic recovery. Check and fix database consistency.

Security8% – 12%

Administer system roles and loings.  Manage database access and users. Implement Object Permissions, groups and roles.

Tables Management8% – 12%

Create Tables, Temporary Tables. Explain how to query Multiple Tables and System Tables. Modify Data in Tables.

Database Administration8% – 12%

Initialize and use devices. Create and manage databases and suggest different disk ressource strategies. 

Data Analysis< 8%

Analyze data using Aggregate functions.