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

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

• New event rules can be added using the queries panel in NPS Console.
• New event rules can be added using the event rules panel in NPS Console.
• New event rules can only be added in the host container.
• New event rules must be added using the npsaddevent command.

To how many resource groups can a user be assigned?

• four
• unlimited
• three
• one

Which statement is correct about command nz_responders?

• displays user activity in tabular format
• displays information from nzsql responders -all in a more user-friendly format
• displays information from nzsqa responders -sys in a more user-friendly format
• displays resource utilization statistics in JSON format

Which two commands will show a query plan without running the query?

• nz_plan querytext
• EXPLAIN PLAN FILE querytext
• EXPLAIN PLANGRAPH querytext
• EXPLAIN querytext
• nzsql -t querytext -0 planfile.pln

What is the duration of SQB by default?

• 3 seconds
• 6 seconds
• 2 seconds
• 10 seconds

What is the name of the IBM Netezza Performance Server Replication node at the target nodes when using Netezza Replication Services?

• SUBORDINATE NODE
• MASTER NODE
• STANDBY NODE
• PRIMARY NODE

Which level of transaction isolation does IBM Netezza Performance Server implement?

• uncommitted read
• serializable
• repeatable read
• committed read

When computing the row size for a table row, what overhead should be accounted for?

• 48 bytes for ROWID, CREATEXID and DELETEXID only
• 32 bytes for ROWID. CREATEXID, DELETEXID and the null vector
• 32 bytes for ROWID. CREATEXID and DELETEXID and a variable number of bytes for the null vector if there are nullable columns
• 24 bytes for ROWID. CREATEXID and DELETEXID plus null vector if there are nullable columns and record header depending on string columns

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

• nzsql -c 'show planfile '
• nzsql -c 'select plan_text from _v_plan'
• nzsql -c 'get planfile '
• nz_get
• nz_plan

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

• _v_sched_gra
• _v_system_util
• _v_qryhist
• _v_plan_resource