IBM Netezza Performance Server V11.x Administrator (C1000-085) Free Practice Test

Question 1

To how many resource groups can a user be assigned?

A. four

B. three

C. one

D. unlimited

Correct Answer: B

Question 2

How can a user update statistics on a table?

A. by running UPDATE STATISTICS

B. by running a query against the table

C. by running GENERATE STATISTICS

D. by restarting the database

Correct Answer: A

Question 3

Which is the most efficient data type for distribution keys?

A. internal datatypes (ROWID etc.)

B. integers

C. temporal types

D. strings

Correct Answer: D

Question 4

What are two primary purposes of UDX?

A. to force execution only on the SPU nodes

B. it is a required component of all Netezza SQL commands

C. to accelerate analysis by processing data in-database

D. to offer new and unique types of analyses through customized code

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

Correct Answer: C,E

Question 5

Which two cross-database SQL operations are allowed?

A. ALTER VIEW

B. DELETE

C. REVOKE

D. CREAE TABLE

E. ALTER TABLE

Correct Answer: D,E

Question 6

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

A. ALTER FUNCTION

B. nzudxcompile

C. CREATE FUNCTION

D. ECHO

Correct Answer: C

Question 7

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

A. An account with CREATE USER administrative privilege.

B. An account with CREATE GROUP access on the host OS.

C. An account with NEW USER administrative privilege

D. An account with CREATE ID access on the host OS.

Correct Answer: C

Welcome to TestSimulate

IBM Netezza Performance Server V11.x Administrator (C1000-085) Free Practice Test