IBM IBM Certifications C2090-619 Questions & Answers

• Question 71:

  To potentially reduce table extent interleaving, an Informix administrator would execute which storage optimization operation?

  A. Shrink

  B. Repack

  C. Compress

  D. Defragment

  Correct Answer: D

• Question 72:

  The purge policy CANNOT be executed for a rolling window table utilizing which method?

  A. By calling the syspurge function.

  B. By the purge_tables task of the Scheduler.

  C. By setting up the server to automatically run the purge policy.

  D. By running ALTER FRAGMENT with the PURGE NOW predicate.

  Correct Answer: D

• Question 73:

  An Enterprise Replication server is a primary server for shared-disk secondary servers. The DBA wants to reduce the replication latency by reducing the number of transactions that are applied before the logs are flushed to disk. What configuration parameter should the DBA modify?

  A. CDR_MAX_TXNS

  B. CDR_TSINSTANCEID

  C. CDR_MAX_FLUSH_SIZE

  D. CDR_LOG_LAG_ACTION

  Correct Answer: C

• Question 74:

  Consider the following Enterprise Replication command: cdr define template temp1 -c g_serv1 -C ignore -a -d testdb. Which statement is TRUE?

  A. The command defines a template to be realized on servers serv4 and serv5.

  B. The command defines a template to exclude database testdb from replication.

  C. The command defines a template to replicate the entire database testdb by defining replicates for each of the user defined tables in testdb.

  D. The command defines a template to replicate the entire database testdb by defining replicates for each of the views and system tables in testdb.

  Correct Answer: C

• Question 75:

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

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

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

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

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

  Correct Answer: B

• Question 76:

  Which statement is valid about Data consolidation using send-only replicates?

  A. You can have more than one target server.

  B. You cannot modify a server to change its mode to send-only.

  C. You cannot use this replicate for tables that include TimeSeries columns.

  D. You need to define a different replicate for each send-only primary server.

  Correct Answer: C

• Question 77:

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

  In addition to examining the Connection Manager log file, what are two ways to monitor the Connection Manager status? (Choose two.)

  A. onstat

  B. onmode

  C. oncmsm

  D. onmonitor

  E. OpenAdmin Tool

  Correct Answer: AE

• Question 79:

  Which option is available through ifx_grid_connect()?

  A. Rename a replicated database.

  B. Enable use of TimeSeries columns in tables.

  C. Enable automatic creation of templates in a grid.

  D. Defer propagation of DDL statements to other servers in the grid.

  Correct Answer: D

• Question 80:

  Which two parameters are mandatory when running "ifxclone"? (Choose two.)

  A. Target server instance size.

  B. Target server instance name.

  C. Source server instance sqlhosts.

  D. Target server configuration parameters.

  E. Source server instance TCP/IP address.

  Correct Answer: BE