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 21:

    What command is used to add an event?

    A. nzevent add

    B. nzevent insert

    C. nzevent load

    D. nzevent create

  • Question 22:

    Within a database session, which syntax allows a user to change to a different schema (NEW_SCHEMA)?

    A. ALTER SESSION SET SCHEMA=NEW_SCHEMA

    B. SET CURRENT SCHEMA TO NEW_SCHEMA

    C. SET SCHEMA NEW_SCHEMA

    D. ALTER DATABASE database name SET DEFAULT SCHEMA NEW SCHEMA

  • Question 23:

    Which three scripts are included in the IBM Netezza Performance Server Software Support Tools?

    A. nzsql

    B. nz_ddl

    C. nzsqa

    D. nz_stats

    E. nzbackup

    F. nz tables

  • Question 24:

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

    A. LDAP

    B. SSH

    C. Radius

    D. PKI-Based

    E. Kerberos

  • Question 25:

    What are two valid column constraints?

    A. DEFAULT

    B. INITIALLY IMMEDIATE

    C. INITIALLY DEFERRED

    D. NULL

    E. DEFERRABLE

  • Question 26:

    What nzsqa option can be used to view workload metrics including usage summary, resource usage and short/long running jobs?

    A. nzsqa progress

    B. nzsqa wlm

    C. nzsqa responders

    D. nzsqa schedqueues -sys

  • Question 27:

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

    A. stopped

    B. paused

    C. discovering

    D. down

  • Question 28:

    Which is the most efficient data type for distribution keys?

    A. integers

    B. internal datatypes (ROWID etc.)

    C. temporal types

    D. strings

  • Question 29:

    What is required in order to restore a specific table using the nz_restore support tool?

    A. A table needs to be backed up by using nzbackup utility.

    B. A table that is being restored must have the same name in the backup set.

    C. The userspace must be provided

    D. The table structure (DDL) needs to exist

  • Question 30:

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

    A. not Nullable constraint

    B. columns used for filters

    C. distinct values

    D. columns used for joins

    E. table constraints

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.