A SELECT statement spends all its time returning 1 billion rows.What can be done to make this faster?

A. Use a CURSOR.

B. Use an EXTERNAL table.

C. Use the COPY command.

D. Increase the PreFetch Count.

Which statement is true for database users and groups?

A. All users must belong to admin group.

B. Creation of users and groupsis not allowed.

C. Users and groups are local and tied to a particular database.

D. Users and groups are global and not tied to a particular database.

What two conditions must be met to achieve a collocated join between two tables? (Choose two.)

A. Both tables have primarykeys defined.

B. Both join columns have the same name.

C. Both tables must be distributed on random.

D. Both join columns have identical data types.

E. Both tables must be distributed on their join column.

When unloading data via an external table, where can the SQL be submitted?

A. From a User Defined Function.

B. From nzsql on an AIX machine networked to the system.

C. From nzsql on Microsoft Windows networked to the system.

D. From an ODBC application on Windows networked to the system.

When enabled, query history always collects information about login failures, session creation, session termination, and query history process startup. Which area does query history NOT collect data?

A. Plans

B. Disks

C. Tables

D. Queries

With LDAP enabled, which of the followingis verified against an LDAP server?

A. Database user ADMIN privileges.

B. Database user SELECT privileges.

C. Database user GROUP authentication.

D. Database user password authentication.

A stored procedure returning one value is created, which two methods can be used to execute the procedure? (Choose two.)

A. Using the EXECUTE command.

B. Using the SELECT statementwithin a FROM clause.

C. Using the SELECT statement within a HAVING clause.

D. Using the SELECT statement without a FROM clause.

E. Using the SELECT statement with tables in the FROM clause.

Which is NOT a function of the FieldProgrammable Gate Arrays (FPGA) residing on the Netezza Database Accelerator card?

A. Projects

B. Restricts

C. Aggregates

D. Decompresses

Which option does NOT trigger a HardwareNeedsAttention event?

A. A power supply has failed.

B. A switch has beenrebooted.

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.

When is the ToplogyImbalance event triggered?

A. When a SAS switch has failed.

B. When the path the path between an S-Blade and its disks has failed.

C. When a disk enclosure's voltage sensor is reading outside the nominal range.

D. When an S-Blade has ownership of more dataslices than is optimal (usually following a disk replacement).