IBM C1000-085 Exam Questions 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

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

Answer : D

Question 3

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

A65.535

B32.000

C64,000

D16.000

Answer : A

Question 4

Which command is used to register a user defined table function in the database?

ACREATE FUNCTION

Bnzudxcompile

CALTER FUNCTION

DECHO

Answer : A

Question 5

Which state does the nzstate command show when the IBM Netezza Performance Server system fails to initialize?

Astopped

Bpaused

Cdiscovering

Ddown

Answer : B

Question 6

What are two primary purposes of UDX?

Ait is a required component of all Netezza SQL commands

Bto force execution only on the SPU nodes

Cto offer new and unique types of analyses through customized code

Dto showcase one's capability to write UDX code to duplicate existing SQL functions

Eto accelerate analysis by processing data in-database

Answer : D, E

Question 7

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

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