What access is required to create a new user in IBM Netezza Performance Server?
A. An account with NEW USER administrative privilege
B. An account with CREATE USER administrative privilege.
C. An account with CREATE GROUP access on the host OS.
D. An account with CREATE ID access on the host OS.
What happens to NFS mounts after a container failover?
A. NFS is handled by Red Hat OpenShift and does not need to be mounted.
B. Sysmgr will remount it as part of the IBM Netezza Performance Server environment
C. A containers do not allow for NFS mounts.
D. It will be automatically mounted by the ipsnfs service.
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
Which two cross-database SQL operations are allowed?
A. DELETE
B. ALTER VIEW
C. ALTER TABLE
D. CREAE TABLE
E. REVOKE
Which is the most efficient data type for distribution keys?
A. integers
B. internal datatypes (ROWID etc.)
C. temporal types
D. strings
What are two valid column constraints?
A. DEFAULT
B. INITIALLY IMMEDIATE
C. INITIALLY DEFERRED
D. NULL
E. DEFERRABLE
What is the duration of SQB by default?
A. 3 seconds
B. 6 seconds
C. 2 seconds
D. 10 seconds
Which two scenarios can be addressed using the nz_check_disk_scan_speeds command?
A. check system status
B. get skew information distributed across disks
C. see disk read and write speeds
D. slow performing SPU or drive
E. get disk storage utilization details
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 be added using the event rules panel in NPS Console.
C. New event rules can only be added in the host container.
D. New event rules must be added using the npsaddevent command.
Which two file formats are valid for external tables?
A. text-delimited
B. fixed-length
C. JSON
D. HL7
E. XML
