Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

IBM C1000-085 - IBM Netezza Performance Server V11.x Administrator

Page: 1 / 2
Total 60 questions

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

A.

nzsql

B.

nz_ddl

C.

nzsqa

D.

nz_stats

E.

nzbackup

F.

nz tables

Which date time format is used to capture history activities?

A.

system time

B.

local time

C.

EST

D.

GMT

What should be the state of the IBM Netezza Performance Server system in order to run the nz_manual_vacuum command?

A.

online

B.

running

C.

stopped

D.

paused

How can a user update statistics on a table?

A.

by running UPDATE STATISTICS

B.

by running a query against the table

C.

by running GENERATE STATISTICS

D.

by restarting the database

What command is used to add an event?

A.

nzevent add

B.

nzevent insert

C.

nzevent load

D.

nzevent create

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

Which two scenarios can be addressed using the nz_check_disk_scan_speeds command?

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

What is the duration of SQB by default?

A.

3 seconds

B.

6 seconds

C.

2 seconds

D.

10 seconds

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

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

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