New Year Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70special

Examstrust Logo
examstrust mcafee
  1. Home
  2. IBM
  3. IBM Certified Administrator - Netezza Performance Server V11.x
  4. C1000-085 - IBM Netezza Performance Server V11.x Administrator

IBM C1000-085 IBM Netezza Performance Server V11.x Administrator Exam Practice Test

Page: 1 / 6
Total 60 questions
Get C1000-085 Full Access Download C1000-085 PDF

IBM Netezza Performance Server V11.x Administrator Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$37.5  $124.99
Add to Cart

PDF + Testing Engine

  • Product Type: PDF + Testing Engine
$52.5  $174.99
Add to Cart

PDF Study Guide

  • Product Type: PDF Study Guide
$33  $109.99
Add to Cart
Question 1

When integrating IBM Spectrum Protect into IBM Netezza Performance Server (NPS) for backup and restore, how must the NPS host be defined?

Options:

A.

as a client of the storage manager server

B.

as the primary storage manager server

C.

as the primary backup target

D.

as a cloud storage repository

Question 2

What are Clustered Base Tables (CBT)?

Options:

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.

Question 3

Which level of transaction isolation does IBM Netezza Performance Server implement?

Options:

A.

uncommitted read

B.

serializable

C.

repeatable read

D.

committed read

Question 4

What is a valid selection from the home page of the IBM Netezza Performance Server web console?

Options:

A.

create IBM Object Storage

B.

query performance

C.

create new service

D.

monitor snippets

Question 5

Which two commands will show a query plan without running the query?

Options:

A.

nz_plan querytext

B.

EXPLAIN PLAN FILE querytext

C.

EXPLAIN PLANGRAPH querytext

D.

EXPLAIN querytext

E.

nzsql -t querytext -0 planfile.pln

Question 6

What are two valid column constraints?

Options:

A.

DEFAULT

B.

INITIALLY IMMEDIATE

C.

INITIALLY DEFERRED

D.

NULL

E.

DEFERRABLE

Question 7

Which two scenarios can be addressed using the nz_check_disk_scan_speeds command?

Options:

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 8

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

Options:

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 9

What is the duration of SQB by default?

Options:

A.

3 seconds

B.

6 seconds

C.

2 seconds

D.

10 seconds

Load More C1000-085 Questions
Page: 1 / 6
Total 60 questions
Get C1000-085 Full Access Download C1000-085 PDF