IBM c1000-085 practice test

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 state does the nzstate command show when the IBM Netezza Performance Server system fails
to initialize?

• A. stopped
• B. paused
• C. discovering
• D. down

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 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 is the most efficient data type for distribution keys?

• A. integers
• B. internal datatypes (ROWID etc.)
• C. temporal types
• D. strings

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

Which level of transaction isolation does IBM Netezza Performance Server implement?

• A. uncommitted read
• B. serializable
• C. repeatable read
• D. committed read

What command is used to add an event?

• A. nzevent add
• B. nzevent insert
• C. nzevent load
• D. nzevent create

What is the purpose of the nzload control file?

• A. To define load operations in a text file instead of having to specify options on the command line
• B. To ensure that a simple load that uses external tables continues after the system is paused and resumed.
• C. To take advantage of a named pipe capability to stream the data to external tables faster.
• D. To control the re-load operations of me data file after every load failure

To how many resource groups can a user be assigned?

• A. four
• B. unlimited
• C. three
• D. one