Create Account

IBM C2090-560

PureData System for Analytics v7.1

Free Questions in OTE format

File Date Q&A Votes Size  
IBM.C2090-560.v2016-03-25.134q.ote 2016-03-25 134 0/0 411.64 Kb

Notification about new IBM C2090-560 files

Subscribe to IBM C2090-560 dump here, you will be informed about new OTE files.

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

© 2006 ExamBrainDumps