1. Home
  2. IBM
  3. IBM Certified Administrator - Netezza Performance Server V11.x
  4. C1000-085
  5. IBM Netezza Performance Server V11.x Administrator Questions and Answers

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

 IBM Exams      Go to Exam Detail      Get Premium Access
Viewing page 2 out of 2 pages
Viewing questions 11-20 out of questions
Questions # 11:

Which three scripts are included in the IBM Netezza Performance Server Software Support Tools?

Options:
A.

nzsql

B.

nz_ddl

C.

nzsqa

D.

nz_stats

E.

nzbackup

F.

nz tables

Expert Solution
Questions # 12:

What is the duration of SQB by default?

Options:
A.

3 seconds

B.

6 seconds

C.

2 seconds

D.

10 seconds

Expert Solution
Questions # 13:

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

Options:
A.

create IBM Object Storage

B.

query performance

C.

create new service

D.

monitor snippets

Expert Solution
Questions # 14:

Which date time format is used to capture history activities?

Options:
A.

system time

B.

local time

C.

EST

D.

GMT

Expert Solution
Questions # 15:

Which level of transaction isolation does IBM Netezza Performance Server implement?

Options:
A.

uncommitted read

B.

serializable

C.

repeatable read

D.

committed read

Expert Solution
Questions # 16:

What are Clustered Base Tables (CBT)?

Options:
A.

Tables that decrease allocated storage

B.

Tables that contain sorted data using one to four columns.

C.

Tables that increase pre-sorting of new table records before a loading operation.

D.

Tables that replicate the base table.

Expert Solution
Questions # 17:

Which statement regarding the IBM Netezza Performance Server (NPS) admin database user is true?

Options:
A.

The admin user should be deleted after installing NPS.

B.

The admin user is added to the host OS before installing NPS.

C.

The admin user can not be deleted after installing NPS.

D.

The admin user is the only owner of a database on NPS.

Expert Solution
Questions # 18:

Which statement is correct about command nz_responders?

Options:
A.

displays user activity in tabular format

B.

displays information from nzsql responders -all in a more user-friendly format

C.

displays information from nzsqa responders -sys in a more user-friendly format

D.

displays resource utilization statistics in JSON format

Expert Solution
Viewing page 2 out of 2 pages
Viewing questions 11-20 out of questions