IBM C1000-085 Exam Practice Test Instant Access

Question 1

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 2

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 3

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 4

What is a valid selection from the home page of the IBM Netezza Performance Server web console?

Acreate IBM Object Storage

Bquery performance

Ccreate new service

Dmonitor snippets

Answer : A

Question 5

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 6

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

Anz_physical_table_layout

Bnz_zonemap

Cnz_pagemap

Dnz_sort_order

Enz_get

Answer : B, C

Question 7

To how many resource groups can a user be assigned?

Afour

Bunlimited

Cthree

Done

Answer : C

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