Free C1000-085 Exam Braindumps (page: 3)

Page 3 of 16

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

  1. not Nullable constraint
  2. columns used for filters
  3. distinct values
  4. columns used for joins
  5. table constraints

Answer(s): A,B



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

  1. nzsql -c "show planfile <planid>"
  2. nzsql -c "select plan_text from _v_plan"
  3. nzsql -c "get planfile <planid>"
  4. nz_get <planid>
  5. nz_plan <planid>

Answer(s): A,D



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

  1. LDAP
  2. SSH
  3. Radius
  4. PKI-Based
  5. Kerberos

Answer(s): A,D



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

  1. stopped
  2. paused
  3. discovering
  4. down

Answer(s): B



Page 3 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