Description

  • 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.

  • EDB785 (SYBASE IQ 16.3)
  • EDB795 (SAP IQ 16 SERVICE PACK 3)

Performance and Tuning 8% – 12%

Perform standard performance tuning on SAP IQ.

  • EDB785 (SYBASE IQ 16.3)
  • EDB795 (SAP IQ 16 SERVICE PACK 3)

Multiplex 8% – 12%

Configure and manage Multiplex components options and servers.

  • EDB785 (SYBASE IQ 16.3)
  • EDB795 (SAP IQ 16 SERVICE PACK 3)

Transaction Management 8% – 12%

Describe the control and behavior of transactions and snapshot versioning

  • EDB785 (SYBASE IQ 16.3)
  • EDB795 (SAP IQ 16 SERVICE PACK 3)

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.

  • EDB785 (SYBASE IQ 16.3)

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.

  • EDB785 (SYBASE IQ 16.3)
  • EDB795 (SAP IQ 16 SERVICE PACK 3)

Tables, Views, Indexes, and Data Types 8% – 12%

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

  • EDB785 (SYBASE IQ 16.3)

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.

  • EDB785 (SYBASE IQ 16.3)
  • EDB795 (SAP IQ 16 SERVICE PACK 3)

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.

  • EDB785 (SYBASE IQ 16.3)

Backup and Restore < 8%

Perform backup and recovery for SAP IQ.

  • EDB785 (SYBASE IQ 16.3)

SAP Sybase IQ Overview < 8%

Describe SAP IQ components and architecture.

  • EDB785 (SYBASE IQ 16.3)