IBM C1000-085 Exam Practice Test Instant Access

Question 1

How can a user update statistics on a table?

Aby running UPDATE STATISTICS

Bby running a query against the table

Cby running GENERATE STATISTICS

Dby restarting the database

Answer : A

Question 2

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 3

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

Anot Nullable constraint

Bcolumns used for filters

Cdistinct values

Dcolumns used for joins

Etable constraints

Answer : A, B

Question 4

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 5

IBM Netezza Performance Server drivers for the Go Language can be obtained from which location?

AIBM Public GitHub Repository

BRed Hat Marketplace

Cdownload.google.com

DDocker Hub

Answer : D

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 is the duration of SQB by default?

A3 seconds

B6 seconds

C2 seconds

D10 seconds

Answer : C

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