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 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 7

What are two important factors to consider when selecting a distribution key?

Anot Nullable constraint

Bcolumns used for filters

Cdistinct values

Dcolumns used for joins

Etable constraints

Answer : A, B

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