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

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

Question 3

What nzsqa option can be used to view workload metrics including usage summary, resource usage and short/long running jobs?

Anzsqa progress

Bnzsqa wlm

Cnzsqa responders

Dnzsqa schedqueues -sys

Answer : C

Question 4

Which statement regarding the IBM Netezza Performance Server (NPS) admin database user is true?

AThe admin user should be deleted after installing NPS.

BThe admin user is added to the host OS before installing NPS.

CThe admin user can not be deleted after installing NPS.

DThe admin user is the only owner of a database on NPS.

Answer : A

Question 5

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 6

Which is the most efficient data type for distribution keys?

Aintegers

Binternal datatypes (ROWID etc.)

Ctemporal types

Dstrings

Answer : D

Question 7

What ap cli command is used to disable a node?

Aap node power off

Bap node set__personality fail

Cap stopnode

Dap node disable

Answer : D

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