Assessment: Informix Server 12.10 Assessment (A2090-619) Free Practice Test

Question 1

The sector option for cdr utility is used to perform what operation?

A. Dynamically reconfigure Connection Manager SLAs for H/A clusters in order to perform rolling upgrades.

B. Dynamically reconfigure Connection Manager SLAs for ER clusters in order to perform rolling upgrades.

C. Dynamically convert H/A cluster instances in order to perform rolling upgrades.

D. Dynamically convert ER cluster instances in order to perform rolling upgrades.

Correct Answer: C

Question 2

Where are the Primary Storage Manager catalog tables stored?

A. sysmaster database

B. sysutils database

C. sysadmin database

D. A location as specified by the PSM_CATALOG_PATH configuration parameter

Correct Answer: D

Question 3

Assuming network connectivity between two Informix instances, which file may need additional configuration to allow distributed queries?

A. /etc/hosts.equiv

B. $ONCONFIG

C. /etc/services

D. sqlhosts

Correct Answer: A

Question 4

"informix_stores" is an established primary server with a SDS server. What is the effect of running the following command? EXECUTE FUNCTION sysadmin:admin("ha sds clear",
"informix_stores");

A. Converts the shared disk secondary server to a standard server and shuts down the primary server.

B. Clears the log position of the SDS servers and restarts replication.

C. Shuts down the primary server and converts the secondary server to be the primary.

D. Stops replication to the shared disk secondary servers and converts the primary server to a standard server.

Correct Answer: D

Question 5

The IBM Mobile Database is a mobile-optimized version of which IBM product?

A. IBM solidDB

B. IBM Cloudscape

C. IBM Informix

D. IBM DB2

Correct Answer: A

Question 6

What data migration tool(s) should be used to load data from a non-Informix data source?

A. onload and High Performance Loader

B. onload and dbload

C. dbload and High Performance Loader

D. dbimport

Correct Answer: C

Welcome to TestSimulate

IBM Assessment: Informix Server 12.10 Assessment (A2090-619) Free Practice Test