You need to create a new role for users on stores database. Which system catalog table can be checked to ensure the uniqueness of the new role name?
A. stores:sysusers
B. sysmaster:sysroles
C. sysuser:sysroleauth
D. sysmaster:sysusers
Which type of device does Primary Storage Manager support?
A. File
B. Tape
C. Directory
D. Named pipe
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.
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.
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
Which objects can be compressed?
A. CLOBs
B. smart BLOBs
C. partition BLOBs
D. blobspace BLOBs
Which parameter is used to enable transactions to complete after failover of the primary server?
A. HA_FOC_ORDER
B. FAILOVER_CALLBACK
C. CLUSTER_TXN_SCOPE
D. FAILOVER_TX_TIMEOUT
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.
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.
Which Informix utility can be used to customize the onconfig file?
A. ifxdeploy
B. genoncfg
C. dbaccess
D. onparams
