000-M87 IBM Netezza Technical Mastery Test v1 (Exam 2)

000-M87 IBM Netezza Technical Mastery Test v1 (Exam 2)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • How can dirty reads (where a transaction is allowed to read data from a row that h...

  • Which of the following methods does Netezza use to ensure data integrity and avail...

  • What usually happens when a sector on a disk becomes corrupted?

  • What is the maximum row size in Netezza?

  • Why is the following SQL INCORRECT?

  • Data decompression is done in what component of the Netezza architecture?

  • Which of the following data types are supported natively by Netezza?

  • Which of the following data redistribution methods generally results in the fastes...

  • Which of the following items have an impact on the query plan that the optimizer c...

  • For the following SQL:Assume that this query is typical of how the fact_table tabl...

  • Which of the following phrases does not describe a way that Netezza can ensure tha...

  • For the following SQL:What field(s) would most likely be used to distribute fact_t...

  • For the following SQL:What field would be used to distribute fact_table if you wan...

  • During a host failure, what host-based data will be automatically available on the...

  • Which of the following components in a TwinFin appliance are NOT redundant?

  • Which of the following options best completes the following statement? The physica...

  • With workload management, you can set aside the _________________ and ____________...

  • In a Netezza TwinFin server, where do snippets run?

  • Which of the following statements is the LEAST accurate?

  • Which of the following statements is MOST TRUE?

Be the first to review
Login and Review
  • info
    Quiz Info
  • date_range
    Feb. 8, 2016, 3:50 a.m.
    20 questions
    0 completed
    0 takers

  • 000-M87 IBM Netezza Technical Mastery Test v1 (Exam 2) QR code