C2090-600 Practice Exam Tests Latest Updated on Oct-2021
Pass C2090-600 Exam in First Attempt Guaranteed Dumps!
NEW QUESTION 30
Which two of the following functions of DB2 Workload Manager are restricted by license? (Choose two.)
- A. Creating service classes, service subclasses, and workloads
- B. Using or altering the default service classes and workloads
- C. Creating, using, or altering thresholds
- D. Creating, activating, stopping or dropping workload management event monitors
- E. Granting, altering, or revoking workload privileges
Answer: A,E
NEW QUESTION 31
What is an advantage of using range partitioned tables?
- A. Table data is automatically and continuously clustered, requiring minimal reorganization
- B. Ability to run utilities against the partitions in parallel
- C. Increased query performance through data partition elimination
- D. Block indexes are much smaller than RID indexes, providing better performance
Answer: C
Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-0605ahuja2/#query
NEW QUESTION 32
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 the default WITH CHECK OPTION is LOCAL on view V2.
- C. The insert will result in an error as it violates the WITH CHECK OPTION on view V2.
- D. The insert will succeed as there is no WITH CHECK OPTION on view V3.
Answer: C
NEW QUESTION 33
Which statement regarding event monitors is TRUE?
- A. Event monitors are used to obtain information about how a database system looks at a specific point in time
- B. Event monitors must always be started manually after activating a database
- C. Event monitor data can be reviewed while the event monitor is active
- D. Event monitors must write data to .EVT files before the data can be loaded into database tables
Answer: B
Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/ com.ibm.db2.luw.sql.ref.doc/doc/r0000915.html
NEW QUESTION 34
When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)
- A. The DFT_TABLE_ORG database configuration parameter is set to COLUMN.
- B. The AUTO_REORG database configuration parameter is set to NO.
- C. The PAGESIZE database configuration parameter is set to 32K.
- D. The INTRA_PARALLEL database manager configuration parameter is set to NO.
- E. The DFT_EXTENT_SZ database configuration parameter is set to 8.
Answer: A,D
NEW QUESTION 35
Which statement about the db2move command is TRUE?
- A. The LOAD actions can be run from a client machine.
- B. Tables containing GENERATED ALWAYS identity columns can be imported or loaded.
- C. Loading data into tables containing XML columns is only supported for the LOAD actions.
- D. Object ownership cannot be changed after a successful schema copy operation.
Answer: C
NEW QUESTION 36
What levels of authority are needed to create a storage group? (Choose two.)
- A. SQLADM
- B. SYSMAINT
- C. SYSADM
- D. SYSCTRL
- E. DBADM
Answer: C,D
Explanation:
Explanation/Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/ doc/r0058606.html
NEW QUESTION 37
Which phase of the LOAD utility is unique to loading column organized tables?
- A. LOAD
- B. ANALYZE
- C. DELETE
- D. BUILD
Answer: B
Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/support/knowledgecenter/en//SSEPGG_11.1.0/ com.ibm.db2.luw.admin.dbobj.doc/doc/t0061530.html (about this task)
NEW QUESTION 38
Which two of the following functions of DB2 Workload Manager are restricted by license? (Choose two.)
- A. Creating service classes, service subclasses, and workloads
- B. Using or altering the default service classes and workloads
- C. Creating, using, or altering thresholds
- D. Creating, activating, stopping or dropping workload management event monitors
- E. Granting, altering, or revoking workload privileges
Answer: A,E
Explanation:
Explanation/Reference: ftp://ftp.software.ibm.com/ps/products/db2/info/vr101/pdf/en_US/DB2WorkloadMgmnt- db2wlme1011.pdf (page 23)
NEW QUESTION 39
The HADR_TARGET_LIST parameter enables HADR to run in multiple standby mode. Which of the following statements are TRUE if HADR is active? (Choose two.)
- A. You can change the principal standby of the primary without first stopping HADR on the primary.
- B. You can remove the primary database from the target list of a standby although the standby is connected to the primary.
- C. You cannot dynamically update the HADR_TARGET_LIST configuration parameter for a standby unless you have enabled the HADR read standby feature.
- D. You cannot remove a standby from the list if it is connected to the primary. To disconnect a standby, simply deactivate it. The you can remove it from the primary's target list.
- E. The target list can contain IP addresses that are either IPv4, or IPv6, or a combination of the two.
Answer: A,D
Explanation:
Explanation/Reference: https://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.ha.doc/ doc/c0059996.html
NEW QUESTION 40
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. RUNSTATS ON TABLE sales IN PLACE AND INDEXES ALL;
- B. RUNSTATS ON TABLE sales AND INDEXES ALL; REORGCHK ON TABLE sales;
- C. REORG TABLE sales AND INDEXES ALL; RUNSTATS ON TABLE sales AND INDEXES ALL;
- D. REORG TABLE sales INPLACE; REORG INDEXES ALL FOR TABLE sales; RUNSTATS ON TABLE sales AND IN DEXES ALL;
Answer: C
NEW QUESTION 41
Which of the following are all valid types of trigger?
- A. ATOMIC, BEFORE, INSTEAD OF
- B. AFTER, ATOMIC, INSTEAD OF
- C. AFTER, BEFORE, INSTEAD OF
- D. AFTER, ATOMIC, BEFORE
Answer: C
Explanation:
Explanation/Reference: https://www.ibm.com/support/knowledgecenter/SSEPGG_9.8.0/com.ibm.db2.luw.admin.dbobj.doc/ doc/c0020224.html
NEW QUESTION 42
Which DB2 Explain Facility tool uses the Explain tables to display access plain information?
- A. db2advis
- B. db21ook
- C. db2exfmt
- D. db2expln
Answer: D
NEW QUESTION 43
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 ALLOW WRITE ACCESS RESETDICTIONARY
- B. REORG TABLE sales ALLOW WRITE ACCESS REBUILDDICTIONARY
- C. REORG TABLE sales INPLACE REBUILDDICTIONARY
- D. REORG TABLE sales INPLACE RESETDICTIONARY
Answer: A
NEW QUESTION 44
What is the main benefit of performing an ADMIN_MOVE_TABLE operation in multiple steps?
- A. It does not require additional temporary disk space
- B. It allows the ADMIN_MOVE_TABLE procedure to be used in HADR environments
- C. It does not acquire locks on the table
- D. It enables the user to control when the table will be offline
Answer: B
NEW QUESTION 45
Automatic space reclamation for column-organized tables can be accomplished in which of the following scenarios?
- A. After setting the database configuration parameter AUTO_DEL_REC_OBJ to ON
- B. When the registry variable DB2_WORKLOAD=ANALYTICS prior to database creation
- C. After termination all the back-end processes using TERMINATE command
- D. When the registry variableDB2_AUTORECLAIMSPACE=YES
Answer: A
NEW QUESTION 46
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. High cardinality of the dimension(s) chosen.
- C. The extent size is too small.
- D. Low cardinality of the dimension(s) chosen.
Answer: B
NEW QUESTION 47
What does dsmtop use to gather metrics?
- A. the system catalog
- B. db2dart
- C. db2pd
- D. monitoring table functions
Answer: D
NEW QUESTION 48
......
IBM Certified Database Administrator Free Certification Exam Material from TorrentValid with 60 Questions: https://www.torrentvalid.com/C2090-600-valid-braindumps-torrent.html