• 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 Troubleshooting 8% – 12%

Use monitoring tools and utilities, and apply troubleshooting techniques.

Performance and Tuning 8% – 12%

Perform standard performance tuning on SAP IQ.

Multiplex 8% – 12%

Configure and manage Multiplex components options and servers.

Transaction Management 8% – 12%

Describe the control and behavior of transactions and snapshot versioning

User Administration and Security 8% – 12%

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

Data Management 8% – 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 Types 8% – 12%

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

Databases, Partitioning, and Dbspace Management 8% – 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 Configuration 8% – 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.

General Information

Exam Preparation

Each specific certification comes with its own set of preparation tactics. We define them as “Topic Areas” and they can be found on each exam description. You can find the number of questions, the duration of the exam, what areas you will be tested on, and recommended course work and content you can reference.

Please be aware that the professional- level certification also requires several years of practical on-the-job experience and addresses real-life scenarios.

For more nformation refer to our Take your SAP Certification Exams and our FAQs .

Safeguarding the Value of Certification

SAP Education has worked hard together with the Certification & Enablement Influence Council to enhance the value of certification and improve the exams. An increasing number of customers and partners are now looking towards certification as a reliable benchmark to safeguard their investments. Unfortunately, the increased demand for certification has brought with it a growing number of people who to try and attain SAP certification through unfair means. This ongoing issue has prompted SAP Education to place a new focus on test security. Please take a look at our  post  to understand what you can do to help to protect the credibility of your certification status.

Our Certification Test Security Guidelines will help you as test taker to understand the testing experience.

Cloud Security Guidelines  

Classroom Security Guidelines