Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exc65

examout.co

How does IBM Netezza Performance Server store data?

A.

Tables are distributed across all data slices compressed

B.

Tables are distributed to a single data slice compressed.

C.

Tables are distributed across all data slices uncompressed.

D.

Tables are distributed across a subset of data slices uncompressed.

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 CURRENT SCHEMA TO NEW_SCHEMA

C.

SET SCHEMA NEW_SCHEMA

D.

ALTER DATABASE database name SET DEFAULT SCHEMA NEW SCHEMA

What command is used to verify the release of IBM Netezza Performance Server Analytics installed?

A.

nzcm —inza

B.

nzrev --inza

C.

nzinza

D.

inzarev

Which level of transaction isolation does IBM Netezza Performance Server implement?

A.

uncommitted read

B.

serializable

C.

repeatable read

D.

committed read

What is the purpose of the nzstate command?

A.

restore the database to the last backup

B.

list the state of the system

C.

list the states of backups available

D.

list the state of a running query

Which statement is correct about command nz_responders?

A.

displays user activity in tabular format

B.

displays information from nzsql responders -all in a more user-friendly format

C.

displays information from nzsqa responders -sys in a more user-friendly format

D.

displays resource utilization statistics in JSON format

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

A.

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

B.

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

C.

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

D.

New event rules must be added using the npsaddevent command.

What should be the state of the IBM Netezza Performance Server system in order to run the nz_manual_vacuum command?

A.

online

B.

running

C.

stopped

D.

paused

Which two commands will show a query plan without running the query?

A.

nz_plan querytext

B.

EXPLAIN PLAN FILE querytext

C.

EXPLAIN PLANGRAPH querytext

D.

EXPLAIN querytext

E.

nzsql -t querytext -0 planfile.pln

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

A.

stopped

B.

paused

C.

discovering

D.

down