IBM
C1000-085
Q1:
In IBM Netezza Performance Server, what storage file system is shared across the host containers?
○
A
IBM Spectrum Scale or General Parallel File System (GPFS)○
B
NT File System (NTFS)○
C
Glusterfs○
D
2 File System (ZFS)
IBM
C1000-085
Q2:
How does IBM Netezza Performance Server store data?
○
A
Tables are distributed across all data slices compressed○
B
Tables are distributed to a single data slice compressed.○
C
Tables are distributed across all data slices uncompressed.○
D
Tables are distributed across a subset of data slices uncompressed.
IBM
C1000-085
Q3:
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
IBM
C1000-085
Q4:
Which log file provides a DBA with an actual SQL statement that was executed?
○
A
clientmgr.log○
B
pg.log○
C
sysmgr.log○
D
dbos.log
IBM
C1000-085
Q5:
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