IBM C1000-085 Exam Questions Instant Access

Question 1

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 2

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 3

What should be the state of the IBM Netezza Performance Server system in order to run the nz_manual_vacuum command?

Aonline

Brunning

Cstopped

Dpaused

Answer : C

Question 4

How can a user update statistics on a table?

Aby running UPDATE STATISTICS

Bby running a query against the table

Cby running GENERATE STATISTICS

Dby restarting the database

Answer : A

Question 5

Which state does the nzstate command show when the IBM Netezza Performance Server system fails to initialize?

Astopped

Bpaused

Cdiscovering

Ddown

Answer : B

Question 6

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

Question 7

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

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