If you are going to take your C100-085 IBM Netezza Performance Server V11.x Administrator exam, then you can choose PassQuestion C1000-085 Practice Test Questions to help you in your IBM C1000-085 exam preparation. It provides real questions and answers to help you improve your skills and learn more effectively. C1000-085 Practice Test Questions will help you identify the content and difficulty level of the questions and the practice Exams will make you familiar with the format and environment of an exam. You should refer this C1000-085 Practice Test Questions carefully before attempting your actual exam. Your success is 100% guaranteed.

IBM Certified Administrator - IBM Netezza Performance Server V11.x

An IBM Certified Administrator - IBM Netezza Performance Server V11.x is an experienced administrator. This individual has significant experience as a database administrator and extensive knowledge of how the IBM Netezza Performance Server works. This individual can perform tasks related to administration, monitoring, security, implementation and configuration.

Exam Details

Exam Code: C1000-085
Exam Name: IBM Netezza Performance Server V11.x Administrator
Number of questions: 60
Number of questions to pass: 41
Time allowed: 90 minutes
Languages: English
Price: $200 USD
Certification: IBM Certified Administrator - Netezza Performance Server V11.x

Exam Sections

Section 1: Architecture  18%
Section 2: Best Practices for Database Design   22%
Section 3: Monitoring and Tuning for Performance   20%
Section 4: Administration   20%
Section 5: Support and Maintenance   8%
Section 6: Netezza Clients and Tools    12%

View Online IBM Netezza Performance Server V11.x Administrator C1000-085 Free Questions

What access is required to create a new user in IBM Netezza Performance Server?
A. An account with NEW USER administrative privilege
B. An account with CREATE USER administrative privilege.
C. An account with CREATE GROUP access on the host OS.
D. An account with CREATE ID access on the host OS.
Answer: A

How does IBM Netezza Performance Server store data?
A. Tables are distributed across all data slices compressed
B. Tables are distributed to a single data slice compressed.
C. Tables are distributed across all data slices uncompressed.
D. Tables are distributed across a subset of data slices uncompressed.
Answer: A

Which two command line support tools are used to determine the order of data for a given table?
A. nz_physical_table_layout
B. nz_zonemap
C. nz_pagemap
D. nz_sort_order
E. nz_get
Answer: B,C

What are Clustered Base Tables (CBT)?
A. Tables that decrease allocated storage
B. Tables that contain sorted data using one to four columns.
C. Tables that increase pre-sorting of new table records before a loading operation.
D. Tables that replicate the base table.
Answer: B

To enable or disable multiple schema support on the IBM Netezza Performance Server, which configuration file needs to be updated?
A. system.cfg
B. pg_hba.conf
C. postgresql.conf
D. startup.cfg
Answer: C

When is a PRIMARY KEY (PK) table constraint evaluated during an INSERT statement into the table?
A. The PK constraint is never checked when a row is inserted into the table.
B. After the row is inserted into the table.
C. Before the row is inserted into the table.
D. The PK constraint is only checked during a GENERATE STATISTICS operation.
Answer: C