NEW QUESTION 1
You receive a large data file that contains large object data values that need to be copied into a table in the shortest amount of time possible. Which utility should be used?

• A. LOAD
• B. INGEST
• C. IMPORT
• D. TRANSPORT

Answer: C

NEW QUESTION 2
What is the schema name of the DB2 built-in global variable TRUSTED_CONTEXT?

• A. SYSIBM
• B. SYSFUN
• C. SYSCAT
• D. SYSIBMADM

Answer: A

NEW QUESTION 3
When operating in NPS compatibility mode, which of the following are limitations for using a routine written in NZPLSQL? (Choose two.)

• A. The routine cannot contain comments.
• B. The routine must return either an integer or a null.
• C. The routine must be cross-compatible with Oracle PL/SQL syntax rules.
• D. The routine cannot contain argument lists or variable arguments (varargs).
• E. The routine must be generated with IBM Database Conversion Workbench (DCW).

Answer: BD

NEW QUESTION 4
A DBA has observed that queries executed against SALES table have poor performance. DB2 tools have indicated that the level of data fragmentation in the SALES table is very high. Similar results were detected for indexes defined on the SALES table.
Which of the following commands should be used by the DBA to improve the performance of the queries run against the SALES table?

• A. REORG TABLE sales AND INDEXES ALL;RUNSTATS ON TABLE sales AND INDEXES ALL;
• B. REORG TABLE sales INPLACE;REORG INDEXES ALL FOR TABLE sales;RUNSTATS ON TABLE salesAND INDEXES ALL;
• C. RUNSTATS ON TABLE sales AND INDEXES ALL;REORGCHK ON TABLE sales;
• D. RUNSTATS ON TABLE sales INPLACE AND INDEXES ALL;

Answer: A

NEW QUESTION 5
An HADR environment has two standby databases – one principal and one auxiliary. What is the only mode that can be used to transfer data to the auxiliary standby?

• A. SYNC
• B. ASYNC
• C. NEARSYNC
• D. SUPERASYNC

Answer: D

NEW QUESTION 6
Which of the following statements is TRUE?

• A. REORGCHK automatically runstables reorganization.
• B. REORGCHK uses only current table and index statistics.
• C. REORGCHK can only be used for user tables, not for system tables.
• D. REORGCHK can be used to verify the level of data fragmentation and indicate whether reorganization might be required.

Answer: B

NEW QUESTION 7
Given the following:

What will be the result of the following SQL statement? INSERT INTO v3 (col1) values (30);

• A. The insert will succeed as it passes validation.
• B. The insert will succeed as there is no WITH CHECK OPTION on view V3.
• C. The insert will result in an error as it violates the WITH CHECK OPTION on view V2.
• D. The insert will succeed as the default WITH CHECK OPTION is LOCAL on view V2.

Answer: C

NEW QUESTION 8
What is the result of the following scenario?

• A. The row is updated to (2, NULL)
• B. The row is updated to (2, 110.00)
• C. SQL0407N Assignment of a NULL value to a NOT NULL column is not allowed
• D. The CREATE TRIGGER statement will fail because amt is defined as NOT NULL

Answer: B

NEW QUESTION 9
Automatic space reclamation for column-organized tables can be accomplished in which of the following scenarios?

• A. When the registry variableDB2_AUTORECLAIMSPACE=YES
• B. After termination all the back-end processes using TERMINATE command
• C. After setting the database configuration parameter AUTO_DEL_REC_OBJ to ON
• D. When the registry variable DB2_WORKLOAD=ANALYTICS prior to database creation

Answer: C

NEW QUESTION 10
Which phase of the LOAD utility is unique to loading column organized tables?

• A. LOAD
• B. BUILD
• C. DELETE
• D. ANALYZE

Answer: D

NEW QUESTION 11
How would you enable self-tuning of memory areas that are controlled by memory configuration parameters?

• A. Set the DB2_WORKLOAD aggregate registry variable to ANALYTICS for self-tuning of the sort parameter on workloads that access column-organized tables.
• B. Set the SELF_TUNING_MEM database configuration parameter to ON using the UPDATE DATABASECONFIGURATION command or the db2CfgSet API.
• C. Set the sortheap or the sheapthres_shr configuration parameters to AUTOMATIC using the UPDATE DATABASE CONFIGURATION command or the db2CfgSet API with sheapthres set to at least 4K.
• D. Use AUTOMATIC keyword for the buffer pool size on the CREATE BUFFERPOOL statement or the ALTER BUFFERPOOL statement after making sure that at least one entry is present in SYSCAT.BUFFERPOOLDBPARTITIONS.

Answer: B

NEW QUESTION 12
Assuming no database connections exist, which of the following will dynamically change the LOCKLIST database configuration parameter for a database named SAMPLE to AUTOMATIC?

• A. UPDATE DB CFG FOR sample USING LOOCKLIST AUTOMATIC IMMEDIATE
• B. UPDATE DB CFG FOR sample USING LOOCKLIST 8192 AUTOMATIC IMMEDIATE
• C. CONNECT TO sample;UPDATE DB CFG FOR sample USINGLOCKLIST AUTOMATIC IMMEDIATE;CONNECT RESET;
• D. ATTACH TO db2inst1;UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC;DETACH;

Answer: C

NEW QUESTION 13
Where does the DB2 Problem Determination tool (db2pd) get information from?

• A. DB2memory sets
• B. the db2diag.log file
• C. Monitoring table functions
• D. A set of pre-defined event monitors

Answer: A

NEW QUESTION 14
Which statement about NOT ENFORCED unique constraints is TRUE?

