Free C1000-085 Exam Braindumps (page: 6)

Page 6 of 16

Which two command line support tools are used to determine the order of data for a given table?

  1. nz_physical_table_layout
  2. nz_zonemap
  3. nz_pagemap
  4. nz_sort_order
  5. nz_get

Answer(s): B,C



When choosing a distribution key for a large fact table, what is a valid choice?

  1. any column used in table constraints
  2. any column with low cardinality
  3. a technical or surrogate key
  4. any date column commonly used in queries

Answer(s): A



By default, when are the postgres logs rotated on an IBM Netezza Performance Server?

  1. hourly or greater than 100 MB
  2. daily or greater than 1 GB
  3. monthly or greater than 10 GB
  4. weekly or greater than 5 GB

Answer(s): A



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

  1. The admin user should be deleted after installing NPS.
  2. The admin user is added to the host OS before installing NPS.
  3. The admin user can not be deleted after installing NPS.
  4. The admin user is the only owner of a database on NPS.

Answer(s): A



Page 6 of 16



Post your Comments and Discuss IBM C1000-085 exam with other Community members:

saurabh commented on July 06, 2023
Please upload IBM Netezza Performance Server V11.x Administrator exam
Anonymous
upvote