IBM IBM Certified System Administrator A2090-619 Questions & Answers

• Question 41:

  Which two actions can you perform with ontape? (Choose two.)

  A. Backup to cloud

  B. Restartable restore

  C. Backup specific storage spaces

  D. Restore specific storage spaces

  E. Parallel backup of storage spaces

  Correct Answer: AD

• Question 42:

  Which configuration parameter can toggle the automatic expansion of storage spaces?

  A. SP_AUTOGROW

  B. SP_AUTO_SPACE

  C. SP_AUTOEXPAND

  D. SP_EXPAND_ENABLE

  Correct Answer: C

• Question 43:

  Which threshold setting applies when configuring automatic memory management?

  A. SHMTOTAL

  B. BUFFERPOOL

  C. SHMVIRTSIZE

  D. DS_TOTAL_MEMORY

  Correct Answer: A

• Question 44:

  Which SQL statement is valid to monitor database server sessions?

  A. EXECUTE FUNCTION task ("onstat","-g ses");

  B. EXECUTE FUNCTION task ("view sessions","all");

  C. EXECUTE FUNCTION task ("check sessions","all");

  D. EXECUTE FUNCTION task ("check server","sessions");

  Correct Answer: A

• Question 45:

  Which option provides the greatest performance benefit in an Informix warehouse environment?

  A. Setting lower value of PDQPRIORITY.

  B. Increasing the number of B-Tree cleaners.

  C. Setting higher value of DS_TOTAL_MEMORY.

  D. Setting value of OPT_GOAL configuration variable to 0.

  Correct Answer: C

• Question 46:

  Which step must be performed to enable Secure Socket Layer (SSL) connections to Informix?

  A. Configure encrypt virtual processors in the ONCONFIG file.

  B. Configure poll threads for SSL connections in the ONCONFIG file.

  C. Specify the SSL connection protocol in the sqlhosts file or registry entry.

  D. Specify the name of the label of the server digital certificate in the ONCONFIG file.

  Correct Answer: C

• Question 47:

  Which two parameters must be set to a valid value before starting a Shared Disk (SD) Secondary server? (Choose two.)

  A. SDS_PAGING

  B. SDS_TIMEOUT

  C. SDS_TEMPDBS

  D. SDS_LOGCHECK

  E. SDS_ALTERNATE

  Correct Answer: AC

• Question 48:

  What is the purpose of the ifx_getMartStat() function?

  A. To display status information about the data mart.

  B. To display update statistics information about the data mart and its tables.

  C. To display statistics about the workers and coordinators defined for the accelerator.

  D. To display status information about the Informix Warehouse Accelerator and all the data marts.

  Correct Answer: A

• Question 49:

  The DBA has defined the following configuration parameters in the onconfig file:

  

  What are the actual values for LMM START THRESHOLD and LMM STOP THRESHOLD computed internally by the database server?

  A. LMM START THRESHOLD = 2MB and LMM STOP THRESHOLD = 3MB

  B. LMM START THRESHOLD = 20MB and LMM STOP THRESHOLD = 30MB

  C. LMM START THRESHOLD = 500MB and LMM STOP THRESHOLD = 333MB

  D. LMM START THRESHOLD = 2% and LMM STOP THRESHOLD = 3% of physical memory in the system

  Correct Answer: B

• Question 50:

  The 'onstat -k' output is showing '56 lock table overflows'. Which catalog table can be used to display the relevant lock statistics?

  A. syslocks

  B. systables

  C. sysprofile

  D. sysoverflow

  Correct Answer: C