IBM C1000-085 IBM Netezza Performance Server V11.x Administrator Exam Practice Test

Page: 1 / 14
Total 60 questions

Question 1

Consider a scenario where a customer has a FACT_SALES table with a column zip_code with data type char(5| They frequently restrict on this column, but the query is very inefficient.

What is the correct way to optimize this query without modifying the column?

Answer : C

Question 2

The nzhostbackup command backs up which directory by default?

Answer : D

Question 3

Which date time format is used to capture history activities?

Answer : A

Question 4

Which two file formats are valid for external tables?

Answer : A, C

Question 5

When is a PRIMARY KEY (PK) table constraint evaluated during an INSERT statement into the table?

Answer : C

Page:    1 / 14   
Total 60 questions