New Year Special Limited Time Flat 70% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 70spcl

Activedumpsnet Logo
  1. Home
  2. IBM
  3. IBM Certified Administrator - Netezza Performance Server V11.x
  4. C1000-085 - IBM Netezza Performance Server V11.x Administrator

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

Page: 1 / 6
Total 60 questions
Get C1000-085 Full Access Download C1000-085 PDF

IBM Netezza Performance Server V11.x Administrator Questions and Answers

Question 1

In IBM Netezza Performance Server, what storage file system is shared across the host containers?

Options:

A.

IBM Spectrum Scale or General Parallel File System (GPFS)

B.

NT File System (NTFS)

C.

Glusterfs

D.

2 File System (ZFS)

Question 2

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

Options:

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

Question 3

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

Options:

A.

nzcm —inza

B.

nzrev --inza

C.

nzinza

D.

inzarev

Question 4

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

Options:

A.

nz_plan querytext

B.

EXPLAIN PLAN FILE querytext

C.

EXPLAIN PLANGRAPH querytext

D.

EXPLAIN querytext

E.

nzsql -t querytext -0 planfile.pln

Question 5

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

Options:

A.

uncommitted read

B.

serializable

C.

repeatable read

D.

committed read

Question 6

What is the name of the IBM Netezza Performance Server Replication node at the target nodes when using Netezza Replication Services?

Options:

A.

SUBORDINATE NODE

B.

MASTER NODE

C.

STANDBY NODE

D.

PRIMARY NODE

Question 7

What two files are extracted from the SQL Extension toolkit package?

Options:

A.

libnetinza-version.tar gz

B.

libnetsqlext-version.tar.gz

C.

libnetxml-version.tar.gz

D.

libnetcrypto-version.tar.gz

E.

libnetsqlkit-version.tar.gz

Question 8

What is the purpose of the nzstate command?

Options:

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

Question 9

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

Options:

A.

not Nullable constraint

B.

columns used for filters

C.

distinct values

D.

columns used for joins

E.

table constraints

Load More C1000-085 Questions 
Page: 1 / 6
Total 60 questions
Get C1000-085 Full Access Download C1000-085 PDF