IBM C1000-085 Exam Questions Instant Access

Question 1

What is a purpose of the command nzsystem?

Ato show and change the system state

Bto show and change nzroot use

Cto show and change system users

Dto show and change system access

Answer : A

https://www.ibm.com/support/knowledgecenter/SSULQD_7.2.1/com.ibm.nz.adm.doc/r_sysadm_nzsystem_cmd.html

Question 2

When restoring a database using nzrestore utility, which is true for the npshost option?

AIt is the hostname of the storage server

BIt is a HOSTNAME value set in backupHostname.txt file on the backup source system.

CIt is a host name of the target system to restore a database to.

DIt is a remote host name or IP address of the system to connect to.

Answer : C

Question 3

What is required in order to restore a specific table using the nz_restore support tool?

AA table needs to be backed up by using nzbackup utility.

BA table that is being restored must have the same name in the backup set.

CThe userspace must be provided

DThe table structure (DDL) needs to exist

Answer : A

Question 4

Which two file formats are valid for external tables?

Atext-delimited

Bfixed-length

CJSON

DHL7

EXML

Answer : A, C

Question 5

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 6

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

Aonline

Brunning

Cstopped

Dpaused

Answer : C

Question 7

Which is a valid statement regarding event rules on the IBM Netezza Performance Server (NPS) Console?

ANew event rules can be added using the queries panel in NPS Console.

BNew event rules can be added using the event rules panel in NPS Console.

CNew event rules can only be added in the host container.

DNew event rules must be added using the npsaddevent command.

Answer : D

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