IBM C1000-085 Online Practice Questions and Exam Preparation

IBM C1000-085 Online 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.
  A. The admin user should be deleted after installing NPS.

• Question 2:

  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
  A. libnetinza-version.tar gz
  E. libnetsqlkit-version.tar.gz

• Question 3:

  Which two file formats are valid for external tables?

  A. text-delimited
  B. fixed-length
  C. JSON
  D. HL7
  E. XML
  A. text-delimited
  C. JSON

• 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
  A. ap hw
  D. ap sw

• 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
  A. create IBM Object Storage

• 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
  A. To define load operations in a text file instead of having to specify options on the command line

• 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
  A. to show and change the system state

• Question 8:

  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
  A. Primary

• Question 9:

  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
  B. displays information from nzsql responders -all in a more user-friendly format

• 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/
  D. /nz/kit/