IBM C1000-085 Exam Practice Test Instant Access

Question 1

Which is a valid statement regarding event rules on the IBM Netezza Performance Server (NPS) Console?

ANew event rules can be added using the queries panel in NPS Console.

BNew event rules can be added using the event rules panel in NPS Console.

CNew event rules can only be added in the host container.

DNew event rules must be added using the npsaddevent command.

Answer : D

Question 2

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 3

When computing the row size for a table row, what overhead should be accounted for?

A48 bytes for ROWID, CREATEXID and DELETEXID only

B32 bytes for ROWID. CREATEXID, DELETEXID and the null vector

C32 bytes for ROWID. CREATEXID and DELETEXID and a variable number of bytes for the null vector if there are nullable columns

D24 bytes for ROWID. CREATEXID and DELETEXID plus null vector if there are nullable columns and record header depending on string columns

Answer : A

Question 4

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

Question 5

Which statement is accurate regarding snippets?

AThe number of snippets depends on query and complexity.

BEvery query is always turned into four snippets.

CEvery query is always turned into one snippet.

DThe number of snippets is always based on the size of the system.

Answer : C

Question 6

What is the duration of SQB by default?

A3 seconds

B6 seconds

C2 seconds

D10 seconds

Answer : C

Question 7

What access is required to create a new user in IBM Netezza Performance Server?

AAn account with NEW USER administrative privilege

BAn account with CREATE USER administrative privilege.

CAn account with CREATE GROUP access on the host OS.

DAn account with CREATE ID access on the host OS.

Answer : A

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