Validated C2090-619 Practice 2021

NEW QUESTION 1
Which step must be performed to enable Secure Socket Layer (SSL) connections to Informix?

• A. Configure encrypt virtual processors in the ONCONFIG file.
• B. Configure poll threads for SSL connections in the ONCONFIG file.
• C. Specify the SSL connection protocol in the sqlhosts file or registry entry.
• D. Specify the name of the label of the server digital certificate in the ONCONFIG file.

Answer: C

NEW QUESTION 2
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 3
The Rolling Window clause of the ALTER FRAGMENT MODIFY INTERVAL statement CANNOT define a purging policy on a table that has which two attributes? (Choose two.)

• A. The table has a ROWID shadow column.
• B. The table has a Fragment By Range index.
• C. The table has a Unique Key being used by ER.
• D. The Fragment Key is defined with multiple columns.
• E. The Primary Key for the table is referenced by a foreign key constraint.

Answer: AE

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

Answer: C

NEW QUESTION 5
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 6
Which storage manager allows specification of a larger size than others for BAR_XFER_BUF_SIZE?

• A. Informix Storage Manager (ISM)
• B. Informix Primary Storage Manager (PSM)
• C. Informix Secondary Storage Manager (ISSM)
• D. Informix Archive Restore Storage Environment (IARSE)

Answer: B

NEW QUESTION 7
Which Informix utility can be used to customize the onconfig file?

• A. ifxdeploy
• B. genoncfg
• C. dbaccess
• D. onparams

Answer: B

NEW QUESTION 8
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 9
Which statement accurately describes the selective row-level auditing feature in Informix?

• A. Auditing can be configured so that row-level events of only selected views are recorded in the audit trail.
• B. Auditing can be configured so that row-level events of only selected tables are recorded in the audit trail.
• C. Auditing can be configured so that events of only selected rows within a table are recorded in the audit trail.
• D. Auditing can be configured so that row-level events of only selected partitions are recorded in the audit trail.

Answer: B

NEW QUESTION 10
What command unlocks the storage catalogs when using the Primary Storage Manager?

• A. onbar -d unlock
• B. onpsm -C unlock
• C. onmode -C unlock
• D. onsmsync -c unlock

Answer: B

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

Answer: AC

NEW QUESTION 12
When you take a level 2 backup, what data is backed up?

• A. All new data since the last level 1 backup.
• B. All new data since the last level 2 backup.
• C. All logical logs which have not previously been backed up.
• D. All new data since the last level 0, level 1 or level 2 backup.

Answer: A

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

Answer: B

NEW QUESTION 14
Which statement is FALSE about dbspace configurable page sizes?

• A. Dbspace page size can only be set for non-critical dbspaces.
• B. Possible page sizes are multiples of the default page size up to 16 kb.
• C. Configure page sizes as close to the backup / restore and network buffer size as possible for efficient data transfer across the wire.
• D. Dbspace page size should be configured to accommodate the greatest number of average row sizes with a minimum of remainder pages being used.

Answer: C

NEW QUESTION 15
Which parameter can automatically adjust other configuration parameters that are not present in the configuration file?

• A. AUTO_PERF
• B. AUTO_TUNE
• C. AUTO_CONFIG
• D. AUTO_ENABLE

Answer: B

NEW QUESTION 16
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 17
When the server is in administration mode, which users are NOT allowed to connect?

• A. informix
• B. Members of the DBSA group
• C. Members of the DBSSO group
• D. Users specified by ADMIN_MODE_USERS

Answer: C

NEW QUESTION 18
In an organization, all employees are authenticated via domain wide Kerberos single sign- on. The DBSA wants to provide access to the database server for an employee without requesting the Operating System (OS) administrator to create a OS level user account. Which Informix feature does the DBSA need to leverage?

• A. Mapped users
• B. Role based users
• C. Table level access for users
• D. Label based access for users

Answer: A

NEW QUESTION 19
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 20
When configuring Informix server for DRDA connection, which statement is true?

• A. The connection protocol must be drsoctcp.
• B. The database server name for DRDA connection must correspond to the DBSERVERNAME onconfig parameter.
• C. The database server name for DRDA connection must correspond to the DBSERVERALIASES onconfig parameter.
• D. The database server name should correspond to either the DBSERVERNAME or the DBSERVERALIASES onconfig parameter.

Answer: C

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

Answer: B

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
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 24
......