IBM C1000-085 Exam Practice Test Instant Access

Question 1

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 2

What is the maximum length of a CHAR/VARCHAR column?

A65.535

B32.000

C64,000

D16.000

Answer : A

Question 3

Which two commands will show a query plan without running the query?

Anz_plan querytext

BEXPLAIN PLAN FILE querytext

CEXPLAIN PLANGRAPH querytext

DEXPLAIN querytext

Enzsql -t querytext -0 planfile.pln

Answer : A, D

Question 4

Which two scenarios can be addressed using the nz_check_disk_scan_speeds command?

Acheck system status

Bget skew information distributed across disks

Csee disk read and write speeds

Dslow performing SPU or drive

Eget disk storage utilization details

Answer : B, E

Question 5

Which two cross-database SQL operations are allowed?

ADELETE

BALTER VIEW

CALTER TABLE

DCREAE TABLE

EREVOKE

Answer : C, D

Question 6

Which partition on the SPU node us used to store transient working data that is generated during query execution?

APrimary

BNzscratch

CMirror

Dnzlocal

Answer : A

Question 7

Which statement is true when executing the GROM command on a Clustered Base Table (CBT)?

AIt reclaims space from deleted rows and does not re-order data

BEnough space is required for GROOM to make a complete copy of the table

CGROOM uses CREATE TABLE AS SELECT (CATAS) for CBT to reclaim space and re-order data.

DIt reclaims space from deleted rows and re-orders data.

Answer : A

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

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7