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

Questions # 1:

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

Options:

nzsqa progress

nzsqa wlm

nzsqa responders

nzsqa schedqueues -sys

Questions # 2:

What is the purpose of the nzstate command?

Options:

restore the database to the last backup

list the state of the system

list the states of backups available

list the state of a running query

Questions # 3:

What ap cli command is used to disable a node?

Options:

ap node power off

ap node set__personality fail

ap stopnode

ap node disable

Questions # 4:

What command is used to verify the release of IBM Netezza Performance Server Analytics installed?

Options:

nzcm —inza

nzrev --inza

nzinza

inzarev

Questions # 5:

What is the name of the IBM Netezza Performance Server Replication node at the target nodes when using Netezza Replication Services?

Options:

SUBORDINATE NODE

MASTER NODE

STANDBY NODE

PRIMARY NODE

Questions # 6:

What command is used to add an event?

Options:

nzevent add

nzevent insert

nzevent load

nzevent create

Questions # 7:

What is a valid selection from the home page of the IBM Netezza Performance Server web console?

Options:

create IBM Object Storage

query performance

create new service

monitor snippets

Questions # 8:

To how many resource groups can a user be assigned?

Options:

four

unlimited

three

one

Questions # 9:

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

Options:

not Nullable constraint

columns used for filters

distinct values

columns used for joins

table constraints

Questions # 10:

Which statement regarding drive failure is true?

Options:

Queries and transactions are not interrupted by drive failure if their data is not on the failed drive.

Queries and transactions are not interrupted in the event of a drive failure.

Queries and transactions are interrupted by drive failure because there is no drive mirroring for drives.

Running queries and transactions will finish, but new transactions will not be allowed till drive is changed.

Viewing page 1 out of 2 pages

Viewing questions 1-10 out of questions

Weekend Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple70

Pass the IBM Certified Administrator - Netezza Performance Server V11.x C1000-085 Questions and answers with ExamsMirror

Exam C1000-085 Premium Access

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

TOP CODES