IBM IBM Certifications C2090-619 Questions & Answers

• Question 91:

  For a query to be processed by the accelerator, the query or query block should meet the certain criteria. Which statement is FALSE?

  A. The query or query block must include at least 2 fact tables.

  B. The query or query block must refer to a subset of the tables in the AQT.

  C. The scalar and aggregate functions in the query or query block must be supported by the Informix Warehouse Accelerator.

  D. The table references or joins specified in the query or query block must be the same as the references in the data mart definition.

  Correct Answer: A

• Question 92:

  Which one keyword in this query makes the AVG an OLAP window expression instead of the regular aggregate operator? SELECT AVG(SUM(dollars)) OVER() FROM sales;

  A. SUM

  B. OVER

  C. FROM

  D. AVG(SUM(dollars))

  Correct Answer: B

• Question 93:

  What kinds of Table Level Restores can be done by the archecker utility?

  A. Only logical restore.

  B. Only physical restore.

  C. Only point in time restore.

  D. Physical, logical, and point in time restores.

  Correct Answer: D

• Question 94:

  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 95:

  Which is NOT a feature of onbar backups?

  A. The ability to parallelize backups.

  B. The ability to do a point-in-time restore.

  C. The ability to backup without a storage manager.

  D. The ability to do an external backup using a Storage Area Network.

  Correct Answer: C

• Question 96:

  Which statement is true about restartable restore?

  A. ontape can perform restartable restores if a backup is taken to disk.

  B. Restartable restore is the ability to restart a failed restore using onbar.

  C. Restartable restore is the ability to restart a failed restore using ontape.

  D. Restartable restore is the ability to restart an instance using a restore from some other computer.

  Correct Answer: B

• Question 97:

  Which action can be taken if an instance is down?

  A. A point-in-time mixed restore.

  B. Warm restore of non-critical storage spaces.

  C. Cold restore by onbar using storage space backups taken by ontape on tape devices.

  D. A mixed restore using onbar whole system backup and incremental dbspace level backups.

  Correct Answer: A

• Question 98:

  Which type of device does Primary Storage Manager support?

  A. File

  B. Tape

  C. Directory

  D. Named pipe

  Correct Answer: A

• Question 99:

  After executing the following commands: onmode -j -U karin,dave onmode -j -U karin,sarah onmode -j -U sarah which user(s) have access to the instance?

  A. sarah

  B. karin and dave

  C. karin and sarah

  D. karin, dave and sarah

  Correct Answer: A

• Question 100:

  Which approach is always valid when migrating data across differing hardware and operating system architectures?

  A. dbexport source system then dbimport into target.

  B. ontape backup from source then restore backup onto target.

  C. onunload the source to tape and onload the tape to the target.

  D. Set up HDR primary and secondary between source and target.

  Correct Answer: A