872 お客様のコメント
質問 1：
Which two statements are true for onbar only but not for ontape? (Choose two.)
A. It can back up to or restore from cloud storage.
B. It can restart a restore from the place it failed.
C. It can restore data to a given point in time (PIT).
D. It can execute an external backup and restore.
E. It can apply external programs using filters.
正解：B,C
質問 2：
When running an onstat -u, what does a 'Y' in the first column of the flags signify?
A. The userthread is waiting for end user I/O to complete.
B. The userthread is waiting for a thread to yield a cpu vp.
C. The userthread is waiting for a thread with a higher priority.
D. The userthread is waiting on a condition.
正解：D
質問 3：
To enable network encryption, what two steps must the administrator complete? (Choose two.)
A. Set the environment variable ENCCSMCFG to the name of the CSM.
B. Set the IFX_ENCCSM onconfig parameter to 1.
C. Enter the CSM name in the sqlhosts file.
D. Enter the CSM name in the onconfig NETTYPE parameter.
E. Define the CSM in the concsm.cfg configuration file.
正解：C,E
質問 4：
What is used during Fast Recovery to return pages to the original state?
A. External Tables
B. Temporary DBSpaces
C. Physical Log
D. Logical Log
正解：C
質問 5：
Assuming you have a table with a replicate defined. A Flexible Grid procedure is executed changing data in that table. What statement about replication of the changes is true?
A. The changes cannot be replicated.
B. The changes are replicated by default.
C. Only changes to primary key columns can be replicated.
D. You have to call ifx_set_erstate( ) to replicate changes.
正解：D
質問 6：
What does the SP_WAITTIME variable control?
A. The maximum time a user session will wait for a space extension to complete.
B. The maximum amount of wait time permitted before an automatic space allocation will begin.
C. The maximum amount of wait time for a reply from an H/A cluster secondary.
D. The maximum time allowed for distributed stored procedures to complete.
正解：A
質問 7：
What two parameters can affect how often checkpoints occur? (Choose two.)
A. BUFFERPOOL
B. LTAPEDEV
C. BAR_PROGRESS_FREQ
D. PHYSFILE
E. LOGSIZE
正解：D,E
質問 8：
Which statement about temporary dbspaces is FALSE?
A. Temporary dbspaces are not backed up.
B. A raw table can be created in a temporary dbspace.
C. Temporary dbspaces can have non-default page sizes.
D. Tables stored in temporary dbspaces are not logged.
正解：B
Which two statements are true for onbar only but not for ontape? (Choose two.)
A. It can back up to or restore from cloud storage.
B. It can restart a restore from the place it failed.
C. It can restore data to a given point in time (PIT).
D. It can execute an external backup and restore.
E. It can apply external programs using filters.
正解：B,C
質問 2：
When running an onstat -u, what does a 'Y' in the first column of the flags signify?
A. The userthread is waiting for end user I/O to complete.
B. The userthread is waiting for a thread to yield a cpu vp.
C. The userthread is waiting for a thread with a higher priority.
D. The userthread is waiting on a condition.
正解：D
質問 3：
To enable network encryption, what two steps must the administrator complete? (Choose two.)
A. Set the environment variable ENCCSMCFG to the name of the CSM.
B. Set the IFX_ENCCSM onconfig parameter to 1.
C. Enter the CSM name in the sqlhosts file.
D. Enter the CSM name in the onconfig NETTYPE parameter.
E. Define the CSM in the concsm.cfg configuration file.
正解：C,E
質問 4：
What is used during Fast Recovery to return pages to the original state?
A. External Tables
B. Temporary DBSpaces
C. Physical Log
D. Logical Log
正解：C
質問 5：
Assuming you have a table with a replicate defined. A Flexible Grid procedure is executed changing data in that table. What statement about replication of the changes is true?
A. The changes cannot be replicated.
B. The changes are replicated by default.
C. Only changes to primary key columns can be replicated.
D. You have to call ifx_set_erstate( ) to replicate changes.
正解：D
質問 6：
What does the SP_WAITTIME variable control?
A. The maximum time a user session will wait for a space extension to complete.
B. The maximum amount of wait time permitted before an automatic space allocation will begin.
C. The maximum amount of wait time for a reply from an H/A cluster secondary.
D. The maximum time allowed for distributed stored procedures to complete.
正解：A
質問 7：
What two parameters can affect how often checkpoints occur? (Choose two.)
A. BUFFERPOOL
B. LTAPEDEV
C. BAR_PROGRESS_FREQ
D. PHYSFILE
E. LOGSIZE
正解：D,E
質問 8：
Which statement about temporary dbspaces is FALSE?
A. Temporary dbspaces are not backed up.
B. A raw table can be created in a temporary dbspace.
C. Temporary dbspaces can have non-default page sizes.
D. Tables stored in temporary dbspaces are not logged.
正解：B
Matsunaga -
すごい。
Pass4Testの問題集は助かりました。A2090-919の本場試験に合格致しました。