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
What ap cli command is used to disable a node?
A. ap node power off
B. ap node set__personality fail
C. ap stopnode
D. ap node disable
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
Which statement regarding drive failure is true?
A. Queries and transactions are not interrupted by drive failure if their data is not on the failed drive.
B. Queries and transactions are not interrupted in the event of a drive failure.
C. Queries and transactions are interrupted by drive failure because there is no drive mirroring for drives.
D. Running queries and transactions will finish, but new transactions will not be allowed till drive is changed.