1. Home
  2. IBM
  3. IBM Certified Administrator - Netezza Performance Server V11.x
  4. C1000-085
  5. IBM Netezza Performance Server V11.x Administrator Questions and Answers

Pass the IBM IBM Certified Administrator - Netezza Performance Server V11.x C1000-085 Questions and answers with CertsForce

 IBM Exams      Go to Exam Detail      Get Premium Access
Viewing page 1 out of 2 pages
Viewing questions 1-10 out of questions
Questions # 1:

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

Options:
A.

nz_physical_table_layout

B.

nz_zonemap

C.

nz_pagemap

D.

nz_sort_order

E.

nz_get

Expert Solution
Questions # 2:

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

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

Expert Solution
Questions # 3:

In IBM Netezza Performance Server, what storage file system is shared across the host containers?

Options:
A.

IBM Spectrum Scale or General Parallel File System (GPFS)

B.

NT File System (NTFS)

C.

Glusterfs

D.

2 File System (ZFS)

Expert Solution
Questions # 4:

What is the order of the operations of a typical snippet in a query plan?

Question # 4

Expert Solution
Questions # 5:

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

Expert Solution
Questions # 6:

What is a purpose of the command nzsystem?

Options:
A.

to show and change the system state

B.

to show and change nzroot use

C.

to show and change system users

D.

to show and change system access

Expert Solution
Questions # 7:

The nzhostbackup command backs up which directory by default?

Options:
A.

/nz/data/

B.

/nzscratch/

C.

/ex port/ho me/nz

D.

/nz/kit/

Expert Solution
Questions # 8:

Which two file formats are valid for external tables?

Options:
A.

text-delimited

B.

fixed-length

C.

JSON

D.

HL7

E.

XML

Expert Solution
Questions # 9:

What happens to NFS mounts after a container failover?

Options:
A.

NFS is handled by Red Hat OpenShift and does not need to be mounted.

B.

Sysmgr will remount it as part of the IBM Netezza Performance Server environment

C.

A containers do not allow for NFS mounts.

D.

It will be automatically mounted by the ipsnfs service.

Expert Solution
Questions # 10:

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

Expert Solution
Viewing page 1 out of 2 pages
Viewing questions 1-10 out of questions