Which log file provides a DBA with an actual SQL statement that was executed?

A. clientmgr.log

B. pg.log

C. sysmgr.log

D. dbos.log

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

Which date time format is used to capture history activities?

A. system time

B. local time

C. EST

D. GMT

What should be the state of the IBM Netezza Performance Server system in order to run the nz_manual_vacuum command?

A. online

B. running

C. stopped

D. paused

Which command is used to register a user defined table function in the database?

A. CREATE FUNCTION

B. nzudxcompile

C. ALTER FUNCTION

D. ECHO

In IBM Netezza Performance Server, what storage file system is shared across the host containers?

A. IBM Spectrum Scale or General Parallel File System (GPFS)

B. NT File System (NTFS)

C. Glusterfs

D. 2 File System (ZFS)

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. A table that is being restored must have the same name in the backup set.

C. The userspace must be provided

D. The table structure (DDL) needs to exist

Which is the most efficient data type for distribution keys?

A. integers

B. internal datatypes (ROWID etc.)

C. temporal types

D. strings

What nzsqa option can be used to view workload metrics including usage summary, resource usage and short/long running jobs?

A. nzsqa progress

B. nzsqa wlm

C. nzsqa responders

D. nzsqa schedqueues -sys

Which two external methods can IBM Netezza Performance Server use to authenticate database users?

A. LDAP

B. SSH

C. Radius

D. PKI-Based

E. Kerberos

Within a database session, which syntax allows a user to change to a different schema (NEW_SCHEMA)?

A. ALTER SESSION SET SCHEMA=NEW_SCHEMA

B. SET CURRENT SCHEMA TO NEW_SCHEMA

C. SET SCHEMA NEW_SCHEMA

D. ALTER DATABASE database name SET DEFAULT SCHEMA NEW SCHEMA

What is the duration of SQB by default?

A. 3 seconds

B. 6 seconds

C. 2 seconds

D. 10 seconds

Which statement is correct about command nz_responders?

A. displays user activity in tabular format

B. displays information from nzsql responders -all in a more user-friendly format

C. displays information from nzsqa responders -sys in a more user-friendly format

D. displays resource utilization statistics in JSON format

What is a purpose of the command nzsystem?

A. to show and change the system state

B. to show and change nzroot use

C. to show and change system users

D. to show and change system access

Which two file formats are valid for external tables?

A. text-delimited

B. fixed-length

C. JSON

D. HL7

E. XML