After starting a series of LOAD operations it appears that one LOAD is failing. What diagnostic tool would you use to determine which LOAD operation is being problematic?
A. db2pd
B. db2dart
C. db2ls
D. db2fodc
正解:A
質問 2:
A DBA wants to create a table named SALES that has the following characteristics: ?effective data clustering and management of space utilization ?rows in the table should be clustered based on when they are added to the table Which clause must be used with the CREATE TABLE statement to define this table?
A. ORGANIZE BY TIME PERIOD
B. ORGANIZE BY DIMENSIONS
C. ORGANIZE BY INSERT TIME
D. ORGANIZE BY KEY SEQUENCE
正解:C
質問 3:
What type of file system is used to store data and logs in a DB2 pureScale environment?
A. Network File System (NFS)
B. Common Internet File System (CIFS)
C. Enhanced Journaled File System (JFS2 or EXT4)
D. General Parallel File System (GPFS)
正解:D
質問 4:
What is the FAILARCHPATH database configuration parameter used for?
A. To specify a path to which DB2 will attempt to store a copy of archive log files to protect against accidental deletion.
B. To specify a path to which DB2 will attempt to store a copy of both active and archive log files to protect against disk failure and power outages.
C. To specify a path that DB2 will use to look for archive log files that are needed for a rollforward recovery operation.
D. To specify a path to which DB2 will attempt to store archive log files if they cannot be written to the primary or secondary archive destination because of a media problem.
正解:D
質問 5:
A database administrator created all of the necessary federated objects for an SQL Server data source in a federated system. Which steps must be performed if the data types of several columns in the SQL Server data source are changed?
A. Drop the current user mapping. Drop the current data type mapping. Create the new user mapping. Create the new data type mapping. Recreate the nickname to the table.
B. Drop the nickname to the table. Create the new data type mapping. Recreate the nickname to the table.
C. Drop the current data type mapping. Create the new data type mapping. Drop the nickname to the table. Recreate the nickname to the table.
D. Drop the current data type mapping. Create the new data type mapping.
正解:B
質問 6:
Which diagnostic tool can be used to collect metrics on individual SQL statement executions?
A. A statement event monitor
B. The MON_GET_UNIT_OF_WORK_DETAILS table function
C. A snapshot monitor
D. db2dart
正解:A
970 お客様のコメント







堀内** -
Pass4Testの問題集は価格が安いのに電子版ももらえて素晴らしい。C2090-614試験用のテキストです。