Vivid of C2090-614 free exam materials and braindumps for IBM certification for client, Real Success Guaranteed with Updated C2090-614 pdf dumps vce Materials. 100% PASS DB2 10.1 Advanced DBA for Linux UNIX and Windows (C2090-614) exam Today!
2021 May C2090-614 Study Guide Questions:
Q31. Given the following database design:
A Explain plan shows that a broadcast join is being used by a query that joins the DATE_DIM dimension table and the SALES fact table. Which action should be performed to improve query performance?
A. Create a replicated summary table for the SALES table using the table space TS_REPL.
B. Create a replicated summary table for the DATE_DIM table using the table space TS_REPL.
C. Create an index on both the DATE_DIM and the SALES table for the column that is used in the collocated join.
D. Create a replicated summary table for the SALES table using the table space TS_DIM and create an index on the DATE_DIM table.
Answer: B
Q32. Which statement about Range Clustered Tables (RCT) is correct?
A. Storage space is not pre-allocated for an RCT.
B. The ALTER TABLE statement can be used to change the physical structure of an RCT.
C. When defining a range of key values for an RCT, a minimum value is optional.
D. The minimum value of a key column for an RCT cannot be a negative value.
Answer: C
Q33. Which diagnostic tool can be used to show high-watermark consumptions of Fast Communication Manager (FCM) buffers and channels?
A. db2pd
B. inspect
C. db2dart
D. db2mtrk
Answer: A
Rebirth C2090-614 exam prep:
Q34. What must be done to convert a populated base table to a multidimensional clustering (MDC) table?
A. Export the data, create an MDC table, and then import or load the data into the MDC table.
B. Execute the ALTER TABLE ... ORGANIZE BY DIMENSIONS statement to convert the table.
C. Create an MDC table and then move the data in the base table to the MDC table with the db2move command.
D. Export the data, execute the ALTER TABLE ... ORGANIZE BY DIMENSIONS statement to convert the table, and then import or load the datainto the converted table.
Answer: A
Q35. Which statement about value compression is correct?
A. To use value compression, you must have a license for the DB2 Storage Optimization Feature.
B. Value compression uses a page-level dictionary-based compression algorithm to compress data based on repetition of values found in a single column.
C. Value compression involves removing duplicate entries for a value, only storing one copy, and keeping track of the location of any references to the stored copy.
D. When value compression is used, the byte count of compressed NULLs, zeros, and blanks might be larger than that of the uncompressed version of the same values.
Answer: C
Q36. The following query is executed frequently against the SALES table: SELECT sales_id, sales_date, sales_person FROM sales; If data in the SALES_ID column is unique, which statement will create an index for optimal query performance and ensure uniqueness of the SALES_ID column?
A. CREATE INDEX sales_idx ON sales (sales_id, sales_date, sales_person)
B. CREATE UNIQUE INDEX sales_idx ON sales (sales_id, sales_date, sales_person)
C. CREATE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person)
D. CREATE UNIQUE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person)
Answer: D
High quality C2090-614 training tools:
Q37. Which statement about DB2 Merge Backup is FALSE?
A. It can be used to merge offline backups to build full offline table space backups.
B. It can be used to merge SNAPSHOT and TSM tape backup images to create a full database backup image.
C. It can be used merge multiple offline database backups to build a cumulative single offline database backup.
D. It can be used to merge backups on a machine that is different from the machine where the backup has been created in stand-alone mode.
Answer: B
Q38. A storage group named HOT_SG was created as follows:
What does the DATA TAG 1 clause do?
A. It indicates that the multiple storage paths referenced in the HOT_SG storage group definition exist in one physical location.
B. It tells the DB2 Optimizer that database objects stored in the HOT_SG storage group are to be given preference over other objects when data access plans are generated.
C. It indicates that the value 1 is to be assigned to data stored in the HOT_SG storage group, which Workload Manager (WLM) can then use to determine the processing priority to assign to database activities that interact with this data.
D. It assigns a unique identifier to the instance of the HOT_SG storage group being defined; this identifier can then be used when moving table spaces to and from the storage group, when dropping the storage group, or when commenting on the storage group.
Answer: C
Q39. Which table function can be used to determine whether all of a particular table space data objects have been moved from one storage group toWhich table function can be used to determine whether all of a particular table space? data objects have been moved from one storage group to another?
A. MON_GET_TABLESPACE
B. ADMIN_GET_STOGROUP_INFO
C. ADMIN_GET_STORAGE_PATHS
D. MON_GET_REBALANCE_STATUS
Answer: D
Q40. If the following statements are executed: CREATE STOGROUP sg_hot ON '/path1', '/path2', '/path3' CREATE STOGROUP sg_med ON '/path4', '/path5', '/path6' CREATE TABLESPACE tbsp1 USING STOGROUP sg_hot; What is the recommended way to move table space TBSP1 from storage group SG_HOT to storage group SG_MED?
A. Issue an ALTER TABLESPACE statement with the 'USING sg_med' option.
B. Issue an ALTER STOGROUP statement with the 'MOVE tbsp1 TO sg_med' option.
C. Perform a table space RESTORE operation with the 'USING STOGROUP sg_hot' option.
D. Use the ADMIN_MOVE_TABLESPACE procedure to move table space TBSP1 to SG_HOT.
Answer: A