What is the purpose of the nzload control file?

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

Comment: *

Name: *

Email: *

Verification: *

Which partition on the SPU node us used to store transient working data that is generated during query execution?

• A.nzlocal
• B.Mirror
• C.Primary
• D.Nzscratch

Comment: *

Name: *

Email: *

Verification: *

What is required in order to restore a specific table using the nz_restore support tool?

• A.The table structure (DDL) needs to exist
• B.A table needs to be backed up by using nzbackup utility.
• C.The userspace must be provided
• D.A table that is being restored must have the same name in the backup set.

Comment: *

Name: *

Email: *

Verification: *

Which two commands are used to list all hardware and software components on Cloud Pak for Data System?

• A.ap hw
• B.oc pod -h -s
• C.nzhv
• D.ap sw
• E.nzsw

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *