A2090-919 Exam Training Practice Tests (IBM Assessment: System Administrator for Informix Server 11.70)]

Question 1

What ONCONFIG parameter can be tuned to increase memory for hash joins?

A. RESIDENT B. DS_NONPDQ_QUERY_MEM C. VP_MEMORY_CACHE_KB D. EXTSHMADD

Correct Answer: B

Question 2

Which of the following is NOT a step in setting up HDR for the first time?

A. Use onmode -d to specify the secondary instance name. B. Take a level 0 backup of the primary. C. Use oninit -v to bring up the secondary. D. Execute a physical restore on the secondary.

Correct Answer: C

Question 3

How is the DBSSO group determined on a Unix system with role separation?

A. It is the group specified in the DBSSO onconfig parameter. B. It is the group that owns $INFORMIXDIR/dbssodir. C. It is always the group informix. D. It is set using the onsecurity command line tool.

Correct Answer: B

Question 4

Which statement about Informix data compression is NOT true?

A. It can compress, repack and shrink a table in one command. B. There is no Admin API (sysadmin) interface to automatically compress tables. C. The compress, repack, repack_offline, uncompress, and uncompress_offline operations can consume large amounts of logs. D. The 'onstat -g dsk' command can be used to find the progress of currently running compression operations.

Correct Answer: B

Question 5

Which two onconfig parameters can be set to backup/restore to/from a cloud storage location? (Choose two.)

A. BAR_BSALIB_PATH B. TAPEDEV C. TAPEBLK D. LTAPEDEV E. LTAPEBLK

Correct Answer: B,D

Question 6

Consider the following selective row-level auditing example:

How many entries will be added to the audit file?

A. 8 B. 5 C. 0 D. 3

Correct Answer: B

IBM Assessment: System Administrator for Informix Server 11.70 - A2090-919 Exam Practice Test