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.

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

A. It is the hostname of the storage server

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

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

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

Which log file provides a DBA with an actual SQL statement that was executed?

A. clientmgr.log

B. pg.log

C. sysmgr.log

D. dbos.log

Which statement is accurate regarding snippets?

A. The number of snippets depends on query and complexity.

B. Every query is always turned into four snippets.

C. Every query is always turned into one snippet.

D. The number of snippets is always based on the size of the system.

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 are two primary purposes of UDX?

A. it is a required component of all Netezza SQL commands

B. to force execution only on the SPU nodes

C. to offer new and unique types of analyses through customized code

D. to showcase one's capability to write UDX code to duplicate existing SQL functions

E. to accelerate analysis by processing data in-database

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

A. not Nullable constraint

B. columns used for filters

C. distinct values

D. columns used for joins

E. table constraints

To how many resource groups can a user be assigned?

A. four

B. unlimited

C. three

D. one

Which partition on the SPU node us used to store transient working data that is generated during query execution?

A. Primary

B. Nzscratch

C. Mirror

D. nzlocal