[Oct-2021] Pass IBM C2090-600 Exam in First Attempt Guaranteed!
Full C2090-600 Practice Test and 60 unique questions with explanations waiting just for you, get it now!
NEW QUESTION 16
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 17
Which statement regarding setting up a local keystore for DB2 native encryption is TRUE?
- A. If a local keystore is used to store data encryption keys, a stash file must be used to store master keys temporarily.
- B. A local keystore is not needed if a Hardware Security Module (HSM) is used to manage master keys.
- C. A master key must be generated and placed in an existing local keystore before a new encrypted database will be created.
- D. After a local keystore is created, you will be prompted for a password whenever the database manager accesses the keystore.
Answer: C
NEW QUESTION 18
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 DBM CFG USING DFT_MON_BUFPOOLON
- C. UPDATE DB CFG USING MON_OBJ_METRICS BASE
- D. UPDATE DB CFG USING MON_ACT_METRICS BASE
Answer: B
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. Create a local disk alias at the database server operating system level that points to IBM Softlayer Object Storage
- B. Catalog a storage access alias in the DB2 database
- C. Establish a remote connection to IBM Softlayer Object Storage using DB2 Connect
- D. Create an FTP account on IBM Softlayer Object Storage
- E. Use the DB2REMOTE parameter of the LOAD command
Answer: B,E
NEW QUESTION 20
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 21
Which DB2 Explain Facility tool uses the Explain tables to display access plain information?
- A. db2advis
- B. db2exfmt
- C. db2expln
- D. db2look
Answer: C
Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/support/knowledgecenter/SSEPGG_9.8.0/
com.ibm.db2.luw.admin.perf.doc/doc/c0005134.html
NEW QUESTION 22
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 23
Which of the following actions do you need to acquire the current encryption settings for a database protected by native encryption?
- A. Check the encrypted database parameter in database configuration
- B. Select from the ADMIN_GET_ENCRYPTION_INFO table function
- C. Run the db2ckbkp command and verify the compression settings
- D. Check ENCROPTS database configuration parameter for encryption options
Answer: D
Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/
com.ibm.db2.luw.admin.config.doc/doc/r0061750.html
NEW QUESTION 24
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 IN PLACE RESETDICTIONARY
- C. REORG TABLE sales ALLOW WRITE ACCESS REBUILDDICTIONARY
- D. REORG TABLE sales INPLACE REBUILDDICTIONARY
Answer: A
NEW QUESTION 25
What is the default value of the DB2 registry variable DB2LDAP_SEARCH_SCOPE?
- A. NONE
- B. LOCAL
- C. GLOBAL
- D. DOMAIN
Answer: C
Explanation:
Explanation/Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/ com.ibm.db2.luw.admin.dbobj.doc/doc/t0006033.html
NEW QUESTION 26
Which operation best describes the purpose of the SET INTEGRITY PRUNE operation?
- A. To prune the contents of a synopsis table.
- B. To prune the contents of a staging table.
- C. To prune the contents of a declared global temporary table.
- D. To prune the contents of a materialized query table (MQT).
Answer: B
NEW QUESTION 27
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 28
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 29
Which of the following statements about audit policies is TRUE?
- A. If a user is switched within a trusted connection, the applicable audit policies are re-evaluated for the new user without regard to audit policies for the original user.
- B. Audit policy changes are applied instantly and affect all inflight transactions.
- C. Multiple audit policies can be associated with the same table at the same time.
- D. The audit policy applied to a table is automatically applied to any view based on that table.
Answer: A
Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/support/knowledgecenter/SSPT3X_4.2.0/
com.ibm.swg.im.infosphere.biginsights.commsql.doc/doc/r0050609.html (note, 6th bullet)
NEW QUESTION 30
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 variable DB2_AUTORECLAIMSPACE=YES
Answer: A
Explanation:
Explanation/Reference: https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.perf.doc/ doc/c0061069.html
NEW QUESTION 31
Which ALTER TABLE statements will put a table named TAB1 in "reorg-pending" state? (Choose two.)
- A. ALTER TABLE tab1 ADD CONSTRAINT pk_tab1 PRIMARY KEY (col1)
- B. ALTER TABLE tab1 DROP COLUMN col1
- C. ALTER TABLE tab1 DETACH PARTITION part1 INTO tab_part1
- D. ALTER TABLE tab1 ALTER COLUMN col1 SET NOT NULL
- E. ALTER TABLE tab1 APPEND ON
Answer: B,D
NEW QUESTION 32
Which of the following are valid Explain operators? (Choose two.)
- A. COLSCAN
- B. CTQ
- C. IXSCAN
- D. SELECT
- E. XSCAN
Answer: C,E
NEW QUESTION 33
Which statement about label-based access control (LBAC) is TRUE?
- A. LBAC protection can be applied to a nickname
- B. LBAC cannot be used to restrict access to a staging table
- C. LBAC protection for columns requires a table to contain a column that has a DB2SECURITYLABEL data type
- D. LBAC cannot be used to restrict access to data of columns and rows in the same table
Answer: C
Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/
com.ibm.db2.luw.admin.sec.doc/doc/c0021495.html (protecting rows)
NEW QUESTION 34
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 35
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
NEW QUESTION 36
......
Get Latest C2090-600 Dumps Exam Questions in here: https://www.examprepaway.com/IBM/braindumps.C2090-600.ete.file.html