Which two command line support tools are used to determine the order of data for a given table?

A. nz_physical_table_layout

B. nz_zonemap

C. nz_pagemap

D. nz_sort_order

E. nz_get

What are Clustered Base Tables (CBT)?

A. Tables that decrease allocated storage

B. Tables that contain sorted data using one to four columns.

C. Tables that increase pre-sorting of new table records before a loading operation.

D. Tables that replicate the base table.

When is a PRIMARY KEY (PK) table constraint evaluated during an INSERT statement into the table?

A. The PK constraint is never checked when a row is inserted into the table.

B. After the row is inserted into the table.

C. Before the row is inserted into the table.

D. The PK constraint is only checked during a GENERATE STATISTICS operation.

What is the maximum length of a CHAR/VARCHAR column?

A. 65.535

B. 32.000

C. 64,000

D. 16.000

IBM Netezza Performance Server drivers for the Go Language can be obtained from which location?

A. IBM Public GitHub Repository

B. Red Hat Marketplace

C. download.google.com

D. Docker Hub

What command is used to add an event?

A. nzevent add

B. nzevent insert

C. nzevent load

D. nzevent create

What is the duration of SQB by default?

A. 3 seconds

B. 6 seconds

C. 2 seconds

D. 10 seconds

When choosing a distribution key for a large fact table, what is a valid choice?

A. any column used in table constraints

B. any column with low cardinality

C. a technical or surrogate key

D. any date column commonly used in queries

Which partition on the SPU node us used to store transient working data that is generated during query execution?

A. Primary

B. Nzscratch

C. Mirror

D. nzlocal

What two files are extracted from the SQL Extension toolkit package?

A. libnetinza-version.tar gz

B. libnetsqlext-version.tar.gz

C. libnetxml-version.tar.gz

D. libnetcrypto-version.tar.gz

E. libnetsqlkit-version.tar.gz