Which is a function of the Linux-HA heartbeat?
A. Performsregeneration of failed disks on the hosts.
B. Manages communication and processes on the S-Blades.
C. Performs disk partitioning and status of jobs on the S-Blades.
D. Manages communication and status of services on the hosts.
Where are the database log files located?
A. /var/log
B. /usr/local
C. /nz/kit/log
D. The SYSTEM database
In order for an ODBC application running on Microsoft Windows to connect to PureData System for Analytics, which two steps must be performed? (Choose two.)
A. Install nzsql forWindows.
B. Install nzAdmin for Windows.
C. Install an ODBC driver for Windows.
D. Install an ODBC Driver Manager for Windows.
E. Create or modify a Data Source Name (DSN) for a connection to a database.
Which statement is true?
A. All user space is available for database expansion.
B. Each database is assigned it's own section of disk space.
C. When creating the database you can specify which disks to use.
D. When you create a database you can set the maximum space it is allowed to use.
You havecreated a group GroupA with JOB MAXIMUM of 4, which statement is true?
A. No more than 4 users can be assigned to GroupA.
B. If users in GroupA submit more than 4 queries they will fail.
C. If users in GroupA submit more than 4 queries, then they will queue in order.
D. The job maximum cannot be less than the default concurrent query limit of 48.
To create a database table, at a minimum, what must be specified?
A. column name and data type.
B. column name, data type and primary key.
C. column name, data type and default constraint.
D. column name, data type and distribute on clause.
When doing a CREATE TABLE, constraints can be specified at the column level. Which two constraints are NOT automatically enforced via the database? (Choose two.)
A. NULL
B. UNIQUE
C. NOT NULL
D. PRIMARY KEY
E. DEFAULT value
What is the state of the two hosts on a properly functional PureData System for Analytics Appliance?
A. Active - Active
B. Active - Stand by
C. Stand by -Backup
D. Stand by - Passive
In a UNIX 64bit environment, a 64bit application requires which software to execute SQL statements via ODBC? (Choose two.)
A. nzsql
B. An ODBC driver manager.
C. The system does not support 64 bit ODBC.
D. A 64-bit ODBC driverfor the same UNIX environment.
E. A 32-bit ODBC driver for the same UNIX environment.
How does the PureData System for Analytics utilize the distribution key to store records on disk?
A. System assigns records to a FPGA based on their distribution key value.
B. System assigns records to the host based on their distribution key value.
C. System assigns records to a logical data slicebased on their distribution key value.
D. System assigns records to a Netezza Database Accelerator based on their distribution key value.
