When setting up a crontab entry, what must be done on a PureData System for Analytics server?

A. Create an nzcron event.

B. nzstop/nzstart the database.

C. Stop and start the appliance.

D. Add entry to active host and standby host.

Given the following query: Select count(*) from TableA; How can you view the query plan without executing the query?

A. Use explain.

B. Use statistics.

C. Use pg.log file.

D. Set show_plan = true;

Which command is used to abort a user's SQL transaction?

A. kill

B. abort

C. nzstop

D. nzsession

What is the host Linux file that must be modified to adjust optimizer settings permanently?

A. /nz/data/postgresql.conf

B. /nz/data/config/system.cfg

C. /nz/kit/sys/initTopology.cfg

D. /nz/kit/log/sysmgr/sysmgr.log

Which statement is true about the groom feature?

A. Groom allows the user to add row level security.

B. Groom validates primary key constraints on the table.

C. Groom reorders rows based on the DISTRIBUTE ON clause.

D. Groom allows the user to reorganize tables based on the ORGANIZE ON clause.

Which CREATE DATABASE attributes are required?

A. The database name.

B. The database name and the redo log file name.

C. The database name and the table space name.

D. The database name and the temporary table space name.

What is the maximum number of databases that can be created?

B. 12

C. 31

D. > 96

What is the maximum number of columns that can participate in a distribution key?

A. One

B. Four

C. Unlimited

D. Depends on the number of columns of integer datatype.

Which statement is NOT true regarding the nzload utility?

A. nzload runs on windows.

B. nzload runs on SuSE Linux.

C. nzload blocks update/delete against the target table.

D. nzload runs on the PureData System for Analytics host.

Which option does NOT trigger a HardwareNeedsAttention event?

A. A power supply has failed.

B. A switch has been rebooted.

C. A SAS cable fails or is disconnected.

D. A chassis or fabric switch port is in a down state for longer than the defined threshold.