Which statement is true when executing the GROM command on a Clustered Base Table (CBT)?

• A.Enough space is required for GROOM to make a complete copy of the table
• B.GROOM uses CREATE TABLE AS SELECT (CATAS) for CBT to reclaim space and re-order data.
• C.It reclaims space from deleted rows and re-orders data.
• D.It reclaims space from deleted rows and does not re-order data

Comment: *

Name: *

Email: *

Verification: *

What is required in order to restore a specific table using the nz_restore support tool?

• A.A table needs to be backed up by using nzbackup utility.
• B.The table structure (DDL) needs to exist
• C.The userspace must be provided
• D.A table that is being restored must have the same name in the backup set.

Comment: *

Name: *

Email: *

Verification: *

Which date time format is used to capture history activities?

• A.local time
• B.EST
• C.GMT
• D.system time

Comment: *

Name: *

Email: *

Verification: *

Which two commands will show a query plan without running the query?

• A.nz_plan querytext
• B.EXPLAIN PLAN FILE querytext
• C.EXPLAIN PLANGRAPH querytext
• D.EXPLAIN querytext
• E.nzsql -t querytext -0 planfile.pln

Comment: *

Name: *

Email: *

Verification: *

What happens to NFS mounts after a container failover?

• A.A containers do not allow for NFS mounts.
• B.NFS is handled by Red Hat OpenShift and does not need to be mounted.
• C.It will be automatically mounted by the ipsnfs service.
• D.Sysmgr will remount it as part of the IBM Netezza Performance Server environment

Comment: *

Name: *

Email: *

Verification: *