Use this quick start guide to collect all the information about IBM Netezza Performance Server Administrator (C1000-085) Certification exam. This study guide provides a list of objectives and resources that will help you prepare for items on the C1000-085 IBM Netezza Performance Server V11.x Administrator exam. The Sample Questions will help you identify the type and difficulty level of the questions and the Practice Exams will make you familiar with the format and environment of an exam. You should refer this guide carefully before attempting your actual IBM Netezza Performance Server Administrator certification exam.
The IBM Netezza Performance Server Administrator certification is mainly targeted to those candidates who want to build their career in IBM Data and AI - Data and AI domain. The IBM Certified Administrator - Netezza Performance Server V11.x exam verifies that the candidate possesses the fundamental knowledge and proven skills in the area of IBM Netezza Performance Server Administrator.
IBM Netezza Performance Server Administrator Exam Summary:
| Exam Name | IBM Certified Administrator - Netezza Performance Server V11.x |
| Exam Code | C1000-085 |
| Exam Price | $200 (USD) |
| Duration | 90 mins |
| Number of Questions | 60 |
| Passing Score | 68% |
| Schedule Exam | Pearson VUE |
| Sample Questions | IBM Netezza Performance Server Administrator Sample Questions |
| Practice Exam | IBM C1000-085 Certification Practice Exam |
IBM C1000-085 Exam Syllabus Topics:
| Topic | Details | Weights |
|---|---|---|
| Architecture |
- Explain the MPP architecture
- Describe end to end data flow - Describe the system catalog, system tables and views - Explain snippets, DBOS and Host – SPU interaction - Explain system states in IBM Netezza Performance Server - Design disaster recovery with IBM Netezza Performance Server - Explain IBM Netezza Performance Server storage layout - Explain transaction management, ACID and invisibility lists |
18% |
|
Best Practices for Database Design
|
- Describe tables and views
- Explain data types - Explain distribution keys - Leverage constraints in IBM Netezza Performance Server - Define and use IBM Netezza Performance Server schemas and cross database access - Leverage external tables such as nz, migrate, S3, and nzload |
22% |
|
Monitoring and Tuning for Performance
|
- Use the IBM Netezza Performance Server console
- Manage the IBM Netezza Performance Server catalog - Read query explain plans - Explain and set zonemaps in action - Describe Workload Management - Monitor IBM Netezza Performance Server log files - Optimize throughput |
20% |
|
Administration
|
- Plan and manage backup & restore
- Run host backups - Schedule groom for tables - Maintain statistics - Manage configuration files - Manage and implement users and groups - Implement, control and monitor security aspects - Configure and manage history data collection - Mount external storage |
20% |
|
Support and Maintenance
|
- Configuring and checking events
- Understanding the basics of platform management for IBM Netezza Performance Server - Leverage support and toolkit scripts - Maintain and archive query plans |
8% |
|
Netezza Clients and Tools
|
- Use the CLI
- Install drivers such as ODBC and JDBC - Install and connect backup tools - Leverage analytic tools - Install and upgrade SQL Extension toolkit - Manage User Defined Functions (UDF), User Defined Table Functions, User Defined Aggregates (UDA) and Shared Libraries |
12% |
To ensure success in IBM Netezza Performance Server Administrator certification exam, we recommend authorized training course, practice test and hands-on experience to prepare for IBM Netezza Performance Server V11.x Administrator (C1000-085) exam.