C1000-085 Online Practice Questions and Answers

What are Clustered Base Tables (CBT)?

A. Tables that decrease allocated storage

B. Tables that contain sorted data using one to four columns.

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

D. Tables that replicate the base table.

Which two commands can be used to get a plan file for a query?

A. nzsql -c "show planfile "

B. nzsql -c "select plan_text from _v_plan"

C. nzsql -c "get planfile "

D. nz_get

E. nz_plan

Which system view stores the information on how many resources have been allocated for the resource group versus how many were allowed?

A. _v_sched_gra

B. _v_system_util

C. _v_qryhist

D. _v_plan_resource

What is the purpose of the nzstate command?

A. restore the database to the last backup

B. list the state of the system

C. list the states of backups available

D. list the state of a running query

Which is the most efficient data type for distribution keys?

A. integers

B. internal datatypes (ROWID etc.)

C. temporal types

D. strings

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

A. stopped

B. paused

C. discovering

D. down

Which three scripts are included in the IBM Netezza Performance Server Software Support Tools?

A. nzsql

B. nz_ddl

C. nzsqa

D. nz_stats

E. nzbackup

F. nz tables

Which two scenarios can be addressed using the nz_check_disk_scan_speeds command?

A. check system status

B. get skew information distributed across disks

C. see disk read and write speeds

D. slow performing SPU or drive

E. get disk storage utilization details

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 take advantage of a named pipe capability to stream the data to external tables faster.

D. To control the re-load operations of me data file after every load failure

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

A. create IBM Object Storage

B. query performance

C. create new service

D. monitor snippets