C1000-085 Online Practice Questions and Answers

What is the maximum length of a CHAR/VARCHAR column?

A. 65.535

B. 32.000

C. 64,000

D. 16.000

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

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

A. nz_plan querytext

B. EXPLAIN PLAN FILE querytext

C. EXPLAIN PLANGRAPH querytext

D. EXPLAIN querytext

E. nzsql -t querytext -0 planfile.pln

Which statement regarding drive failure is true?

A. Queries and transactions are not interrupted by drive failure if their data is not on the failed drive.

B. Queries and transactions are not interrupted in the event of a drive failure.

C. Queries and transactions are interrupted by drive failure because there is no drive mirroring for drives.

D. Running queries and transactions will finish, but new transactions will not be allowed till drive is changed.

Which two cross-database SQL operations are allowed?

A. DELETE

B. ALTER VIEW

C. ALTER TABLE

D. CREAE TABLE

E. REVOKE

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

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

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

C. The userspace must be provided

D. The table structure (DDL) needs to exist

What nzsqa option can be used to view workload metrics including usage summary, resource usage and short/long running jobs?

A. nzsqa progress

B. nzsqa wlm

C. nzsqa responders

D. nzsqa schedqueues -sys

Which two external methods can IBM Netezza Performance Server use to authenticate database users?

A. LDAP

B. SSH

C. Radius

D. PKI-Based

E. Kerberos

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

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

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

C. New event rules can only be added in the host container.

D. New event rules must be added using the npsaddevent command.

Which two file formats are valid for external tables?

A. text-delimited

B. fixed-length

C. JSON

D. HL7

E. XML