C1000-085 Exam Training Practice Tests (IBM Netezza Performance Server V11.x Administrator)]

Question 1

Which statement regarding drive failure is true?

A. Running queries and transactions will finish, but new transactions will not be allowed till drive is changed. B. Queries and transactions are interrupted by drive failure because there is no drive mirroring for drives. C. Queries and transactions are not interrupted by drive failure if their data is not on the failed drive. D. Queries and transactions are not interrupted in the event of a drive failure.

Correct Answer: C

Question 2

What is the duration of SQB by default?

A. 3 seconds B. 10 seconds C. 2 seconds D. 6 seconds

Correct Answer: C

Question 3

To how many resource groups can a user be assigned?

A. four B. three C. one D. unlimited

Correct Answer: B

Question 4

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

A. The PK constraint is never checked when a row is inserted into the table. B. Before the row is inserted into the table. C. After the row is inserted into the table. D. The PK constraint is only checked during a GENERATE STATISTICS operation.

Correct Answer: B

Question 5

What is the purpose of the nzload control file?

A. To define load operations in a text file instead of having to specify options on the command line B. To ensure that a simple load that uses external tables continues after the system is paused and resumed. C. To control the re-load operations of me data file after every load failure D. To take advantage of a named pipe capability to stream the data to external tables faster.

Correct Answer: A

Question 6

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

A. download.google.com B. IBM Public GitHub Repository C. Red Hat Marketplace D. Docker Hub

Correct Answer: D

Question 7

Which two command line support tools are used to determine the order of data for a given table?

A. nz_physical_table_layout B. nz_get C. nz_pagemap D. nz_sort_order E. nz_zonemap

Correct Answer: C,E

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