IBM C1000-085 Exam Questions Instant Access

Question 1

What is a valid selection from the home page of the IBM Netezza Performance Server web console?

Acreate IBM Object Storage

Bquery performance

Ccreate new service

Dmonitor snippets

Answer : A

Question 2

What are two valid column constraints?

ADEFAULT

BINITIALLY IMMEDIATE

CINITIALLY DEFERRED

DNULL

EDEFERRABLE

Answer : C, D

Question 3

Which statement regarding the IBM Netezza Performance Server (NPS) admin database user is true?

AThe admin user should be deleted after installing NPS.

BThe admin user is added to the host OS before installing NPS.

CThe admin user can not be deleted after installing NPS.

DThe admin user is the only owner of a database on NPS.

Answer : A

Question 4

Which date time format is used to capture history activities?

Asystem time

Blocal time

CEST

DGMT

Answer : A

Question 5

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 6

What is the purpose of the nzload control file?

ATo define load operations in a text file instead of having to specify options on the command line

BTo ensure that a simple load that uses external tables continues after the system is paused and resumed.

CTo take advantage of a named pipe capability to stream the data to external tables faster.

DTo control the re-load operations of me data file after every load failure

Answer : A

Question 7

When is a PRIMARY KEY (PK) table constraint evaluated during an INSERT statement into the table?

AThe PK constraint is never checked when a row is inserted into the table.

BAfter the row is inserted into the table.

CBefore the row is inserted into the table.

DThe PK constraint is only checked during a GENERATE STATISTICS operation.

Answer : C

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