Want to pass your IBM Netezza Performance Server V11.x Administrator C1000-085 exam in the very first attempt? Try Pass2lead! It is equally effective for both starters and IT professionals.
VCE
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?
A. Create a copy of FACT_SALES table with zip_code as integer data type.
B. alter table fact_sales to organize on zip_code. followed by groom.
C. CREATE ORGANIZED view for FACT_SALES table
D. Create a view with a typecast to integer and use view for query purposes
By default, when are the postgres logs rotated on an IBM Netezza Performance Server?
A. hourly or greater than 100 MB
B. daily or greater than 1 GB
C. monthly or greater than 10 GB
D. weekly or greater than 5 GB
What two files are extracted from the SQL Extension toolkit package?
A. libnetinza-version.tar gz
B. libnetsqlext-version.tar.gz
C. libnetxml-version.tar.gz
D. libnetcrypto-version.tar.gz
E. libnetsqlkit-version.tar.gz