C1000-085試験無料問題集（62題）「IBM Netezza Performance Server V11.x Administrator 認定」

出題：1

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

A. ALTER FUNCTION

B. ECHO

C. CREATE FUNCTION

D. nzudxcompile

正解：C 解答を投票する

出題：2

What are two important factors to consider when selecting a distribution key?

A. table constraints

B. columns used for filters

C. columns used for joins

D. distinct values

E. not Nullable constraint

正解：B,E 解答を投票する

出題：3

Which partition on the SPU node us used to store transient working data that is generated during query execution?

A. Primary

B. Mirror

C. Nzscratch

D. nzlocal

正解：A 解答を投票する

出題：4

What are two primary purposes of UDX?

A. to accelerate analysis by processing data in-database

B. to force execution only on the SPU nodes

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

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

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

正解：A,D 解答を投票する

出題：5

Which two cross-database SQL operations are allowed?

A. REVOKE

B. ALTER TABLE

C. ALTER VIEW

D. CREAE TABLE

E. DELETE

正解：B,D 解答を投票する

出題：6

Within a database session, which syntax allows a user to change to a different schema (NEW_SCHEMA)?

A. ALTER SESSION SET SCHEMA=NEW_SCHEMA

B. SET SCHEMA NEW_SCHEMA

C. SET CURRENT SCHEMA TO NEW_SCHEMA

D. ALTER DATABASE database name SET DEFAULT SCHEMA NEW SCHEMA

正解：B 解答を投票する

出題：7

Which is a valid statement regarding event rules on the IBM Netezza Performance Server (NPS) Console?

A. New event rules can only be added in the host container.

B. New event rules can be added using the queries panel in NPS Console.

C. New event rules must be added using the npsaddevent command.

D. New event rules can be added using the event rules panel in NPS Console.

正解：C 解答を投票する

C1000-085試験無料問題集「IBM Netezza Performance Server V11.x Administrator 認定」