Renovate C2090-619 Training Materials 2021

NEW QUESTION 1
During the database server initialization process, a number of environment variables are required. What is the order of precedence if the -file option is used?

• A. User local shell, system global
• B. System global, user local shell
• C. System global, user local shell, onconfig file
• D. Onconfig file, user local shell, system global

Answer: D

NEW QUESTION 2
When free memory is limited, which configuration parameter should be set to allow critical database activities to complete successfully?

• A. LOW_MEMORY_SVR
• B. LOW_MEMORY_MGR
• C. LOW_MEMORY_RESERVE
• D. LOW_MEMORY_PRESERVE

Answer: C

NEW QUESTION 3
Which two statements are true about archecker utility? (Choose two.)

• A. Archecker can help developers team to debug procedures.
• B. Archecker can do backup testing, fully integrated with onbar and ontape utilities.
• C. Archecker can copy data from different servers, even restoring from a remote device.
• D. Archecker can use all kind of connections protocols, including shared memory connections.
• E. Archecker can do data restore (physical or logical) of database portions, table portions, or even a set of tables.

Answer: BE

NEW QUESTION 4
Which statement is NOT true about a Storage Pool?

• A. You can create multiple storage pools per database server.
• B. You can add, modify, delete, and purge storage pool entries.
• C. Priorities can be used to determine space allocation order.
• D. It consists of any combination of a raw device, a cooked file, or a directory.

Answer: A

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

Answer: D

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

Answer: B

NEW QUESTION 7
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 8
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 9
Which two statements are true? (Choose two.)

• A. Logical log files must always reside in rootdbs.
• B. Having too little log space does not affect performance.
• C. Having too much log space does not affect performance.
• D. Simple large objects in blobspaces are not logged and they are included in the log backup in which the object was created.
• E. Simple large objects in blobspaces are not logged and they are not included in the log backup in which the object was created.

Answer: CD

NEW QUESTION 10
Where must the HA_FOC_ORDER configuration parameter be set?

• A. Any server in the cluster.
• B. The primary server only.
• C. The SDS secondary only.
• D. The HDR secondary only.

Answer: B

NEW QUESTION 11
Given an OLTP environment with a very large table, which configuration parameter can be set to allocate more memory for sorting when building an index on the large table?

• A. DBUPSPACE
• B. DS_POOLSIZE
• C. VP_MEMORY_CACHE_KB
• D. DS_NONPDQ_QUERY_MEM

Answer: D

NEW QUESTION 12
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 13
Which statement about Storage Provisioning is true?

• A. Only raw devices can be extended.
• B. Only cooked devices can be extended.
• C. Only unmirrored spaces can be extended.
• D. Mirrored and unmirrored spaces can be extended.

Answer: C

NEW QUESTION 14
Which statement is true regarding default roles?

• A. The DBSA can define a default role to assign only to the PUBLIC group for a particular database.
• B. The privileges associated with a default role takes precedence over the privileges granted to an individual user.
• C. The DBSA can define a default role to assign to individual users or to the PUBLIC group for a particular database.
• D. When a user connects to a database, it is necessary to use the SET ROLE DEFAULT statement in order to gain the default role privileges.

Answer: C

NEW QUESTION 15
To potentially return unused extent pages to the chunk free list, an Informix administrator would execute which storage optimization operation?

• A. Shrink
• B. Repack
• C. Compress
• D. Defragment

Answer: A

NEW QUESTION 16
Role separation provides checks and balances to improve the security of your event- auditing procedures. Which two roles must be associated with group IDs to enable role separation? (Choose two.)

• A. DBSEC: DB Security Officer
• B. AAO: Auditing Analysis Officer
• C. DBASO: DB Audit and Security Officer
• D. DBAMO: DB Audit Management Officer
• E. DBSSO: Database System Security Officer

Answer: BE

NEW QUESTION 17
Which statement is FALSE?

• A. A new index can be created compressed.
• B. Attached indexes cannot be compressed.
• C. A compressed index can be uncompressed.
• D. A compressed index cannot be uncompressed.

Answer: C

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

Answer: A

NEW QUESTION 19
Which two logging modes are compatible between two databases participating in a distributed query? (Choose two.)

• A. ANSI and non-ANSI
• B. Buffered and Unbuffered
• C. Buffered and Non-logging
• D. Non-logging and Unbuffered
• E. Non-logging and Non-logging

Answer: BE

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

Answer: BC

NEW QUESTION 22
The DBA has defined the following configuration parameters in the onconfig file:

What are the actual values for LMM START THRESHOLD and LMM STOP THRESHOLD computed internally by the database server?

• A. LMM START THRESHOLD = 2MB and LMM STOP THRESHOLD = 3MB
• B. LMM START THRESHOLD = 20MB and LMM STOP THRESHOLD = 30MB
• C. LMM START THRESHOLD = 500MB and LMM STOP THRESHOLD = 333MB
• D. LMM START THRESHOLD = 2% and LMM STOP THRESHOLD = 3% of physicalmemory in the system

Answer: B

NEW QUESTION 23
Which threshold setting applies when configuring automatic memory management?

• A. SHMTOTAL
• B. BUFFERPOOL
• C. SHMVIRTSIZE
• D. DS_TOTAL_MEMORY

Answer: A

NEW QUESTION 24
......