1. Home
  2. IBM
  3. C1000-085

IBM Netezza Performance Server V11.x Administrator

Exam Details

  • Exam Code
    :C1000-085
  • Exam Name
    :IBM Netezza Performance Server V11.x Administrator
  • Certification
    :IBM Certified Administrator - Netezza Performance Server V11.x
  • Vendor
    :IBM
  • Total Questions
    :60 Q&As
  • Last Updated
    :May 14, 2024

IBM IBM Certified Administrator - Netezza Performance Server V11.x C1000-085 Questions & Answers

  • Question 11:

    What is the name of the IBM Netezza Performance Server Replication node at the target nodes when using Netezza Replication Services?

    A. SUBORDINATE NODE

    B. MASTER NODE

    C. STANDBY NODE

    D. PRIMARY NODE

  • Question 12:

    To how many resource groups can a user be assigned?

    A. four

    B. unlimited

    C. three

    D. one

  • Question 13:

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

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

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

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

    D. New event rules must be added using the npsaddevent command.

  • Question 14:

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

    A. any column used in table constraints

    B. any column with low cardinality

    C. a technical or surrogate key

    D. any date column commonly used in queries

  • Question 15:

    How can a user update statistics on a table?

    A. by running UPDATE STATISTICS

    B. by running a query against the table

    C. by running GENERATE STATISTICS

    D. by restarting the database

  • Question 16:

    What is the duration of SQB by default?

    A. 3 seconds

    B. 6 seconds

    C. 2 seconds

    D. 10 seconds

  • Question 17:

    What command is used to verify the release of IBM Netezza Performance Server Analytics installed?

    A. nzcm --inza

    B. nzrev --inza

    C. nzinza

    D. inzarev

  • Question 18:

    Which statement is true when executing the GROM command on a Clustered Base Table (CBT)?

    A. It reclaims space from deleted rows and does not re-order data

    B. Enough space is required for GROOM to make a complete copy of the table

    C. GROOM uses CREATE TABLE AS SELECT (CATAS) for CBT to reclaim space and re- order data.

    D. It reclaims space from deleted rows and re-orders data.

  • Question 19:

    Which two scenarios can be addressed using the nz_check_disk_scan_speeds command?

    A. check system status

    B. get skew information distributed across disks

    C. see disk read and write speeds

    D. slow performing SPU or drive

    E. get disk storage utilization details

  • Question 20:

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

    A. hourly or greater than 100 MB

    B. daily or greater than 1 GB

    C. monthly or greater than 10 GB

    D. weekly or greater than 5 GB

Related Exams:

Tips on How to Prepare for the Exams

Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your C1000-085 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.