Skip to main content

C1000-085 Real Exam Questions

IBM Netezza Performance Server V11.x Administrator

60 questions available · Page 1 of 6

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Multiple choice

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

  1. A

    nz_physical_table_layout

  2. B

    nz_zonemap

  3. C

    nz_pagemap

  4. D

    nz_sort_order

  5. E

    nz_get

Show answer and explanation

Correct answers: B, C

Question 2 Multiple choice

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

  1. A

    LDAP

  2. B

    SSH

  3. C

    Radius

  4. D

    PKI-Based

  5. E

    Kerberos

Show answer and explanation

Correct answers: A, D

Question 3 Single choice

What command is used to add an event?

  1. A

    nzevent add

  2. B

    nzevent insert

  3. C

    nzevent load

  4. D

    nzevent create

Show answer and explanation

Correct answer: A

Question 4 Single choice

Which is a valid statement regarding event rules on the IBM Netezza Performance Server (NPS) Console?

  1. A

    New event rules can be added using the queries panel in NPS Console.

  2. B

    New event rules can be added using the event rules panel in NPS Console.

  3. C

    New event rules can only be added in the host container.

  4. D

    New event rules must be added using the npsaddevent command.

Show answer and explanation

Correct answer: D

Question 5 Single choice

To enable or disable multiple schema support on the IBM Netezza Performance Server, which configuration file needs to be updated?

  1. A

    system.cfg

  2. B

    pg_hba.conf

  3. C

    postgresql.conf

  4. D

    startup.cfg

Show answer and explanation

Correct answer: C

Question 6 Single choice

What are Clustered Base Tables (CBT)?

  1. A

    Tables that decrease allocated storage

  2. B

    Tables that contain sorted data using one to four columns.

  3. C

    Tables that increase pre-sorting of new table records before a loading operation.

  4. D

    Tables that replicate the base table.

Show answer and explanation

Correct answer: B

Question 7 Single choice

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

  1. A

    Primary

  2. B

    Nzscratch

  3. C

    Mirror

  4. D

    nzlocal

Show answer and explanation

Correct answer: A

Question 8 Multiple choice

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

  1. A

    not Nullable constraint

  2. B

    columns used for filters

  3. C

    distinct values

  4. D

    columns used for joins

  5. E

    table constraints

Show answer and explanation

Correct answers: A, B

Question 9 Single choice

What is the purpose of the nzstate command?

  1. A

    restore the database to the last backup

  2. B

    list the state of the system

  3. C

    list the states of backups available

  4. D

    list the state of a running query

Show answer and explanation

Correct answer: A

Question 10 Single choice

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

  1. A

    any column used in table constraints

  2. B

    any column with low cardinality

  3. C

    a technical or surrogate key

  4. D

    any date column commonly used in queries

Show answer and explanation

Correct answer: A