IBM IBM Certified Administrator - Netezza Performance Server V11.x C1000-085 Questions & Answers

• Question 1:

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

  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.

  Correct Answer: A

• Question 2:

  Which two file formats are valid for external tables?

  A. text-delimited

  B. fixed-length

  C. JSON

  D. HL7

  E. XML

  Correct Answer: AC

• Question 3:

  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

  Correct Answer: AE

• Question 4:

  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

  Correct Answer: AD

• Question 5:

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

  A. create IBM Object Storage

  B. query performance

  C. create new service

  D. monitor snippets

  Correct Answer: A

• Question 6:

  What is the purpose of the nzload control file?

  A. To define load operations in a text file instead of having to specify options on the command line

  B. To ensure that a simple load that uses external tables continues after the system is paused and resumed.

  C. To take advantage of a named pipe capability to stream the data to external tables faster.

  D. To control the re-load operations of me data file after every load failure

  Correct Answer: A

• Question 7:

  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

  Correct Answer: A

  https://www.ibm.com/support/knowledgecenter/SSULQD_7.2.1/com.ibm.nz.adm.doc/r_sys adm_nzsystem_cmd.html

• Question 8:

  Which statement is correct about command nz_responders?

  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

  Correct Answer: B

• Question 9:

  Which partition on the SPU node us used to store transient working data that is generated during query execution?

  A. Primary

  B. Nzscratch

  C. Mirror

  D. nzlocal

  Correct Answer: A

• Question 10:

  The nzhostbackup command backs up which directory by default?

  A. /nz/data/

  B. /nzscratch/

  C. /ex port/ho me/nz

  D. /nz/kit/

  Correct Answer: D