IBM PureData System for Transactions Technical Mastery Test v1 - P2090-047 Exam Practice Test

A. nzsystem showState

B. nzstate

C. nzsql -c "select * from _v_system_info;"

D. cat /proc/database

A. All user space is available for database expansion.

B. When you create a database you can set the maximum space it is allowed to use.

C. When creating the database you can specify which disks to use.

D. Each database is assigned it's own section of disk space.

A. nzbackup backs up to a Veritas NetBackup destination.

B. nzbackup backs up to a file system destination.

C. nzbackup backs up to a IBM Tivoli Storage Manager destination.

D. nzbackup backs up selected tables.

A. nzsql

B. An ODBC driver manager.

C. The system does not support 64 bit ODB

D. A 64-bit ODBC driver for the same UNIX environment.

E. A 32-bit ODBC driver for the same UNIX environment.

A. System assigns records to a Netezza Database Accelerator based on their distribution key value.

B. System assigns records to a FPGA based on their distribution key value.

C. System assigns records to a logical data slice based on their distribution key value.

D. System assigns records to the host based on their distribution key value.

A. nzstats

B. nzsystem

C. nzshow

D. nzstate

A. Select distinct (ColumnA) from TableA;

B. Select ColumnA, count(*) from TableA group by ColumnA order by 2;

C. Select distinct(datasliceid) from TableA;

D. Select datasliceid, count(*) from TableA group by 1 order by 2;

A. /var/log

B. The SYSTEM database

C. /usr/local

D. /nz/kit/log