Which two command line support tools are used to determine the order of data for a given table?

• A.nz_get
• B.nz_physical_table_layout
• C.nz_sort_order
• D.nz_pagemap
• E.nz_zonemap

Comment: *

Name: *

Email: *

Verification: *

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.alter table fact_sales to organize on zip_code. followed by groom.
• B.Create a copy of FACT_SALES table with zip_code as integer data type.
• C.CREATE ORGANIZED view for FACT_SALES table
• D.Create a view with a typecast to integer and use view for query purposes

Comment: *

Name: *

Email: *

Verification: *

Which two products or methods can be used for disaster recovery when using IBM Netezza Performance Servers?

• A.InfoSphere Data Replication
• B.Cloud Pak for Data
• C.NPS Backup and Restore
• D.Data Serialization
• E.Netezza Replication Services

Comment: *

Name: *

Email: *

Verification: *

Which statement regarding drive failure is true?

• A.Queries and transactions are not interrupted in the event of a drive failure.
• B.Queries and transactions are interrupted by drive failure because there is no drive mirroring for drives.
• C.Running queries and transactions will finish, but new transactions will not be allowed till drive is changed.
• D.Queries and transactions are not interrupted by drive failure if their data is not on the failed drive.

Comment: *

Name: *

Email: *

Verification: *

What are two valid column constraints?

• A.NULL
• B.DEFERRABLE
• C.INITIALLY IMMEDIATE
• D.DEFAULT
• E.INITIALLY DEFERRED

Comment: *

Name: *

Email: *

Verification: *