IBM C2090-560

Free Questions in OTE format

About IBM C2090-560 dump

Section 1 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
  

Section 2 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
  

Section 3 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.)
  

Section 4 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)
  

Section 5 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
  

Section 6 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
  

Section 7 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)
  

Section 8 Troubleshooting

• Demonstrate knowledge of directory location (log files)
  
• Demonstrate knowledge of nzdumpschema
  
• Demonstrate knowledge of Event Manager Changes
  

Section 9 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
  

Section 10 Transaction Management

• Serialization issues
  
• Data Columns (housekeeping) (CreateXID, DeleteXID, RowID)
  
• Unreferencable rows
  

Section 11 Workload Management

• GRA (Guarenteed Resource Allocation)
  
• PQE (Priority Query Execution)
  
• SQB (Short Query Bias)
  
• Virtual Tables
  
• New features (7.1 and later)
  
• Scheduler Rules