000-M87 - IBM Netezza Technical Mastery Test v1
Go back to IBM
Which of the following is TRUE about the GROOM TABLE command?
GROOM can materialize the results of previous ALTER TABLE ADD/DROP column commands.
Which of the following statements can be used to create a temporary table?
CREATE TEMP TABLE TEMPTABLE AS SELECT col1, col2 FROM MYTABLE;
In a Netezza TwinFin server, where do snippets run?
On the S-Blade CPU
In a TwinFin 12, what does the number 12 refer to?
The number of S-Blades.
Which of the following components in a TwinFin appliance are NOT redundant?
None of the above; all components are redundant.
Which of the following statements are TRUE about backups?
You must explicitly grant permission for a non-owner to do backups on a particular database.
During a host failure, what host-based data will be automatically available on the standby host?
Everything on the /nz and /export/home/nz partitions.
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, _______________________.
the number of snippets generated depends on a number of factors, including the complexity of the query
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?
Netezza uses a form of columnar compression, but stores data in a row-based format.
Which of the following is NOT true of Netezza event management system?
Some common events are enabled by default.
Is it CORRECT that if a table is distributed randomly, ZoneMaps are not used?
ZoneMaps are used in the exact same way as in any other distribution.
Which of the following data types are supported natively by Netezza?
Which of the following statements most accurately describe ZoneMaps?
ZoneMaps are like street addresses, they tell Netezza the range of data in a specific extent.
Which of the following methods does Netezza use to ensure data integrity and availability?: Replication, Regeneration, Failover, Transaction logging
Replication, Regeneration, and Failover.
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?
Querying external tables is about the same speed as querying normal tables.
Which of the following items have an impact on the query plan that the optimizer chooses?
Both table statistics and ZoneMaps
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?
ZoneMaps are disabled for a table while Statistics are being run.
Which of the following statements about Netezza privileges is NOT true?
Users with privileges on an object can pass that object to others by default.
Which of the following is NOT true of the GENERATE STATISTICS command?
The user can specify whether FULL or EXPRESS statistics are calculated.
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?
Dirty reads cannot be enabled.
With workload management, you can set aside the _________________ and __________________ amount of resources that a given user can have at any given time.
minimum and maximum
Clustered Base Tables are effective because they _________________.
make ZoneMaps more effective by grouping similar data together
Which of the following impact data distribution?
The number of hard drives on the system.
Which of the following statements about an FPGA is TRUE?
It is a common chip used in a unique way in Netezza architecture.
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?
Skew can occur despite evenly distributed tables when more data ends up on one Snippet Processor while a query is being processed.
What usually happens when a sector on a disk becomes corrupted?
The sector is marked bad and the data is copied over from the mirrored copy.