Labour Day Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: scxmas70

C1000-085 Exam Dumps - IBM Netezza Performance Server V11.x Administrator

Question # 4

When restoring a database using nzrestore utility, which is true for the npshost option?

A.

It is the hostname of the storage server

B.

It is a HOSTNAME value set in backupHostname.txt file on the backup source system.

C.

It is a host name of the target system to restore a database to.

D.

It is a remote host name or IP address of the system to connect to.

Full Access
Question # 5

What is the name of the IBM Netezza Performance Server Replication node at the target nodes when using Netezza Replication Services?

A.

SUBORDINATE NODE

B.

MASTER NODE

C.

STANDBY NODE

D.

PRIMARY NODE

Full Access
Question # 6

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.

Full Access
Question # 7

In IBM Netezza Performance Server, what storage file system is shared across the host containers?

A.

IBM Spectrum Scale or General Parallel File System (GPFS)

B.

NT File System (NTFS)

C.

Glusterfs

D.

2 File System (ZFS)

Full Access
Question # 8

What are two valid column constraints?

A.

DEFAULT

B.

INITIALLY IMMEDIATE

C.

INITIALLY DEFERRED

D.

NULL

E.

DEFERRABLE

Full Access
Question # 9

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

Full Access