IBM c1000-085 practice test

IBM Netezza Performance Server V11.x Administrator

Last exam update: Dec 08 ,2025
Page 1 out of 4. Viewing questions 1-15 out of 60

Question 1

What two files are extracted from the SQL Extension toolkit package?

  • A. libnetinza-version.tar gz
  • B. libnetsqlext-version.tar.gz
  • C. libnetxml-version.tar.gz
  • D. libnetcrypto-version.tar.gz
  • E. libnetsqlkit-version.tar.gz
Mark Question:
Answer:

AE


User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 2

To enable or disable multiple schema support on the IBM Netezza Performance Server, which
configuration file needs to be updated?

  • A. system.cfg
  • B. pg_hba.conf
  • C. postgresql.conf
  • D. startup.cfg
Mark Question:
Answer:

C


User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 3

Which two products or methods can be used for disaster recovery when using IBM Netezza
Performance Servers?

  • A. Cloud Pak for Data
  • B. InfoSphere Data Replication
  • C. Netezza Replication Services
  • D. Data Serialization
  • E. NPS Backup and Restore
Mark Question:
Answer:

BE


User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 4

What is the purpose of the nzstate command?

  • A. restore the database to the last backup
  • B. list the state of the system
  • C. list the states of backups available
  • D. list the state of a running query
Mark Question:
Answer:

A


User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 5

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

  • A. online
  • B. running
  • C. stopped
  • D. paused
Mark Question:
Answer:

C


User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 6

What are Clustered Base Tables (CBT)?

  • 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.
Mark Question:
Answer:

B


User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 7

Which two commands are used to list all hardware and software components on Cloud Pak for Data
System?

  • A. ap hw
  • B. nzsw
  • C. nzhv
  • D. ap sw
  • E. oc pod -h -s
Mark Question:
Answer:

AD


User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 8

What is a purpose of the command nzsystem?

  • A. to show and change the system state
  • B. to show and change nzroot use
  • C. to show and change system users
  • D. to show and change system access
Mark Question:
Answer:

A


Explanation:
https://www.ibm.com/support/knowledgecenter/SSULQD_7.2.1/com.ibm.nz.adm.doc/r_sysadm_nzsystem_cmd.html

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 9

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

  • A. not Nullable constraint
  • B. columns used for filters
  • C. distinct values
  • D. columns used for joins
  • E. table constraints
Mark Question:
Answer:

AB


User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 10

Which two commands can be used to get a plan file for a query?

  • A. nzsql -c "show planfile <planid>"
  • B. nzsql -c "select plan_text from _v_plan"
  • C. nzsql -c "get planfile <planid>"
  • D. nz_get <planid>
  • E. nz_plan <planid>
Mark Question:
Answer:

AD


User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 11

Which two external methods can IBM Netezza Performance Server use to authenticate database
users?

  • A. LDAP
  • B. SSH
  • C. Radius
  • D. PKI-Based
  • E. Kerberos
Mark Question:
Answer:

AD


User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 12

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

  • A. stopped
  • B. paused
  • C. discovering
  • D. down
Mark Question:
Answer:

B


User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 13

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

  • A. nzcm —inza
  • B. nzrev --inza
  • C. nzinza
  • D. inzarev
Mark Question:
Answer:

A


User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 14

What ap cli command is used to disable a node?

  • A. ap node power off
  • B. ap node set__personality fail
  • C. ap stopnode
  • D. ap node disable
Mark Question:
Answer:

D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 15

Which is the most efficient data type for distribution keys?

  • A. integers
  • B. internal datatypes (ROWID etc.)
  • C. temporal types
  • D. strings
Mark Question:
Answer:

D


User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
To page 2