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

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

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)

Questions # 4:

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

Question # 4

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

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

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/

Questions # 8:

Which two file formats are valid for external tables?

Options:
A.

text-delimited

B.

fixed-length

C.

JSON

D.

HL7

E.

XML

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.

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

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