최신 C2090-619 무료덤프 - IBM Informix 12.10 System Administrator

문제1

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. Server-to-server distributed query communication

C. Column level encryption

D. Enterprise Replication

E. High-Availability Data Replication

정답: D,E

문제2

Which is a valid Pluggable Authentication Module (PAM) mode in Unix?

A. Password mode

B. Client mode

C. Login mode

D. Server mode

정답: A

문제3

An Informix server is configured with multiple CPU VPs and poll threads and is experiencing NSF lock errors. What action should be taken to reduce the network shared file lock contention?

A. Increase the value of NUMFDSERVERS and increase the number of MSC VPs.

B. Increase the network buffer pool using the IFX_NETBUF_PVTPOOL_SIZE environment variable.

C. Increase the value of MAX_INCOMPLETE_CONNECTIONS.

D. Increase the value of NUMFDSERVERS and add more poll threads.

정답: D

문제4

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. Table level access for users

B. Role based users

C. Mapped users

D. Label based access for users

정답: C

문제5

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

A. Row data and partition blobs will be compressed and any free table space will be released.

B. Row data and partition blobs will be compressed and the space allocated to the table will remain.

C. Only newly added rows will be compressed.

D. Only existing data will be compressed, new data will remain uncompressed.

정답: A

문제6

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 refer to a subset of the tables in the AQT.

B. The table references or joins specified in the query or query block must be the same as the references in the data mart definition.

C. The query or query block must include at least 2 fact tables.

D. The scalar and aggregate functions in the query or query block must be supported by the Informix Warehouse Accelerator.

정답: C

문제7

The purge policy CANNOT be executed for a rolling window table utilizing which method?

A. By setting up the server to automatically run the purge policy.

B. By calling the syspurge function.

C. By the purge_tables task of the Scheduler.

D. By running ALTER FRAGMENT with the PURGE NOW predicate.

정답: D

문제8

Which option is available through ifx_grid_connect()?

A. Defer propagation of DDL statements to other servers in the grid.

B. Enable use of TimeSeries columns in tables.

C. Rename a replicated database.

D. Enable automatic creation of templates in a grid.

정답: A

문제9

Which statement accurately describes the mapped user functionality in Informix?

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

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

C. The DBSA can control the access to the database at the table level by creating different security labels for each user.

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

문제10

Which two statements are true about blobspace? (Choose two.)

A. The TEXT or BYTE objects that are assigned to a blobspace are physically logged.

B. A newly created blobspace is immediately available for storage of TEXT or BYTE data.

C. The database server writes data stored in a blobspace directly to disk without passing it through the bufferpool.

D. A blobspace is a logical storage unit that stores only TEXT and BYTE data.

E. The TEXT or BYTE objects are stored in the logical log files.

정답: C,D

최신 C2090-619 무료덤프 - IBM Informix 12.10 System Administrator

우리와 연락하기

유용한 링크

최신 업데이트