What are two important factors to consider when selecting a distribution key?

• A.table constraints
• B.distinct values
• C.columns used for joins
• D.columns used for filters
• E.not Nullable constraint

Comment: *

Name: *

Email: *

Verification: *

By default, when are the postgres logs rotated on an IBM Netezza Performance Server?

• A.hourly or greater than 100 MB
• B.weekly or greater than 5 GB
• C.daily or greater than 1 GB
• D.monthly or greater than 10 GB

Comment: *

Name: *

Email: *

Verification: *

Which is a valid statement regarding event rules on the IBM Netezza Performance Server (NPS) Console?

• A.New event rules can be added using the queries panel in NPS Console.
• B.New event rules can only be added in the host container.
• C.New event rules can be added using the event rules panel in NPS Console.
• D.New event rules must be added using the npsaddevent command.

Comment: *

Name: *

Email: *

Verification: *

Which three scripts are included in the IBM Netezza Performance Server Software Support Tools?

• A.nzsqa
• B.nz tables
• C.nz_ddl
• D.nzsql
• E.nzbackup
• F.nz_stats

Comment: *

Name: *

Email: *

Verification: *

When computing the row size for a table row, what overhead should be accounted for?

• A.48 bytes for ROWID, CREATEXID and DELETEXID only
• B.32 bytes for ROWID. CREATEXID, DELETEXID and the null vector
• C.32 bytes for ROWID. CREATEXID and DELETEXID and a variable number of bytes for the null vector if there are nullable columns
• D.24 bytes for ROWID. CREATEXID and DELETEXID plus null vector if there are nullable columns and record header depending on string columns

Comment: *

Name: *

Email: *

Verification: *