IBM C1000-085 IBM Netezza Performance Server V11.x Administrator Exam Exam Practice Test Questions

• Question 1

  Which two file formats are valid for external tables?

  • Text-delimited
  • Fixed-length
  • JSON
  • HL7
  • XML

  Show Answer Answer: A, C Next

• Question 2

  In IBM Netezza Performance Server, what storage file system is shared across the host containers?

  • IBM Spectrum Scale or General Parallel File System (GPFS)
  • NT File System (NTFS)
  • Glusterfs
  • 2 File System (ZFS)

  Show Answer Answer: B Next

• Question 3

  When computing the row size for a table row, what overhead should be accounted for?

  • 48 bytes for ROWID, CREATEXID and DELETEXID only
  • 32 bytes for ROWID. CREATEXID, DELETEXID and the null vector
  • 32 bytes for ROWID. CREATEXID and DELETEXID and a variable number of bytes for the null vector if there are nullable columns
  • 24 bytes for ROWID. CREATEXID and DELETEXID plus null vector if there are nullable columns and record header depending on string columns

  Show Answer Answer: A Next

• Question 4

  What ap cli command is used to disable a node?

  • Ap node power off
  • Ap node set__personality fail
  • Ap stopnode
  • Ap node disable

  Show Answer Answer: D Next

• Question 5

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

  • Create IBM Object Storage
  • Query performance
  • Create new service
  • Monitor snippets

  Show Answer Answer: A Next