Free C1000-085 Exam Braindumps
IBM Netezza Performance Server V11.x Administrator Questions 52–56 (page: 6)

What happens to NFS mounts after a container failover?

  1. NFS is handled by Red Hat OpenShift and does not need to be mounted.
  2. Sysmgr will remount it as part of the IBM Netezza Performance Server environment
  3. A containers do not allow for NFS mounts.
  4. It will be automatically mounted by the ipsnfs service.

Answer(s): A



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

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

Answer(s): D



Which statement is correct about command nz_responders?

  1. displays user activity in tabular format
  2. displays information from nzsql responders -all in a more user-friendly format
  3. displays information from nzsqa responders -sys in a more user-friendly format
  4. displays resource utilization statistics in JSON format

Answer(s): B



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

  1. IBM Spectrum Scale or General Parallel File System (GPFS)
  2. NT File System (NTFS)
  3. Glusterfs
  4. 2 File System (ZFS)

Answer(s): B



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?

  1. Create a copy of FACT_SALES table with zip_code as integer data type.
  2. alter table fact_sales to organize on zip_code. followed by groom.
  3. CREATE ORGANIZED view for FACT_SALES table
  4. Create a view with a typecast to integer and use view for query purposes

Answer(s): C



Viewing page 6 of 13
Viewing questions 26 - 30 out of 60 questions


Post your Comments and Discuss IBM C1000-085 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!