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

Free and Premium IBM C1000-085 Dumps Questions Answers

Page: 1 / 2
Total 60 questions

IBM Netezza Performance Server V11.x Administrator Questions and Answers

Question 1

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

Options:

A.

online

B.

running

C.

stopped

D.

paused

Buy Now
Question 2

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

Options:

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.

Question 3

Which statement is true when executing the GROM command on a Clustered Base Table (CBT)?

Options:

A.

It reclaims space from deleted rows and does not re-order data

B.

Enough space is required for GROOM to make a complete copy of the table

C.

GROOM uses CREATE TABLE AS SELECT (CATAS) for CBT to reclaim space and re-order data.

D.

It reclaims space from deleted rows and re-orders data.

Question 4

Which two products or methods can be used for disaster recovery when using IBM Netezza Performance Servers?

Options:

A.

Cloud Pak for Data

B.

InfoSphere Data Replication

C.

Netezza Replication Services

D.

Data Serialization

E.

NPS Backup and Restore

Question 5

Which three scripts are included in the IBM Netezza Performance Server Software Support Tools?

Options:

A.

nzsql

B.

nz_ddl

C.

nzsqa

D.

nz_stats

E.

nzbackup

F.

nz tables

Question 6

Which statement is correct about command nz_responders?

Options:

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

Question 7

When is a PRIMARY KEY (PK) table constraint evaluated during an INSERT statement into the table?

Options:

A.

The PK constraint is never checked when a row is inserted into the table.

B.

After the row is inserted into the table.

C.

Before the row is inserted into the table.

D.

The PK constraint is only checked during a GENERATE STATISTICS operation.

Question 8

Which system view stores the information on how many resources have been allocated for the resource group versus how many were allowed?

Options:

A.

_v_sched_gra

B.

_v_system_util

C.

_v_qryhist

D.

_v_plan_resource

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

Page: 1 / 2
Total 60 questions