IBM C1000-085 Exam Practice Test Instant Access

Question 1

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 2

What happens to NFS mounts after a container failover?

ANFS is handled by Red Hat OpenShift and does not need to be mounted.

BSysmgr will remount it as part of the IBM Netezza Performance Server environment

CA containers do not allow for NFS mounts.

DIt will be automatically mounted by the ipsnfs service.

Answer : A

Question 3

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 4

Which two commands can be used to get a plan file for a query?

Anzsql -c 'show planfile '

Bnzsql -c 'select plan_text from _v_plan'

Cnzsql -c 'get planfile '

Dnz_get

Enz_plan

Answer : A, D

Question 5

Which two external methods can IBM Netezza Performance Server use to authenticate database users?

ALDAP

BSSH

CRadius

DPKI-Based

EKerberos

Answer : A, D

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 Netezza Performance Server V11.x Administrator C1000-085 Exam Practice Test