C1000-085 exam

What are Clustered Base Tables (CBT)?A . Tables that decrease allocated storageB . 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.View AnswerAnswer: B

Which date time format is used to capture history activities?A . system timeB . local timeC . ESTD . GMTView AnswerAnswer: A

What ap cli command is used to disable a node?A . ap node power offB . ap node set__personality failC . ap stopnodeD . ap node disableView AnswerAnswer: D

Consider a scenario where a customer has a FACT_SALES table with a column zip_code with data type char (5| They frequently restrict on this column, but the query is very inefficient. What is the correct way to optimize this query without modifying the column?A . Create a copy of FACT_SALES...

What should be the state of the IBM Netezza Performance Server system in order to run the nz_manual_vacuum command?A . onlineB . runningC . stoppedD . pausedView AnswerAnswer: C

Which two commands can be used to get a plan file for a query?A . nzsql -c "show planfile <planid>"B . nzsql -c "select plan_text from _v_plan"C . nzsql -c "get planfile <planid>"D . nz_get <planid>E . nz_plan <planid>View AnswerAnswer: A,D

When computing the row size for a table row, what overhead should be accounted for?A . 48 bytes for ROWID, CREATEXID and DELETEXID onlyB . 32 bytes for ROWIC . CREATEXID, DELETEXID and the null vectorD . 32 bytes for ROWIE . CREATEXID and DELETEXID and a variable number of...

Which log file provides a DBA with an actual SQL statement that was executed?A . clientmgr.logB . pg.logC . sysmgr.logD . dbos.logView AnswerAnswer: C

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_graB . _v_system_utilC . _v_qryhistD . _v_plan_resourceView AnswerAnswer: D

What access is required to create a new user in IBM Netezza Performance Server?A . An account with NEW USER administrative privilegeB . An account with CREATE USER administrative privilege.C . An account with CREATE GROUP access on the host OE . An account with CREATE ID access on the...