Sunday, 23 December 2012

Passing Netezza exam 000-553

Last week I successfully passed netezza exam 000-553, Netezza Software platform v6.0. It was not an easy exam! If you think about taking this exam, you should be aware of the key points below:
  • Short Query Bias.
  • Physical components and structure of the appliance. You may be asked in every thing; power supply, number of disks, S-blades, SPA, SPUs, disk controllers, host, FPGA .... etc
  • Power supply failure effect.
  • Query plans and different ways to show the plans.
  • nzload and external tables.
  • backups and restore to different versions. (e.g. can u restore to an old version).
  • autoReplay option.
  • nzstate and nzstats.
  • location for different system files. Including log and temp.
  • Cursors.
  • crontab
  • zoneMaps
  • CTAS
  • Data distribution on different data slices.
  • Sequence data type.
  • Default user group.
  • Isolation level.
  • Workload management. 
  • Cross database access.
  • Materialized views.
  • Connectivity; focusing on ODBC.
  • HA host states (Active & stand by)
That's what I remember now. Please feel free to post your comments if you have a question.
Thnx.

No comments:

Post a Comment