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

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 3

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 4

What is the duration of SQB by default?

A3 seconds

B6 seconds

C2 seconds

D10 seconds

Answer : C

Question 5

When choosing a distribution key for a large fact table, what is a valid choice?

Aany column used in table constraints

Bany column with low cardinality

Ca technical or surrogate key

Dany date column commonly used in queries

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