To enable or disable multiple schema support on the IBM Netezza Performance Server, which configuration file needs to be updated?

A. system.cfg

B. pg_hba.conf

C. postgresql.conf

D. startup.cfg

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.

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 statement regarding drive failure is true?

A. Queries and transactions are not interrupted by drive failure if their data is not on the failed drive.

B. Queries and transactions are not interrupted in the event of a drive failure.

C. Queries and transactions are interrupted by drive failure because there is no drive mirroring for drives.

D. Running queries and transactions will finish, but new transactions will not be allowed till drive is changed.

Which state does the nzstate command show when the IBM Netezza Performance Server system fails to initialize?

A. stopped

B. paused

C. discovering

D. down

What command is used to add an event?

A. nzevent add

B. nzevent insert

C. nzevent load

D. nzevent create

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 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

Which statement regarding the IBM Netezza Performance Server (NPS) admin database user is true?

A. The admin user should be deleted after installing NPS.

B. The admin user is added to the host OS before installing NPS.

C. The admin user can not be deleted after installing NPS.

D. The admin user is the only owner of a database on NPS.