• A. NOT ENFORCED unique constraints can not be defined on primary key columns
• B. The query optimizer will consider a NOT ENFORCED unique constraint when selecting an optimal data access plan
• C. When attempting to insert data that does not conform to a NOT ENFORCED unique constraint, awarning will be returned
• D. Storage requirements for a NOT ENFORCED unique constraint are no different than the storage requirements for a similar unique index

Answer: A

NEW QUESTION 15
If the following SQL statements are executed:
CREATE DATABASE testdb AUTOMATIC STORAGE NO;
CONNECT TO testdb;
CREATE STOGROUP sg1 ON ‘/data1’;
CREATE STOGROUP ibmstogroup ON ‘/data2’; CREATE STOGROUP sg2 ON ‘/data3’;
Which storage group is the default storage group for the TESTDB database?

• A. SG1
• B. SG2
• C. IBMSTOGROUP
• D. IBMDEFAULTTSG

Answer: C

NEW QUESTION 16
The DBA has observed that queries executed against SALES table have poor performance. SALES is a compressed table and recently there have been a lot of rows inserted and modified in that table. The DBA has detected that lower performance may be the result of sub-optimal compression dictionary for that table.
Which of the following commands should be used to resolve the problem without preventing users from changing data in the SALES table

• A. REORG TABLE sales INPLACE RESETDICTIONARY
• B. REORG TABLE sales INPLACE REBUILDDICTIONARY
• C. REORG TABLE sales ALLOW WRITE ACCESS RESETDICTIONARY
• D. REORG TABLE sales ALLOW WRITE ACCESS REBUILDDICTIONARY

Answer: C

NEW QUESTION 17
When choosing the dimensions for an MDC table, poor space utilization can occur due to low cell density. What can cause an MDC table to use much more space?

• A. The page size is too small.
• B. The extent size is too small.
• C. Low cardinality of the dimension(s) chosen.
• D. High cardinality of the dimension(s) chosen.

Answer: D

NEW QUESTION 18
Which data types are only valid when DB2_COMPATIBILITY_VECTOR=ORA? (Choose two.)

• A. XML
• B. REAL
• C. NUMBER
• D. VRCHAR2
• E. VARBINARY

Answer: CE

NEW QUESTION 19
Which two tasks must be done to read data directly from IBM Softlayer Object Storage and insert it into a DB2 database? (Choose two.)

• A. Catalog a storage access alias in the DB2 database
• B. Create an FTP account on IBM Softlayer Object Storage
• C. Use the DB2REMOTE parameter of the LOAD command
• D. Establish a remote connection to IBM Softlayer Object Storage using DB2 Connect
• E. Create a local disk alias at the database server operating system level that points to IBM Softlayer Object Storage

Answer: AC

NEW QUESTION 20
Which is the correct way to back up only metadata about database backups, table space backups, and table load operations for database MYDB?

• A. CONNECT TO mydbPRUNE HISTORY TO /outdir
• B. db2trc on –db mydb –m “backup,load”run the desired operationsdb2tc dumpdb2trc.dmpdb2tc format db2tc.dmp db2tc.fmtdb2tc off
• C. BACKUP DATABASE mydb NO TABLESPACE TO /outdir
• D. db2setDB2_BCKP_PAGE_VERIFICATION=TRUE must be issued first (no instance restart is needed).Run the desired operations.Afterwards, issue db2trc dump <outfile>

Answer: B

NEW QUESTION 21
The DBA is concerned about a new application potentially corrupting a set of tables in table space TS1 in database DB1. TAB1 is a table in TS1. The DBA performs the following commands before running the application. The first QUIESCE completes at time “pit”.
BACKUP DATABASE DB1 TABLESPACE (TS1) ONLINE QUIESCE TABLESPACES FOR TABLE tab1 EXCLUSIVE QUIESCE TABLESPACES FOR TABLE tab1 RESET
Which of the following is TRUE?

• A. The QUIESCE EXCLUSIVE is recorded in the History File once the QUIESCE RESET completes.
• B. Once the first QUIESCE completes, there are no runningtransactions involving tab1, but there might be running transactions against other tables in TS1.
• C. After application corruption, the DBA restores a backup of TS1 and issues ROLLFORWARD DATABASE TO pit AND COMPLETE TABLESPACE (ts1) ONLINE.There might besome uncommitted data in TS1.
• D. After application corruption, the DBA restores a backup of TS1 and issues ROLLFORWARD DATABASE TO pit AND COMPLETE TABLESPACE (ts1) ONLIN
• E. Thisensures none of the application changes were applied.

Answer: D

NEW QUESTION 22
Which of the following statements about compression for BLU MPP tables is TRUE?

• A. Compression must be explicitly enabled for BLU MPP tables
• B. Compression requires decompression to evaluate partition joins
• C. Unique compression dictionaries are generated for each partition
• D. Each table has a single compression dictionary that getsreplicated across all partitions

Answer: D

NEW QUESTION 23
What levels of authority are needed to create a storage group? (Choose two.)

• A. DBADM
• B. SYSADM
• C. SQLADM
• D. SYSCTRL
• E. SYSMAINT

Answer: BD

NEW QUESTION 24
Which operation can be performed with trusted context privileges that are acquired through a role?

• A. DML operations
• B. DDL operations
• C. Server maintenance operations
• D. Security administration operations

Answer: A

NEW QUESTION 25
Which statement about the db2move command is TRUE?

• A. The LOAD actions can be run from a client machine.
• B. Object ownership cannot be changed after a successful schema copy operation.
• C. Tables containing GENERATED ALWAYS identity columns can be imported or loaded.
• D. Loading data into tables containing XML columns is only supported for the LOAD actions.

Answer: D

NEW QUESTION 26
......