1.
Which of the following methods does Netezza use to ensure data integrity and availability?
2.
What usually happens when a sector on a disk becomes corrupted?
3.
Why is the following SQL INCORRECT?
4.
Data decompression is done in what component of the Netezza architecture?
5.
Which of the following data types are supported natively by Netezza?
6.
Which of the following data redistribution methods generally results in the fastest query times?
7.
Which of the following items have an impact on the query plan that the optimizer chooses?
8.
For the following SQL: Assume that this query is typical of how the fact_table table is used. What would be the best organization key?
9.
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?
10.
For the following SQL: What field(s) would most likely be used to distribute fact_table if you wanted optimal query performance?