IBM C1000-085 Exam Questions Instant Access

Question 1

By default, when are the postgres logs rotated on an IBM Netezza Performance Server?

Ahourly or greater than 100 MB

Bdaily or greater than 1 GB

Cmonthly or greater than 10 GB

Dweekly or greater than 5 GB

Answer : A

Question 2

What is the maximum length of a CHAR/VARCHAR column?

A65.535

B32.000

C64,000

D16.000

Answer : A

Question 3

What are Clustered Base Tables (CBT)?

ATables that decrease allocated storage

BTables that contain sorted data using one to four columns.

CTables that increase pre-sorting of new table records before a loading operation.

DTables that replicate the base table.

Answer : B

Question 4

When integrating IBM Spectrum Protect into IBM Netezza Performance Server (NPS) for backup and restore, how must the NPS host be defined?

Aas a client of the storage manager server

Bas the primary storage manager server

Cas the primary backup target

Das a cloud storage repository

Answer : A

Question 5

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

ASUBORDINATE NODE

BMASTER NODE

CSTANDBY NODE

DPRIMARY NODE

Answer : B

Question 6

Which log file provides a DBA with an actual SQL statement that was executed?

Aclientmgr.log

Bpg.log

Csysmgr.log

Ddbos.log

Answer : C

Question 7

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

AIt is the hostname of the storage server

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

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

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

Answer : C

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