What access is required to create a new user in IBM Netezza Performance Server?
- A . An account with NEW USER administrative privilege
- B . An account with CREATE USER administrative privilege.
- C . An account with CREATE GROUP access on the host OS.
- D . An account with CREATE ID access on the host OS.
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.
Which two command line support tools are used to determine the order of data for a given table?
- A . nz_physical_table_layout
- B . nz_zonemap
- C . nz_pagemap
- D . nz_sort_order
- E . nz_get
What are Clustered Base Tables (CBT)?
- A . Tables that decrease allocated storage
- B . 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.
DRAG DROP
What is the order of the operations of a typical snippet in a query plan?
To enable or disable multiple schema support on the IBM Netezza Performance Server, which configuration file needs to be updated?
- A . system.cfg
- B . pg_hba.conf
- C . postgresql.conf
- D . startup.cfg
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.
When restoring a database using nzrestore utility, which is true for the npshost option?
- A . It is the hostname of the storage server
- B . It is a HOSTNAME value set in backupHostname.txt file on the backup source system.
- C . It is a host name of the target system to restore a database to.
- D . It is a remote host name or IP address of the system to connect to.
Which log file provides a DBA with an actual SQL statement that was executed?
- A . clientmgr.log
- B . pg.log
- C . sysmgr.log
- D . dbos.log
Which statement is accurate regarding snippets?
- A . The number of snippets depends on query and complexity.
- B . Every query is always turned into four snippets.
- C . Every query is always turned into one snippet.
- D . The number of snippets is always based on the size of the system.
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>
When integrating IBM Spectrum Protect into IBM Netezza Performance Server (NPS) for backup and restore, how must the NPS host be defined?
- A . as a client of the storage manager server
- B . as the primary storage manager server
- C . as the primary backup target
- D . as a cloud storage repository
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.
When computing the row size for a table row, what overhead should be accounted for?
- A . 48 bytes for ROWID, CREATEXID and DELETEXID only
- B . 32 bytes for ROWID. CREATEXID, DELETEXID and the null vector
- C . 32 bytes for ROWID. CREATEXID and DELETEXID and a variable number of bytes for the null vector if there are nullable columns
- D . 24 bytes for ROWID. CREATEXID and DELETEXID plus null vector if there are nullable columns and record header depending on string columns
What is the maximum length of a CHAR/VARCHAR column?
- A . 65.535
- B . 32.000
- C . 64,000
- D . 16.000
Which date time format is used to capture history activities?
- A . system time
- B . local time
- C . EST
- D . GMT
What ap cli command is used to disable a node?
- A . ap node power off
- B . ap node set__personality fail
- C . ap stopnode
- D . ap node disable
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
What should be the state of the IBM Netezza Performance Server system in order to run the nz_manual_vacuum command?
- A . online
- B . running
- C . stopped
- D . paused
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