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

IBM C1000-085 Premium Access     Download Demo    
Page: 2 / 2
Total 60 questions

Which two file formats are valid for external tables?

A.

text-delimited

B.

fixed-length

C.

JSON

D.

HL7

E.

XML

What are two valid column constraints?

A.

DEFAULT

B.

INITIALLY IMMEDIATE

C.

INITIALLY DEFERRED

D.

NULL

E.

DEFERRABLE

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)

What access is required to create a new user in IBM Netezza Performance Server?

A.

An account with NEW USER administrative privilege

B.

An account with CREATE USER administrative privilege.

C.

An account with CREATE GROUP access on the host OS.

D.

An account with CREATE ID access on the host OS.

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

A.

nz_plan querytext

B.

EXPLAIN PLAN FILE querytext

C.

EXPLAIN PLANGRAPH querytext

D.

EXPLAIN querytext

E.

nzsql -t querytext -0 planfile.pln

When computing the row size for a table row, what overhead should be accounted for?

A.

48 bytes for ROWID, CREATEXID and DELETEXID only

B.

32 bytes for ROWID. CREATEXID, DELETEXID and the null vector

C.

32 bytes for ROWID. CREATEXID and DELETEXID and a variable number of bytes for the null vector if there are nullable columns

D.

24 bytes for ROWID. CREATEXID and DELETEXID plus null vector if there are nullable columns and record header depending on string columns

Which statement regarding drive failure is true?

A.

Queries and transactions are not interrupted by drive failure if their data is not on the failed drive.

B.

Queries and transactions are not interrupted in the event of a drive failure.

C.

Queries and transactions are interrupted by drive failure because there is no drive mirroring for drives.

D.

Running queries and transactions will finish, but new transactions will not be allowed till drive is changed.

To how many resource groups can a user be assigned?

A.

four

B.

unlimited

C.

three

D.

one