A2090-619 Online Practice Questions and Answers

Which type of device does Primary Storage Manager support?

A. File

B. Tape

C. Directory

D. Named pipe

Which statement about DataBlade modules is true?

A. All DataBlades located in the $INFORMIXDIR/extend are automatically registered.

B. All built-in extensions are automatically registered when the extension is first accessed.

C. All built-in extensions are automatically registered each time the database sever is started.

D. All built-in extensions are automatically registered when the database server is first initialized.

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.

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

A. Shrink

B. Repack

C. Compress

D. Defragment

Which fragmentation strategy is capable of generating new fragments automatically?

A. Fragment by List

B. Fragment by Range

C. Fragment By Expression

D. Fragment by Round Robin

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.

Which statement is true about log salvaging?

A. ontape cannot perform salvage of logs.

B. Log salvaging cannot be avoided if onbar is used for restore.

C. Log salvaging is the act of restoring logical logs after physical restore, but before logical restore.

D. Log salvaging allows for recovery of data up to the last available and uncorrupted logical-log file and the last complete transaction.

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.

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

Which two statements are true about Enterprise Replication of TimeSeries data types? (Choose two.)

A. ATS and RIS files must be in XML format.

B. The replicate must be a mastered replicate.

C. The conflict resolution rule must be always-apply.

D. The WHERE clause in the participant definition must include a TimeSeries column.

E. CDR_TSINSTANCEID configuration parameter must be set to the same value for every replication server.