IBM c1000-085 practice test

IBM Netezza Performance Server V11.x Administrator Exam


Question 1

When is a PRIMARY KEY (PK) table constraint evaluated during an INSERT statement into the table?

  • A. The PK constraint is never checked when a row is inserted into the table.
  • B. After the row is inserted into the table.
  • C. Before the row is inserted into the table.
  • D. The PK constraint is only checked during a GENERATE STATISTICS operation.
Answer:

C

Discussions

Question 2

Which two file formats are valid for external tables?

  • A. text-delimited
  • B. fixed-length
  • C. JSON
  • D. HL7
  • E. XML
Answer:

AC

Discussions

Question 3

Which date time format is used to capture history activities?

  • A. system time
  • B. local time
  • C. EST
  • D. GMT
Answer:

A

Discussions

Question 4

The nzhostbackup command backs up which directory by default?

  • A. /nz/data/
  • B. /nzscratch/
  • C. /ex port/ho me/nz
  • D. /nz/kit/
Answer:

D

Discussions

Question 5

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 table with zip_code as integer data type.
  • B. alter table fact_sales to organize on zip_code. followed by groom.
  • C. CREATE ORGANIZED view for FACT_SALES table
  • D. Create a view with a typecast to integer and use view for query purposes
Answer:

C

Discussions

Question 6

In IBM Netezza Performance Server, what storage file system is shared across the host containers?

  • A. IBM Spectrum Scale or General Parallel File System (GPFS)
  • B. NT File System (NTFS)
  • C. Glusterfs
  • D. 2 File System (ZFS)
Answer:

B

Discussions

Question 7

Which statement is correct about command nz_responders?

  • A. displays user activity in tabular format
  • B. displays information from nzsql responders -all in a more user-friendly format
  • C. displays information from nzsqa responders -sys in a more user-friendly format
  • D. displays resource utilization statistics in JSON format
Answer:

B

Discussions

Question 8

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.
Answer:

D

Discussions

Question 9

What happens to NFS mounts after a container failover?

  • A. NFS is handled by Red Hat OpenShift and does not need to be mounted.
  • B. Sysmgr will remount it as part of the IBM Netezza Performance Server environment
  • C. A containers do not allow for NFS mounts.
  • D. It will be automatically mounted by the ipsnfs service.
Answer:

A

Discussions

Question 10

How does IBM Netezza Performance Server store data?

  • A. Tables are distributed across all data slices compressed
  • B. Tables are distributed to a single data slice compressed.
  • C. Tables are distributed across all data slices uncompressed.
  • D. Tables are distributed across a subset of data slices uncompressed.
Answer:

A

Discussions
To page 2