000-M87 - IBM Netezza Technical Mastery Test v1

Go back to IBM

Example Questions

Which of the following is TRUE about the GROOM TABLE command? Which of the following statements can be used to create a temporary table? In a Netezza TwinFin server, where do snippets run? In a TwinFin 12, what does the number 12 refer to? Which of the following components in a TwinFin appliance are NOT redundant? Which of the following statements are TRUE about backups? During a host failure, what host-based data will be automatically available on the standby host? Which of the following data redistribution methods generally results in the fastest query times? Which of the following options best completes this statement? When a query is compiled, _______________________. What is the maximum row size in Netezza? Data decompression is done in what component of the Netezza architecture? Which of the following is MOST TRUE of how Netezza stores data? Which of the following is NOT true of Netezza event management system? Is it CORRECT that if a table is distributed randomly, ZoneMaps are not used? Which of the following data types are supported natively by Netezza? Which of the following statements most accurately describe ZoneMaps? Which of the following methods does Netezza use to ensure data integrity and availability?: Replication, Regeneration, Failover, Transaction logging What elements of logical data modeling does Netezza support? When a single SQL query is run on an empty system without workload management enabled, what are the maximum system resources it receives by default? Which of the following statements about external tables is NOT accurate? Which of the following items have an impact on the query plan that the optimizer chooses? With workload management, an Administrator can set aside _________ S-Blades to be used exclusively with a given database? Which of the following statements is MOST TRUE? Which of the following statements about Netezza privileges is NOT true? Which of the following is NOT true of the GENERATE STATISTICS command? Which of the following phrases does not describe a way that Netezza can ensure that data for a join is on the same Snippet Processor? Which of the following does Netezza use to ensure ACID compliance? How can dirty reads (where a transaction is allowed to read data from a row that has been modified by another running transaction not yet committed) be enabled on Netezza? With workload management, you can set aside the _________________ and __________________ amount of resources that a given user can have at any given time. Clustered Base Tables are effective because they _________________. Which of the following impact data distribution? Which of the following statements about an FPGA is TRUE? Which of the following options best completes the following statement? The physical order that data is loaded into a table __________ the initial zone mapping effectiveness. Which of the following statements is the LEAST accurate? What usually happens when a sector on a disk becomes corrupted?