Best Quality C2090-600 Exam Questions IBM Test To Gain Brilliante Result!
Preparations of C2090-600 Exam 2021 IBM Certified Database Administrator Unlimited 60 Questions
NEW QUESTION 33
Which security mechanism is responsible for verifying that users are indeed who the claim to be?
- A. Discretionary access control
- B. Authentication
- C. Roles and privileges
- D. Mandatory access control
Answer: B
Explanation:
Explanation/Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/ com.ibm.db2.luw.admin.sec.doc/doc/c0005435.html
NEW QUESTION 34
Which of the following commands will list all of the disk configurations of the file system DATAFS in a DB2 pureScale cluster?
- A. db2cluster -cfs -listconfig -filesystem datafs
- B. db2cluster -cfs -list -filesystem datafs
- C. db2cluster -cfs -displayconfig -filesystem datafs
- D. db2cluster -cfs -display -filesystem datafs
Answer: B
NEW QUESTION 35
When querying the MON_GET_TABLESPACE table function, the values for many of the performance metrics like POOL_DATA_P_READS and POOL_DATA_L_READS are showing 0, even though there is activity occurring in the database. Which command must be executed to enable the table function to return actual data?
- A. UPDATE MONITOR SWITCHES USING BUFFERPOOL ON
- B. UPDATE DB CFG USING MON_OBJ_METRICS BASE
- C. UPDATE DB CFG USING MON_ACT_METRICS BASE
- D. UPDATE DBM CFG USING DFT_MON_BUFPOOL ON
Answer: D
NEW QUESTION 36
Which of the following statements about compression for BLU MPP tables is TRUE?
- A. Compression must be explicitly enabled for BLU MPP tables
- B. Unique compression dictionaries are generated for each partition
- C. Compression requires decompression to evaluate partition joins
- D. Each table has a single compression dictionary that getsreplicated across all partitions
Answer: D
NEW QUESTION 37
How would you enable self-tuning of memory areas that are controlled by memory configuration parameters?
- A. Set the SELF_TUNING_MEM database configuration parameter to ON using the UPDATE DATABASE CONFIGURATION command or the db2CfgSet API.
- B. 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.
- C. Set the DB2_WORKLOAD aggregate registry variable to ANALYTICS for self-tuning of the sort parameter on workloads that access column-organized tables.
- 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: A
Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/
com.ibm.db2.luw.admin.perf.doc/doc/t0021629.html (enabling self-tuning memory, procedure)
NEW QUESTION 38
Which statement about Data Server Manager (DSM) is TRUE?
- A. DSM cannot be used for database administration
- B. DSM can be used for configuration management of DB2 Data Server drivers
- C. DSM can be used to efficiently monitor, analyze, identify, and solve a performance issue
- D. DSM can be used for reviewing audit trails
Answer: C
Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-1503db2-data-server/ index.html (conclusion)
NEW QUESTION 39
If the following SQL statements are executed:
How many rows will be added to the DEPARTMENT table?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
NEW QUESTION 40
Where does the DB2 Problem Determination tool (db2pd) get information from?
- A. DB2memory sets
- B. Monitoring table functions
- C. the db2diag.log file
- D. A set of pre-defined event monitors
Answer: A
NEW QUESTION 41
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: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/ doc/r0000915.html
NEW QUESTION 42
A table named MYTABLE contains an XML column and an XML storage object dictionary already exists.
What is the effect of enabling compression and then running the command REORG TABLE mytable
KEEPDICTIONARY?
- A. Existing data will remain uncompressed because the RESETDICTIONARY option of the REORG command was not used.
- B. All data, both new and existing, will be compressed.
- C. Only new or updated data for XML columns will be compressed.
- D. New and existing XML columns will be compressed but other columns remain unchanged.
Answer: A
NEW QUESTION 43
On Linux and Unix systems, which of the following will set the DB2_FMP_COMM_HEAPSZ registry variable to 1 GB (or 256000 pages), only for the instance db2inst1?
- A. As the db2 instance owner (db2inst1) execute the command:
export DB2_FMP_COMM_HEAPSZ=256000 - B. As the db2 instance owner (db2inst1) execute the command:
db2set -i db2inst1 DB2_FMP_COMM_HEAPSZ=256000 - C. Add to the following line to the userprofile (db2inst1): DB2_FMP_COMM_HEAPSZ=256000
- D. As the db2 instance owner (db2inst1) execute the command:
db2set -i DB2_FMP_COMM_HEAPSZ=256000
Answer: D
NEW QUESTION 44
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. TRANSPORT
- C. IMPORT
- D. INGEST
Answer: C
NEW QUESTION 45
Which of the following enables the user to connect to the HADR standby database and execute select statements?
- A. HADR_SPOOL_LIMIT
- B. DB2_HADR_ROS
- C. DB2_HADR_PEER_WAIT_LIMIT
- D. DB2_HADR_SOSNDBUF
Answer: B
Explanation:
Explanation/Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-1205hadrstandby/
NEW QUESTION 46
If the following SQL statements are executed:
How many rows will be added to the DEPARTMENT table?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
NEW QUESTION 47
You suspect there is a communications issue between a member and a cluster caching facility (CF) in a
DB2 pureScale instance. Which command will provide diagnostic information that can be used to confirm your suspicions?
- A. db2cluster -cm -list -alert
- B. db2cluster -cm -verify -resource
- C. db2cluster -verify -configuration
- D. db2cluster -verify
Answer: B
NEW QUESTION 48
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
NEW QUESTION 49
For any given column-organized user table, the associated synopsis table may contain information for which of the following data types? (Choose two.)
- A. DATETIME
- B. BLOB
- C. VARCHAR
- D. XML
- E. CLOB
Answer: A,C
Explanation:
Explanation/Reference: https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/ com.ibm.db2.luw.admin.dbobj.doc/doc/c0061454.html
NEW QUESTION 50
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 AND INDEXES ALL;
REORGCHK ON TABLE sales; - B. RUNSTATS ON TABLE sales INPLACE AND INDEXES ALL;
- 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 INDEXES ALL;
Answer: C
NEW QUESTION 51
Which security mechanism is responsible for verifying that users are indeed who the claim to be?
- A. Discretionary access control
- B. Authentication
- C. Roles and privileges
- D. Mandatory access control
Answer: B
Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/ com.ibm.db2.luw.admin.sec.doc/doc/c0005435.html
NEW QUESTION 52
What does dsmtop use to gather metrics?
- A. the system catalog
- B. db2dart
- C. db2pd
- D. monitoring table functions
Answer: D
NEW QUESTION 53
Which options are valid for an online reorganization operation?
- A. CLASSIC and RECLAIM EXTENTS
- B. FULL and RECLAIM EXTENTS
- C. FULL and CLEANUP OVERFLOWS
- D. CLEAN OVERFLOWS and RECLAIM EXTENTS
Answer: B
NEW QUESTION 54
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
NEW QUESTION 55
......
Focus on C2090-600 All-in-One Exam Guide For Quick Preparation: https://www.free4dump.com/C2090-600-braindumps-torrent.html