IBM C1000-085 Exam Practice Test Instant Access

Question 1

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

AIBM Spectrum Scale or General Parallel File System (GPFS)

BNT File System (NTFS)

CGlusterfs

D2 File System (ZFS)

Answer : B

Question 2

How does IBM Netezza Performance Server store data?

ATables are distributed across all data slices compressed

BTables are distributed to a single data slice compressed.

CTables are distributed across all data slices uncompressed.

DTables are distributed across a subset of data slices uncompressed.

Answer : A

Question 3

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

Anzsql

Bnz_ddl

Cnzsqa

Dnz_stats

Enzbackup

Fnz tables

Answer : C, E, F

Question 4

Which log file provides a DBA with an actual SQL statement that was executed?

Aclientmgr.log

Bpg.log

Csysmgr.log

Ddbos.log

Answer : C

Question 5

Which system view stores the information on how many resources have been allocated for the resource group versus how many were allowed?

A_v_sched_gra

B_v_system_util

C_v_qryhist

D_v_plan_resource

Answer : D

Question 6

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

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

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

CThe userspace must be provided

DThe table structure (DDL) needs to exist

Answer : A

Question 7

Which is the most efficient data type for distribution keys?

Aintegers

Binternal datatypes (ROWID etc.)

Ctemporal types

Dstrings

Answer : D

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