NEW QUESTION 1
Which statement accurately describes the mapped user functionality in Informix?

• A. The DBSA can control the access to the database at the table level by creating different security labels for each user.
• B. The DBSA can create different roles for each user in order to verify whether the user who is attempting an operation has the necessary privileges.
• C. The DBSA can configure the server to allow database access by external users who do not have operating system accounts on the host computer.
• D. The DBSA can grant access to the database server to users of the host computer operating system by implementing different authentication mechanisms for each user.

Answer: C

NEW QUESTION 2
Which two statements are true?

• A. Temporary dbspaces can have different page sizes.
• B. Separate temporary dbspaces are required for each buffer pool.
• C. DBSPACETEMP dbspaces can be temporary or standard dbspaces.
• D. If rootdbs is mirrored then all the temporary spaces must be mirrored.
• E. If DBSPACETEMP is not configured then temporary space will never be used.

Answer: AC

NEW QUESTION 3
Which configuration parameter can toggle the automatic expansion of storage spaces?

• A. SP_AUTOGROW
• B. SP_AUTO_SPACE
• C. SP_AUTOEXPAND
• D. SP_EXPAND_ENABLE

Answer: C

NEW QUESTION 4
Which of configuration parameter can be increased to improve the performance of flushing dirty buffer pages during checkpoints?

• A. CKPTINTVL
• B. RA_PAGES
• C. CLEANERS
• D. SHMVIRTSIZE

Answer: C

NEW QUESTION 5
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

Answer: A

NEW QUESTION 6
Which two technologies use the ENCRYPT_MAC configuration parameter to control the level of message authentication code (MAC) generation? (Choose two.)

• A. On-disk encryption
• B. Enterprise Replication
• C. Column level encryption
• D. High-Availability Data Replication
• E. Server-to-server distributed query communication

Answer: BD

NEW QUESTION 7
Which feature can be enabled in Informix?

• A. Automatic addition of a CPU VP.
• B. Automatic addition of an ADM VP.
• C. Automatic extension of storage spaces.
• D. Automatic addition of message log files.

Answer: C

NEW QUESTION 8
Which objects can be compressed?

• A. CLOBs
• B. smart BLOBs
• C. partition BLOBs
• D. blobspace BLOBs

Answer: C

NEW QUESTION 9
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.

Answer: D

NEW QUESTION 10
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.

Answer: A

NEW QUESTION 11
Which two statements are true about Informix OpenAdmin Tool? (Choose two.)

• A. Informix OpenAdmin Tool does not support multiple languages.
• B. Ontape backup can be taken using Informix OpenAdmin Tool.
• C. Informix cluster cannot be managed using Informix OpenAdmin Tool.
• D. Informix OpenAdmin Tool cannot be used to run the equivalent of onstat commands.
• E. SQL explorer feature provides Query Drill Down functionality to analyze SQL statements.

Answer: BE

NEW QUESTION 12
Which is NOT a valid index fragmentation strategy?

• A. Fragment by Range
• B. Partition by Expression
• C. Fragment by Expression
• D. Fragment by Round Robin

Answer: D

NEW QUESTION 13
The total number of locks allocated equals the value specified by the LOCKS configuration parameter. What is the behavior of the database server when more locks are now requested?

• A. The user encounters a lock request error.
• B. More memory is allocated for additional lock structures from DS_TOTAL_MEMORY.
• C. More memory is allocated for additional lock structures in the VIRTUAL section of shared memory.
• D. More memory is allocated for additional lock structures in the RESIDENT section of shared memory.

Answer: C

NEW QUESTION 14
When using the deployment assistant, which two statements are true? (Choose two.)

• A. A java environment must be configured.
• B. The Informix user account must be used.
• C. Chunks can be raw devices or buffered files.
• D. The user must have connect permission to all databases.
• E. The user must have connect privilege to sysadmin database.

Answer: AE

NEW QUESTION 15
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

Answer: C

NEW QUESTION 16
Which Enterprise Replication command CANNOT be used on replicates that include TimeSeries columns?

• A. cdr start
• B. cdr sync
• C. cdr realize
• D. cdr remaster

Answer: D

NEW QUESTION 17
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.

Answer: D

NEW QUESTION 18
What are two requirements for the "ifxclone" utility? (Choose two.)

• A. All databases must use logging.
• B. The source server must be a secondary server.
• C. Only one server clone process can occur at a time.
• D. Both the source and target servers must be part of a trusted network environment.
• E. Both the source and target servers must use the same type of disk space (raw or cooked).

Answer: CD

NEW QUESTION 19
When executing the following command: execute function sysadmin task("table compress", "customer") what will happen to the customer table?

• A. Only newly added rows will be compressed.
• B. Only existing data will be compressed, new data will remain uncompressed.
• C. Row data and partition blobs will be compressed and any free table space will be released.
• D. Row data and partition blobs will be compressed and the space allocated to the table will remain.

Answer: C

NEW QUESTION 20
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.

Answer: B

NEW QUESTION 21
Which two tasks can be performed through an Informix Grid? (Choose two.)

• A. Install Informix products.
• B. Start Informix servers in a grid.
• C. Copy external files to grid servers.
• D. Setup replication automatically in a grid.
• E. Modify replication server attributes for grid servers.

Answer: CD

NEW QUESTION 22
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.

Answer: A

NEW QUESTION 23
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.

Answer: D

NEW QUESTION 24
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

Answer: A

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

• A. sqlhosts
• B. /etc/services
• C. $ONCONFIG
• D. /etc/hosts.equiv

Answer: D

NEW QUESTION 26
......