• The “SAP Certified Application Associate – SAP IQ 16.0 Administration” certification exam validates a candidate’s ability to perform the tasks related to SAP IQ administration. Armed with an understanding of SAP IQ, the candidate can apply this knowledge to administration functions as a database administrator. This certificate proves that the candidate has the overall understanding and in‐depth administration skills required to be a productive member of an SAP IQ administration team.

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.

Monitoring and Troubleshooting8% – 12%

Use monitoring tools and utilities, and apply troubleshooting techniques.

Performance and Tuning8% – 12%

Perform standard performance tuning on SAP IQ.

Multiplex8% – 12%

Configure and manage Multiplex components options and servers.

Transaction Management8% – 12%

Describe the control and behavior of transactions and snapshot versioning

User Administration and Security8% – 12%

Perform core user administration and security tasks, including the creation of policies, users and roles. Grant privileges and define permissions.

Data Management8% – 12%

Identify data sources and load tables and methods.  Describe database options associated with loading tables. Apply cross-platform data movement, and work with Smart Data.

Tables, Views, Indexes, and Data Types8% – 12%

Define and use data types, index types, rebuild indexes, create tables and views.

Databases, Partitioning, and Dbspace Management8% – 12%

Create and manage the SAP IQ database,  IQ dbspaces,  and apply partitioning. Use the sliding window model and apply placement of objects on dbspaces.

Installation and Configuration8% – 12%

Define the system requirements and install and configure the SAP IQ Server, client software, and databases. Configure memory  such as cache sizing, memory and swap usage, etc.

Backup and Restore< 8%

Perform backup and recovery for SAP IQ.

SAP Sybase IQ Overview< 8%

Describe SAP IQ components and architecture.