C1000-085 Online Practice Questions and Answers
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.
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
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 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
Which two products or methods can be used for disaster recovery when using IBM Netezza Performance Servers?
A. Cloud Pak for Data
B. InfoSphere Data Replication
C. Netezza Replication Services
D. Data Serialization
E. NPS Backup and Restore
Which is the most efficient data type for distribution keys?
A. integers
B. internal datatypes (ROWID etc.)
C. temporal types
D. strings
What command is used to verify the release of IBM Netezza Performance Server Analytics installed?
A. nzcm --inza
B. nzrev --inza
C. nzinza
D. inzarev
What is a valid selection from the home page of the IBM Netezza Performance Server web console?
A. create IBM Object Storage
B. query performance
C. create new service
D. monitor snippets
Which two commands are used to list all hardware and software components on Cloud Pak for Data System?
A. ap hw
B. nzsw
C. nzhv
D. ap sw
E. oc pod -h -s
Which statement regarding the IBM Netezza Performance Server (NPS) admin database user is true?
A. The admin user should be deleted after installing NPS.
B. The admin user is added to the host OS before installing NPS.
C. The admin user can not be deleted after installing NPS.
D. The admin user is the only owner of a database on NPS.