Labour Day Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: mxmas70

 
Home > IBM > IBM Certified Administrator - Netezza Performance Server V11.x > C1000-085

C1000-085 IBM Netezza Performance Server V11.x Administrator Question and Answers

Question # 4

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.

Full Access
Question # 5

To enable or disable multiple schema support on the IBM Netezza Performance Server, which configuration file needs to be updated?

A.

system.cfg

B.

pg_hba.conf

C.

postgresql.conf

D.

startup.cfg

Full Access
Question # 6

Which statement is accurate regarding snippets?

A.

The number of snippets depends on query and complexity.

B.

Every query is always turned into four snippets.

C.

Every query is always turned into one snippet.

D.

The number of snippets is always based on the size of the system.

Full Access
Question # 7

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

A.

CREATE FUNCTION

B.

nzudxcompile

C.

ALTER FUNCTION

D.

ECHO

Full Access
Question # 8

What nzsqa option can be used to view workload metrics including usage summary, resource usage and short/long running jobs?

A.

nzsqa progress

B.

nzsqa wlm

C.

nzsqa responders

D.

nzsqa schedqueues -sys

Full Access
Question # 9

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

A.

65.535

B.

32.000

C.

64,000

D.

16.000

Full Access
Copyright myexamcollection.com. All Right Reserved.