IBM C1000-085 Exam Practice Test Instant Access

Question 1

When choosing a distribution key for a large fact table, what is a valid choice?

Aany column used in table constraints

Bany column with low cardinality

Ca technical or surrogate key

Dany date column commonly used in queries

Answer : A

Question 2

Which two commands are used to list all hardware and software components on Cloud Pak for Data System?

Aap hw

Bnzsw

Cnzhv

Dap sw

Eoc pod -h -s

Answer : A, D

Question 3

Which statement regarding drive failure is true?

AQueries and transactions are not interrupted by drive failure if their data is not on the failed drive.

BQueries and transactions are not interrupted in the event of a drive failure.

CQueries and transactions are interrupted by drive failure because there is no drive mirroring for drives.

DRunning queries and transactions will finish, but new transactions will not be allowed till drive is changed.

Answer : A

Question 4

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

Astopped

Bpaused

Cdiscovering

Ddown

Answer : B

Question 5

When integrating IBM Spectrum Protect into IBM Netezza Performance Server (NPS) for backup and restore, how must the NPS host be defined?

Aas a client of the storage manager server

Bas the primary storage manager server

Cas the primary backup target

Das a cloud storage repository

Answer : A

Question 6

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

ACloud Pak for Data

BInfoSphere Data Replication

CNetezza Replication Services

DData Serialization

ENPS Backup and Restore

Answer : B, E

Question 7

What are Clustered Base Tables (CBT)?

ATables that decrease allocated storage

BTables that contain sorted data using one to four columns.

CTables that increase pre-sorting of new table records before a loading operation.

DTables that replicate the base table.

Answer : B

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