This page is a one-stop solution for any information you may require for IBM Certified Specialist - PureData System for Analytics v7.1 (C2090-560) Certification exam. The IBM C2090-560 Exam Summary, Syllabus Topics and Sample Questions provide the base for the actual IBM PureData System for Analytics v7.1 exam preparation, we have designed these resources to help you get ready to take your dream exam.
The IBM Certified Specialist - PureData System for Analytics v7.1 credential is globally recognized for validating IBM PureData System for Analytics knowledge. With the IBM PureData System for Analytics v7.1 Certification credential, you stand out in a crowd and prove that you have the IBM PureData System for Analytics knowledge to make a difference within your organization. The IBM Certified Specialist - PureData System for Analytics v7.1 Certification (C2090-560) exam will test the candidate's knowledge on following areas.
IBM C2090-560 Exam Summary:
| Exam Name | IBM Certified Specialist - PureData System for Analytics v7.1 |
| Exam Code | C2090-560 |
| Exam Duration | 90 minutes |
| Exam Questions | 67 |
| Passing Score | 63% |
| Exam Price | $200 (USD) |
| Training | |
| Exam Registration | Pearson VUE |
| Sample Questions | IBM PureData System for Analytics Certification Sample Question |
| Practice Exam | IBM PureData System for Analytics Certification Practice Exam |
IBM C2090-560 Exam Topics:
| Objective | Details |
|---|---|
| Database Design |
- Ability to design, create and manage databases and database objects (tables, views, etc.)
- Ability to create and manage users and groups
- Knowledge of the Netezza schema concept
- Demonstrate the ability to design, implement and maintain materialilzed views
- Knowledge of the benefits of clustered based tables
- Demonstrate knowledge and application of sequences
- Demonstrate knowledge of zone maps
- Demonstrate knowledge of and application of data types
- Demonstrate knowledge of table defaults and constraints
|
| Physical Optimization |
- Demonstrate knowledge of data distribution and skew
- Ability to select an appropriate data distribution key
- Knowledge of PureData System for Analytics implementation of temporary tables
- Demonstrate knowledge of optimizer settings
- Abilty to maintain statistics and knowledge of impact on performance
- Demonstrate the abillity to correctly size system for capacity planning
- Abilty to utlize groom table feature and knowledge of impact on performance and storage
|
| Netezza Appliance Components |
- Knowledge of the TwinFin architecture and disks/dataslices
- Ability to identify the number of disks/dataslices on a system
- Knowledge of the appliance architecture (FPGA, SPU, Disk Array, etc.)
|
| High Availability Architecture |
- Demonstrate knowledge of Linux High Availability (HA) and Distributed Replicated Block Device (DRDB)
- Knowledge of behavior of nzLoad and query processing with a state change (host, disk, blade)
|
| Security |
- Knowledge of access/priviledge database objects
- Knowledge of using Lightweight Directory Access Protocol (LDAP)
- Knowledge of Linux system administration
- Knowledge of ODBC/JDBC in a Unix or Windows environment and OLE-DE connectivity
- Knowledge of new cryptographics mode and Row Secure Tables
|
| Data Movement |
- Demonstrate ability to use external tables in loading and unloading data
- Demonstrate ability to use backup/restore utilities
- Demonstrate ability to perform inserts (external tables vs cross system)
- Demonstrate ability to design cross database access
- Demonstrate ability to use nzload
|
| Monitoring and Performance |
- Demonstrate knowledge of log files
- Demonstrate knowledge of locks with update, delete, insert, and select
- Demonstrate knowledge of transactions that use temporary tables
- Demonstrate knowledge of system views
- Describe alerts
- Describe data flow and life of a query
- Demonstrate knowledge of compression
- Demonstrate knowledge of broadcasts and co-location/redistribute
- Demonstrate knowledge of data skew
- Analyzing Query Plan Files (Explain plans vs execution plans; Joins (expression based, cross product, merge, hash joins); recognizing the correct query plan (original vs executing))
- Performance Tuning (Multiple Snippets (Data Restrict Optimization); Snippets Limiter; Invisible Columns)
|
| Troubleshooting |
- Demonstrate knowledge of directory location (log files)
- Demonstrate knowledge of nzdumpschema
- Demonstrate knowledge of Event Manager Changes
|
| Operations |
- Ability to manage the system using the command line interface
- Demonstrate knowledge of NZ_ defaults settings
- Query History (Enablement, management, selection tables, configuration files, staging, notifications)
- Software Support Toolkit (common tasks - migration, table movement)
- Backup and Recovery
- Replication
- System Health Check (basic and advanced)
- Demonstrate knowledge to administer BI and Analytic functionality
|
| Transaction Management |
- Serialization issues
- Data Columns (housekeeping) (CreateXID, DeleteXID, RowID)
- Unreferencable rows
|
| Workload Management |
- GRA (Guarenteed Resource Allocation)
- PQE (Priority Query Execution)
- SQB (Short Query Bias)
- Virtual Tables
- New features (7.1 and later)
- Scheduler Rules
|
The IBM has created this credential to assess the knowledge and understanding of a candidate in the area as above via the certification exam. The IBM PureData System for Analytics (C2090-560) Certification exam contains a high value in the market being the brand value of the IBM attached with it. It is highly recommended to a candidate to do a thorough study and also get a hand full of the practice to clear IBM Certified Specialist - PureData System for Analytics v7.1 exam without any hiccups.