Verified of C2090-737 test materials and bible for IBM certification for IT candidates, Real Success Guaranteed with Updated C2090-737 pdf dumps vce Materials. 100% PASS DB2 9 System Administrator for z/OS Exam exam Today!
2021 May C2090-737 Study Guide Questions:
Q1. Batch jobs regularly fail when they are in the process of inserting a large number of rows into a DECLARE GLOBAL TEMPORARY TABLE. (DGTT) Which two statements accurately describe what could be causing this problem? (Choose two.)
A. The table space that was selected to store the DGTT in the TEMP database is too small tostore all the rows of the DGTT.
B. The WORKFILE database is too small.
C. There is too much concurrent activity against the TEMP database to be able to handle all theDGTT activity that is going on.
D. The user is exceeding the maximum amount of temporary space that can be used by an agent(MAXTEMPS) DSNZPARM setting.
E. There are too many DB2 utilities running at the same time as the job inserting rows into theDGTT.
Answer: B,D
Q2. Click the Exhibit button.
In the exhibit, a customer has a two way data sharing group running with one internal coupling facility (ICF) and one external coupling facility (CF). The only CF structures allocated are the ones depicted in the exhibit. ICF1 is a volatile CF. No ARM policy is active. The customer experiences a power failure to CEC1. Which statement regarding the state of data sharing group DB2G is true?
A. Member DB2A will terminate but since this is a data sharing system, DB2B remains active andable to process work. DB2G_SCA will remain in CEC1 since it is in different partition thanLPAR1.
B. Member DB2A will automatically be restarted on CEC2 and work will continue to be processedby both members.
C. Member DB2A and member DB2B both abnormally terminate and are unable to process workuntil restarted.
D. Member DB2A will terminate, DB2B remains active and able to process work. StructureDB2G_SCA will be automatically rebuilt to the external CF.
Answer: C
Q3. Which statement is true about the use of Trusted Network Context and Roles?
A. Trusted Network Context and Roles does not require RACF.
B. Trusted Network Context and Roles allows a DBA to create and manage objects withoutownership.
C. Roles revoked from an authorization ID will trigger cascade revocation.
D. Roles cannot own objects.
Answer: B
Replace C2090-737 exams:
Q4. DB2 audit class trace records are externalized to which SMF record type?
A. 100
B. 110
C. 101
D. 102
Answer: D
Q5. What is a benefit of using the in-memory work file in DB2 9?
A. Improves performance using TEMP database.
B. Avoids I/Os for the declared global temporary tables.
C. Improves performance for small sorts.
D. Sorts a large number of rows faster.
Answer: C
Q6. A customer is performing a disaster recovery test using the RESTORE SYSTEM utility. Where would the BSDS be recovered from in this scenario?
A. The image copy data set of the catalog and directory.
B. The second data set created from the last -ARCHIVE LOG command.
C. The most current active log data set.
D. The SMS log copy pool backup.
Answer: D
High quality C2090-737 preparation labs:
Q7. Which two methods can be used to configure the use of a SSL secure port on a DB2 for z/OS server? (Choose two.)
A. Specify "Y" in the SECURE column of SYSIBM.SYSLOCATIONS.
B. Specify a secure port value in the PORT column of SYSIBM.SYSLOCATIONS.
C. Update the DDF statement in the BSDS using DSNJU003.
D. Specify the TCP/IP port number in the DRDA SECURE PORT field of the Distributed DataFacility Panel 2 (DSNTIP5).
E. Specify the value of the secure port in the DRDA PORT field of DSNTIP5.
Answer: C,D
Q8. Which privilege is required to use the ACCESS command?
A. DISPLAY
B. STARTDB
C. MONITOR
D. ACCESSDB
Answer: B
Q9. A thread that is no longer active in DB2 is causing -904 unavailable resource conditions for other executing applications. Which command could help alleviate the -904 condition caused by the non executing thread?
A. -RECOVER INDOUBT
B. -CANCEL THREAD
C. -RESET INDOUBT
D. F irlmproc,DEADLOK='1,1'
Answer: A
Q10. When implementing the DB2 for z/OS built-in encryption function, which facility will function incorrectly?
A. DB2 REORG utility
B. index only access to data
C. DB2 table space compression
D. DRDA
Answer: D